Re: Accessing SQL Server DB from Oracle

I second those comments - the free GW works ok for "most" use cases it seems but you have to test - it has been a minute since I set it up myself but I think it is best to put the oracle listener=the gateway on Windows and use the drivers available there versus putting the listener on Linux and finding drivers. At least that was my experience.

If you have SSIS up and running you could also use that to replicate - this may be more robust than a DB link if there is a high latency/sluggish link between the two databases.

Good luck!

Niklas Iveslatt
Senior Partner

Arisant LLC ~ http://www.arisant.com
44 Inverness Dr. E Bldg. C Suite 2 ~ Englewood, CO 80112 mobile: 303.882.4461 ~ main: 303.330.4065 ~ fax: 888.889.0155

  Need to send me something securely? *Click here* <https://arisant.sendsafely.com/u/niklas.iveslatt>

On Thu, Aug 10, 2023 at 5:01 PM Andrea Monti <ilsuonogiallo_at_gmail.com> wrote:

> 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