By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.