Re: Connecting to SQL Server from Oracle
Date: Sun, 11 Dec 2022 15:10:34 -0500
Message-ID: <da36cc46-b879-0eb9-9778-bf1af1b6b872_at_gmail.com>
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/
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 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 11 2022 - 21:10:34 CET