Re: Joining Oracle and SQL Server

> 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