Q
Problem solve Get help with specific problems with your technologies, process and projects.

Linking between Oracle and SQL Server to access tables

Is it possible to have a link between an Oracle and SQL Server databases for accessing tables -- similar to a database link between two Oracle databases?
You can have a link between Oracle and virtually any other database. To do this, you will need to implement Oracle's Heterogenous Services (HS). This is sometimes called Transparent Gateways as well. Once implemented, you can create a database link to a non-Oracle database. There are specific HS implementations for some of the top RDMBS platforms, i.e. SQL Server and DB2. But there is also a generic implementation for ODBC which just requires you to have an ODBC driver to connect to that database. Once set up, the non-Oracle database appears on the database link just as if it were an Oracle database. Please read the Oracle documenation on setting up and configuring HS. You can find a copy here:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/toc.htm
This was last published in January 2004

Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close