Multiple Databases in one Data Source

Edgardo J Perez Rios shared this question ago

Answered

Hi Jared,

I don't think its possible but, is their a way to connect various databases in one data source or do I have set multiple data sources for those databases?

The same question

Replies (3)

Nathan Goddard ●

Hello Edgardo,

Thank you for reaching out to us.

Each data sources has to be a single database, if you wanted to connect data from multiple data sources you could created these data sources and views and then use an Advanced Sub Query within a report to join to another data source > View.

Below are links to further information on this process;

Sub Queries

Advanced Sub Query

I hope this helps.

Kind regards,

Nathan Goddard

Reply URL

Edgardo J Perez Rios ●

Hi Nathan,

Thanks for the clarification, I'll look into that.

Regards,

Edgardo

Reply URL

Nathan Goddard ●

Hi Edgardo,

Thank you for getting back to me. For the time being I will mark this question as answered.

If you have any further questions regarding this process please do get in touch.

Kind regards,

Nathan Goddard

Reply URL