Content area
Full text
A department in my organization is using Microsoft SQL Server and they need it to link directly to data on the Oracle database. I'm not an expert on SQL Server, so how can I show them how to connect?
Applications:
Oracle RDBMS 8+, Microsoft SQL Server 7+
In a perfect world, everything would be in Oracle databases, and then you wouldn't have this problem. But sometimes you may need to work together with other databases as well as Oracle. In this case, you're asking about linking to Oracle from SQL Server, so we'll have to discuss a little bit about how linked servers work for that application.
Set up the server alias
...