Re: Joining Oracle and SQL Server

From: Rich Jesse <>
Date: Fri, 14 Mar 2014 15:31:11 -0500 (CDT)
Message-ID: <>

Sandy writes:

> Question: Is there a way to access the SQL Server databases through some
> kind of link from our Oracle monitoring database?

I do this already, to report on SQL Server locking issues in one COTS package. Ours is SQL Server 2000 going to XE 10.2, so the price was right. :)

There is an Oracle Gateway, but I didn't want to deal with possible licensing or support issues, so I used Linked Servers in SQL Server to push data to Oracle. The only requirement was an Oracle Client on the SQL Server box. In a nutshell:

  1. Install Oracle Client on the SQL Server
  2. Create a user in the Oracle DB
  3. Create a linked server in SQL Server using the OLE DB provider for Oracle and the Oracle user created above
  4. Tables in the Oracle DB are referenced in SQL Server as APEX..MYSCHEMA.MYTABLE, where "APEX" is the linked server name.

HTH! GL! Rich

Received on Fri Mar 14 2014 - 21:31:11 CET

Original text of this message