Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connecting Oracle to sql Server.

Gor_MahiaDec 3 2021

All,
Ive some tables (or just 1) in Oracle 12C schema which i need to expose to sql server i.e. i want sql server to read (select query) some tables from Oracle.
Oracle is running on Unix Solaris server while sql server is running on another windows server.
What are my options to achieve this with little dba help? - may be odbc connection, mount windows location/dir and place file on server etc.
thanks in advance.

Comments
Post Details
Added on Dec 3 2021
4 comments
426 views