Re: [External] : Re: Connecting to SQL Server from Oracle

I seem to recall it is also called the Heterogeneous Gateway.

On Tue, Dec 20, 2022 at 5:01 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> You don't need a separate server, just a separate listener. Of course, you
> can install listener in a container and run it separately, using podman or
> K8S.
>
>
> On Tue, Dec 20, 2022, 02:41 Niklas Iveslatt <niklas.iveslatt_at_arisant.com>
> wrote:
>
>> The database gateway for ODBC does not require a separate license - you
>> have to install it on a separate server than the oracle DB I recall (just
>> read the license guide) so you can put it on a the sql server db server for
>> example or it’s own - it may not be the most performant option but if you
>> pick the right driver and tune some parameters it might work for you!
>>
>> On Dec 20, 2022, at 5:48 AM, Arun Chugh <arun.chugh1610_at_gmail.com> wrote:
>>
>> 
>> Use copy command to pull the data from SQL server into flat / CSV file
>> and then later load into Oracle db, see if this fulfil your requirement.
>>
>> On Mon, Dec 12, 2022, 19:15 Jeff Smith <dmarc-noreply_at_freelists.org>
>> wrote:
>>
>>> Give SQL Server some REST APIs to hit instead (powered by ORDS, of
>>> course)
>>>
>>>
>>>
>>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>>> Behalf Of *Mladen Gogala
>>> *Sent:* Sunday, December 11, 2022 3:11 PM
>>> *To:* oracle-l_at_freelists.org
>>> *Subject:* [External] : Re: Connecting to SQL Server from Oracle
>>>
>>>
>>>
>>> On 12/10/22 20:26, Hameed, Amir wrote:
>>>
>>> Hi,
>>>
>>> Is there a way to establish a connection from Oracle to SQL Server
>>> without using the Oracle Gateway? We have a requirement to pull data from
>>> SQL Server and into Oracle only once a month and we don’t want to spend
>>> money on licensing Oracle Gateway. The OS platform is for Oracle Solaris.
>>>
>>>
>>>
>>> Thank you,
>>>
>>> Amir
>>>
>>>
>>>
>>> You can always use free HSODBC gateway. It's described here:
>>>
>>>
>>> https://docs.oracle.com/en/database/oracle/oracle-database/19/odbcu/index.html
>>>
>>> I've set it up several times, but not for SQL Server. It worked with
>>> MySQL and PostgreSQL. I don't see any issues with SQL Server. There is
>>> FreeTDS SQL Server ODBC driver for Slowaris:
>>>
>>> https://www.opencsw.org/package/freetds/
>>> <https://urldefense.com/v3/__https:/www.opencsw.org/package/freetds/__;!!ACWV5N9M2RV99hQ!PrLjX_o-xi5vOILeWHTceysSfiO9CnFep_1aHP6jALmC6H2VeI_5l4GrIlvK7DJZLwtog2e7V6cDaksBEO_RJn0LbQ$>
>>>
>>> You will need another listener and that's about it. That should hold
>>> water for once a month operations.
>>>
>>> --
>>>
>>> Mladen Gogala
>>>
>>> Database Consultant
>>>
>>> Tel: (347) 321-1217
>>>
>>> https://dbwhisperer.wordpress.com <https://urldefense.com/v3/__https:/dbwhisperer.wordpress.com__;!!ACWV5N9M2RV99hQ!PrLjX_o-xi5vOILeWHTceysSfiO9CnFep_1aHP6jALmC6H2VeI_5l4GrIlvK7DJZLwtog2e7V6cDaksBEO8BEccV0g$>
>>>
>>>

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