Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Is there a way for Oracle to read from SQL Server?
We are basically trying to read from a SQL Server table and update the information in Oracle. We used to have a database link in Oracle to another Oracle database.
Now the application is replaced by a new application that runs SQL Server, so we're trying to replicate the same process but now it's Oracle to SQL Server. Hope that makes sense.
The Oracle database server accepts SQL statements that query data stored in several different databases. The Oracle database server with the Heterogeneous Services component processes the SQL statement and passes the appropriate SQL directly to other Oracle databases and through gateways to non-Oracle databases. The Oracle database server then combines the results and returns them to the client.
Database Heterogeneous Connectivity Administrator's Guide
Oracle provides heterogeneous services to query non-Oracle databases like SQL Server. If you need some guidance here are some useful links.
We use a product called Easysoft. It's not free but allows you to run queries on Oracle as if the database/tables was local.
Alternatively you can use replication to copy data from SQL Server to Oracle (or vice versa, edition. Oracle -> SQL Server requires Enterprise I believe).
