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

Hey Jeff this still requires a DB link though. Unless I am missing something.

On Mon, Dec 12, 2022 at 5:45 AM 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