ODM - Can we have tables from multiple databases in a project?

999766

Hi All,

Can we use tables from multiple databases into a single project (Eg Stage and Mart)

I can see that tables from many schemas can be included but I did not see any options to add data sources from multiple databases.

Thanks,
Nikhil

Mark Kelly-Oracle

Hi Nikhil,
Sure you can.
For Oracle to Oracle connectivity use database links:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm

For Oracle to Other connectivity use gateways:
http://www.oracle.com/technetwork/database/gateways/index.html

At the ODMr level this would be transparent.

Thanks, Mark

999766

Thanks for the reply Mark!

So the GUI by itself does not have this capability and I would use synonyms for the access. Maybe even try and use Driving Site or other hints to control where the processing gets done.

Mark Kelly-Oracle

Yes. That will work.
Mark