Re: Connecting to SQL Server from Oracle

Are you required to pull the data from Oracle? Or can you install an ODAC client (https://www.oracle.com/database/technologies/odac-downloads.html) and create a linked server from SQL Server to Oracle to push the data instead?

That's the tip of a bit of an iceberg (e.g. installing and configuring ODAC/provider, possible character and/or data type translation, etc), but one I've used with great success. And the price is right, too, as far as I know.

Just a thought....

Rich

On Sat, Dec 10, 2022 at 7:27 PM Hameed, Amir <amir.hameed_at_sleepnumber.com> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l