question

RNA-9746 avatar image
0 Votes"
RNA-9746 asked YitzhakKhabinsky-0887 commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered YitzhakKhabinsky-0887 commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

It is just for SQL Server 2019 and later.

1 Vote 1 ·