Forum Stats

  • 3,872,812 Users
  • 2,266,479 Discussions
  • 7,911,327 Comments

Discussions

Direct DB Request- Connect to2 schemas using 2 connections pools at a time?

Hello All,

Will “Direct Database Request” feature helps to connect to two connection pools at a time?

Report output is based on UNION of two select statements coming from two schemas, two connection pools are created to connect to two Schemas

First select statement is coming from one schema and second select statement is coming form the other

Select column1, column2, column3 from A, B, C
UNION
Select column4, column5, column6 from X, Y, Z

A, B, C tables are coming from first schema and X, Y, Z are coming from the other

How to get the above out put using “Direct Database Request” feature

Regards,
SMA
Tagged:

Best Answer

  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    This is a very bad idea. If you connect to the same database then it will much better to simply do synonyms and grants between the objects schema1 to schema2 so that you can use a single connection. You query will run much faster since the BI Server will not need to run separate queries to stich the data together. If the data is two different databases then you are advised to do some ETL and consolidate all the data into your datawarehouse database.

Answers

  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    This is a very bad idea. If you connect to the same database then it will much better to simply do synonyms and grants between the objects schema1 to schema2 so that you can use a single connection. You query will run much faster since the BI Server will not need to run separate queries to stich the data together. If the data is two different databases then you are advised to do some ETL and consolidate all the data into your datawarehouse database.
  • 645922
    645922 Member Posts: 85
    Thank you very much for your kind reply Turribeach


    Regards,
    SMA
This discussion has been closed.