Using Oracle's heterogenous services also known as HS, we can make a connection to non-Oracle databases and access the data remotely. I used MS SQL server as the target non-Oracle database on Windows and used HS to access from Oracle database residing on Linux. Here, we'll see step by step instructions on how to set up a connection from Oracle database to Microsoft SQL server.
Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.
This posting has nothing to do with my present or past employer.