Transfer data from an Oracle database into an Sql database.

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
EricChambers_1
Posts: 1
Joined: Thu 08 Aug 2019 04:52
Location: https://www.innovecs.com/
Contact:

Transfer data from an Oracle database into an Sql database.

Post by EricChambers_1 » Thu 08 Aug 2019 05:19

I have a requirement to retrieve data from an Oracle database into an Sql database using SSIS.

I am using sql Server 2012 Standard Edition 64 bit and oracle is 11g.

I tried to download the oracle drivers (64-bit Oracle Data Access Components (ODAC)) to install on the Sql server so that I could connect to Oracle db but could not achieve the same.

Please help me solve the problem.

MaximG
Devart Team
Posts: 1375
Joined: Mon 06 Jul 2015 11:34

Re: Transfer data from an Oracle database into an Sql database.

Post by MaximG » Thu 15 Aug 2019 06:06

You can use Devart ODBC Driver for Oracle to solve the described ask. To become familiar with our product, you can use the full-featured trial version, available at: https://www.devart.com/odbc/oracle/download.html Here : https://www.devart.com/odbc/oracle/compatibility.html you can get a list of compatibility of our driver. Its use in the SSIS project does not differ from any other ODBC driver

Post Reply