Using multiple datasources for creating QS using SQL queries

[saumil287]

Hi All,

I am creating query subjects using the queries containing joins from multiple databases (2 or 3) provided by a client.

The requirement is , They want a prompt for the schema datasource while executing queries.

Since Currently they are using 3 databases say A, B, C.
They want the same queries to fetch data from D, E, F resp

All tablenames, structures are same in A,B,C with D,E,F.

Any guidance is appreciated.

Thanks in advance

[blom0344]

Each datasource can be used with 1 or more connections. The connection points to the required database. This way , at runtime you are prompted to choose a connection IF more than one is defined. Use Cognos administration to add a connection to a datasource

[saumil287]

Hi Blom,

Thank you for your reply.

I am havin a qury which fetches data from multiple schemas having left outer join
So how Do I go about it.

A query containing one schema is working properly but need about multiple schemas in 1 query

Thanks

[blom0344]

If you prefer to stay away from using native SQL within query subjects, then you would need additional datasources. In the datasource definition you can define the specific schema name

[saumil287]

Hi Blom,

Thanks for your reply. I will try and let you know.


Thanks again