Q

Linking SQL Server to Oracle server

How can I link SQL Server from its manager environment to an Oracle server? My idea is to get information stored in the Oracle server through SQL Server.

How can I link SQL Server from its manager environment to an Oracle server? My idea is to get information stored in the Oracle server through SQL Server.
I do not know of any methodology which lets you link SQL Server to Oracle. Oracle does let you link to a non-Oracle database by leveraging Heterogeneous Services (HS). HS lets you query SQL Server as if it were another Oracle database. I do not know of such a product in SQL Server that lets you query Oracle directly. Instead, you will probably want to replicate the Oracle data into the SQL Server database. You can use SQL Server's Data Transformation Services (DTS) to pull the data from Oracle through an ODBC driver and store the data in SQL Server.
This was first published in May 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close