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

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