Hi Expertises,
I am having question would like to know the answer:
Can we connect 02 DB Oracle and MSSQL then get data from both of them?
Thanks,
Printable View
Hi Expertises,
I am having question would like to know the answer:
Can we connect 02 DB Oracle and MSSQL then get data from both of them?
Thanks,
You can create linked server on MS sql to point to Oracle.
You could use the following in sql server to connect to oracle and get data.
Linked server and openquery
or
openrowset
or
opendatasource
or
DTS
You can do other way around too. You can use Heterogenous services setup to connect to SQL Server from Oracle. It involves modifying odbc file under hs folder in oracle home, then creating a dblink.