Re: [External] : Re: Connecting to SQL Server from Oracle
Date: Tue, 20 Dec 2022 08:40:45 +0100
Message-Id: <C9B80966-F206-4A0B-BB30-9341998252CA_at_arisant.com>
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/
You will need another listener and that's about it. That should hold water for once a month operations.
--Mladen GogalaDatabase ConsultantTel: (347) 321-1217https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 20 2022 - 08:40:45 CET