Skip to Content
avatar image
Former Member

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 05, 2015 at 07:09 AM

    It is possible in IDT. You can define override connections in IDT for difderent user groups using Data Security Profiles. Please take a look at Securing universes in the below link - http://scn.sap.com/docs/DOC-8461

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      How about the below approach?

      Assuming that you have these databases sitting in separate servers,

      - Setup DB links using Linked Server in one of the server

      - Create database views to merge the data from all three databases

      - Use Override Tables option for the Administrator groups to point to the view

  • avatar image
    Former Member
    Oct 01, 2015 at 11:31 AM

    You can certainly do it in the UDT using connection management functionality within the manage security section. You may be able to apply the same logic to the IDT, but I've never checked

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 10:05 AM

    The DBs are hosted on the same SQL server

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      How about creating a view that brings data from these databases together and used as the override for administrators group?