Re: Accessing SQL Server DB from Oracle

I used the free ODBC hs gateway up to few years ago (version 12.1). I worked fine, but it has some limitations (see https://docs.oracle.com/en/database/oracle/oracle-database/21/odbcu/database-gateway-odbc-features.html#GUID-0365FD91-AC7E-44F2-8FB7-FC100D006391 ).

The paid, MSSQL-spedfic gateway works better, Golden Gate is far more comprehesiv

Regards,
Andrea

Il Gio 10 Ago 2023, 15:00 Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov> ha scritto:

> I am looking for any advice/suggestions of the best way to access a SQL
> Server DB from Oracle. I’ve communicated with Oracle via a Support Ticket
> and the solutions they gave me involve using the Oracle Gateway (one free
> and the other paid). The Oracle DB is being hosted by a vendor and that DB
> will be talking to one of our SQL DBs on-prem. We already have
> communication via Oracle DBlinks both from Oracle down to Oracle on-prem
> and vice versa.
>
>
>
> Just checking with this group to see what experiences you might have on
> how to do this and the pros/cons of various types of solutions.
>
>
>
> Thanks!
>
>
>
> *Sallie A. Cottingham*, OCP
>
> *Database Administrator*
>
> Comptroller of the Treasury
>
> Technology Solutions
>
> 425 Rep. John Lewis Way N. | Nashville, TN 37243
>
> *sallie.cottingham_at_cot.tn.gov <sallie.cottingham_at_cot.tn.gov>* | Direct
> Line 615.401.7962
>
>
>
> [image: A picture containing food Description automatically generated]
>
>
>

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




image/png attachment: image001.png



image/png attachment: image001.png