Multiple Databases in one Data Source

Edgardo J Perez Rios shared this question 7 months 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?

Comments (3)

photo
1

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

photo
1

Hi Nathan,

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

Regards,


Edgardo

photo
1

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