SQLTeam.com | Weblogs | Forums

Read data from MS SQL Server 2017 to Oracle DB

Hi All,

Our application is based on MS SQL Server 2017. We have to give some data to a third part system which is using Oracle DB. So basically in our DB we are creating a view , which the Oracle DB has to read from us.

So is there any configurations that needs to be done in MS SQL to make this possible in their Oracle DB? Do I have to install the Oracle DB client ?

I know it has to be installed and make the linked server if we are reading the view or any data from Oracle DB. But for giving data to Oracle, is their any specific configurations to be done in SQL server?

Any help will be highly appreciated.

Thanks in advance!

This has the detail

http://www.dba-oracle.com/t_database_link_sql_server_oracle.htm