Single Schema for different DBs
Is it possible in IDT to have multiple dynamically allocated connections for several identical database schemas ?
Essentially, what we would like to do is to have a single Data Foundation with only one set of tables, but with the ability to run the same SQL query several times, against different databases, which have the same structure. For example, a query to extract data from different standard build warehouses, each for a different client. Another example would be to compare data between several identically built Test and Prod environments, to see if there are any data differences.
This would have the same effect as using data from multiple identically built universes in Webi via Merge Dimensions, but without the need to have multiple sets of tables added into IDT Data Foundation each time a new client or environment is required.
Is such dynamically allocated connectivity without the need for additional sets of cloned tables possible in IDT ?