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@xxxxxxxxx>
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@xxxxxxxxxx>
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@xxxxxxxxxx <sallie.cottingham@xxxxxxxxxx>* | Direct
Line 615.401.7962
[image: A picture containing food Description automatically generated]
