What do we need to use Oracle as data source with SSIS?

RNA 1 Reputation point
2021-09-26T20:08:05.633+00:00

Hi,

I am using the following setup to develop SSIS packages:
SQL server 2017
SSDT for Visual Studio 2017 version 15.9.9
Oracle 12c 64-bit

In order to import data from Oracle database, what do I need to install (Oracle client , ODAC , Attunity, etc.)

Please specify all needed components and whether I need the 32-bit or 64-bit version of each.

Thanks and regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,523 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points
    2021-09-27T02:04:38.287+00:00

    Hi @RNA-9746,

    Microsoft Connector for Oracle enables the ability to export data from and load data into Oracle data source in an SSIS package.

    oracle-connector

    oracle-connection-manager

    For 64bit and 32bit issue, you may refer this which mentioned the prerequisites about the environments.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October