Two Datasources utilizing one Domain

[jwebber]

In our environment we are looking to pull data from two datasources (running on the same server or possibly different servers) but are both identical in regards to their tables ( = they can use the same domain). Is there an easy approach to this?  I've attempted to achieve this using a virtual datasource, but I then have to go through and create a 'custom' domain for the tables in each datasource, even though they are identical, this has thus far given me some trouble since their names are identical.

Any suggestions? 

[djohnson53]

You only have two alternatives.   Using a Virtual Datasource or creating an ETL process that accumulates the data from the two DBs into one.

[elizam]

Are you attempting to combine the data in the same Domain, or are you attempting to reuse the Domain with different databases?  

[jwebber]

In takign the route of using a Virtual DataSource I have to create derived tables for each table ( we have a lot of tables) since they are identical it just becomes redundant. Is there any easy method to bypass this?

[jwebber]

I'd imagine we could combine the data. Since our fields would allows us to filter out the data between the two databases. However, the latter would be preferred overall.

I'll add the domains are identical to the letter. In most scenarios laid out in the guides, this isn't the case. Just wondering if a there is an alternative method for our scenario.

 

[elizam]

That's what I thought. What you might try is:

 

1. Make two JRS datasources, with the two different database connections. give them different names, like Thing1 and Thing2

 

2. Make your domain for one datasource, say Thing1, with all your joins and derived tables.

 

3. Export the domain, which creates an XML file you can edit.

 

4. Edit the file and replace Thing1 with Thing2.

 

I would test this with a vanilla domain first, before you've done all your work, just to make sure you can do it. There may be many instances of Thing1, but in a text editor it is a global replace.

 

5. Upload the file as a new domain.

 

There may also be a way to do this using custom datasources, but once I've said that, I've said all I know.

[jwebber]

Great, will give it a try. Thanks!

[jwebber]

Yes, easy enough and worked. Now in the case of of using a single Domain for two databases (datasources), is there a workaround to this as well? We may see both scenarios in the future.

[elizam]

I don't know any tricks for combining two "identical" datasources in a single domain. Since you are not the only person in this situation, it can be hoped that there will be some work on this in the future.