How to add 2 table from 2 different data sources

[Sarayucog]

Hi All,

I have mutiple data sources like MY SQL and Oracle. I want to import tables from these 2 different data sources and make relationship between these 2 different data source tables and I want to create new query subjects by using the tables from these 2 different data source table. Is it possible.

If its possible what to do create new query subjects from the 2 different data source table.


Your help will be appriciated.
Sarayu

[nonooo]

1/ make both connections in cognos
2/ make a new framework manager project
3/ import table from both connections
4/ modelize the link (=relation)
5/ add a new query subject
6/ add a package & publish
7/ do whatever you want with your data.

it will work but I am not sure cognos will do a great job doing the link (index are in your database server not in cognos server...)

[Sarayucog]

Hi nonoo,

Thanks for your quick response.

Do we need any common table like a confirmed dimenstion to join the 2 different schemas (means 2 different data sources)

Do we need any common tables or common columns to join the 2 different data source tables.

[MFGF]

To join the data sources, you will need at least one common item in each. You can then select these items and create a relationship between them.

Regards,

MF.