By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.