Multiple Database connections in a query

Analytics
N/A

Multiple Database connections in a query

Hello,

I am pulling data from an oracle 11g database. And would like to connect to our teradata data warehouse to enrich this data. I am using Toad for Analytics and have connections setup and can run queries seperatly from the two databases. However I want to Inner join the two in one query. Can this be done? If so can you direct me to some examples so I can learn how to accomplish this.

Thanks,
Jeff
2 REPLIES
N/A

Re: Multiple Database connections in a query

Hi Jeff,

I don't have an magic solution, but i recommand you to check INFORMATICA Data Integrator , or use Editors wich allows multipple connection in the same sessions, but i insest that Informatica is able to achiev such as task

BR.

Otto

N/A

Re: Multiple Database connections in a query

Hi Jeff,

i confirm, Informatica data Integrator do such as task