Re: Joining Oracle and SQL Server

You can create a db link from Oracle to sql server with Oracle heterogeneous services which doesn't need an extra license. Works over odbc. In our case the oracle db was on solaris so we used unix odbc and an open source sql server odbc driver to create the odbc link and then ther is a bit of sqlnet config on the oracle side. You end up with db link to your oracle listener to odbc to sql server.

Works fine.

If your oracle db is on windows then it even easier.

Regards,
Fergal
On 14 Mar 2014 20:31, "Rich Jesse" <rjoralist3_at_society.servebeer.com> wrote:

> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l