Re: DBLink from Oracle to SQL Server

There is Oracle heterogeneous gateway which can use any ODBC driver. If you are on Linux, the ODBC driver is FreeTDS. Oracle ODBC gateway is free, but does not support distributed transactions. You can query or update, but only a single database at a time. Here is documentation:

https://docs.oracle.com/database/121/ODBCU/intro.htm#ODBCU100

Here is some help from always helpful Tim Hall:

https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity

Easysoft, the ODBC driver vendor, also has some instructions:

http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html

Finally, MS SQL Server driver for Linux is here:

http://www.freetds.org

May the force be with you!

Last time I was playing with it, it took me a week to get it right. Use the Google, my young padawan, use the Google.

On 09/28/2017 04:53 PM, Upendra nerilla wrote:
>
> Hello everyone -
>
> Is there a way to create a dblink from Oracle to SQL Server through
> any free product? I am familiar with Oracle Database Gateway product,
> which I am trying to avoid.
>
> If anyone have pointers, much appreciated.
>
>
> Thanks in advance
>
> -Upendra

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l