Re: Accessing SQL Server DB from Oracle

I use the free gateway to hit SQL Server from Oracle via database link. It works fine but we've had some issues with complex queries or when hitting larger tables that performance has been really bad. So you'll need to test that. In one situation we had to call a procedure to load a table first and then query that temp table for our data, it was way faster. SSIS could also be a good option.

On Thu, Aug 10, 2023 at 4:15 PM Niklas Iveslatt <dmarc-noreply_at_freelists.org> wrote:

> 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