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@xxxxxxxxx> 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@xxxxxxxxxxxxx> wrote:Give SQL Server some REST APIs to hit instead (powered by ORDS, of course)
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf Of Mladen Gogala
Sent: Sunday, December 11, 2022 3:11 PM
To: oracle-l@xxxxxxxxxxxxx
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
