Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 ?

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question