Share via

SSIS with Oracle Connectors

  • Article

Connectivity to Oracle databases is possible in a few different ways. There are connectors released by Microsoft and Oracle which has different feature sets and supported database versions.

Below is the list of connectors and their capabilities by vendor.

Microsoft

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
OLE DB Provider for Oracle (MSDAORA) OLE DB 7.4 to 10gR2* No table/view/ parameter/ stored procedure **
Microsoft Connector Version 1.2 for Oracle by Attunity Supported Oracle databases: Oracle 9.2.0.4 and higher; Oracle 10.x; Oracle 11.x Yes The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 Integration Services.
Microsoft Connector Version 2.0 for Oracle by Attunity Supported Oracle databases: Oracle 9.2.0.4 and higher; Oracle 10.x; Oracle 11.x Yes The component is designed to be used with the Enterprise and Developer editions of SQL Server 2012 Integration Services.
.NET provider for Oracle .NET ALL Yes table/view/ parameter/ stored procedure

Oracle

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
OLE DB provider for Oracle OLE DB ALL Yes table/view/ parameter/ stored procedure ** Has a high performance loader. Bulk Insert is not supported though. This has been tested in SSIS labs and is recommended by Microsoft.
.NET provider for Oracle .NET ALL Yes Access to many Oracle features and types. But causes errors in some SSIS shapes. Not recommended for general SSIS connectivity, but useful in Scripts and custom code. See web site

ETI

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
Oracle Destination HPC Native Load Utilities ALL Yes 2-8x faster than Ole DB providers See web site

DataDirect

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
Connect64 for SSIS OLE DB 8i through 10gR2 Yes Supports deriving parameters for parameterized SQL statements No need to download, install, and configure Oracle SQL*Net client libraries, OLE DB providers, or bulk load utilities - connects directly to Oracle via Oracle's wire-level protocol Product Overview

Devart

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
Devart SSIS Data Flow Components ADO.NET Oracle servers 12c, 11g, 10g, 9i, 8i, 8.0 and 7.3, including Personal and Express editions. Yes Product Overview

Persistent

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
SSIS Oracle Bulk Load Connector SSIS Data Flow ALL Yes table/view/ parameter/ stored procedure Supports Bulk Inserts over 100 times faster than current OLEDB provider. Contact Persistent for more information about the connector (Contact Us) See web site

Interactive Edge

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
DataDefractor ODBC ALL Yes table/view/ parameter/ stored procedure High performance extraction and dimensionalization of fact data and contextual metadata See web site

CozyRoc

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
Oracle Destination ADO.NET 9iR2 to 11gR1 Yes 10-30x faster than OLE DB. See web site

Various companies

Name Data Access API Supported Oracle Versions 64 bit Metadata support Provider Notes FAQ
ODBC providers ODBC ? No Though uncommon, ODBC providers do exist for Oracle as well.

 

* New data types introduced after Oracle 8 is not supported, such as CLOB, BLOB, BFILE, and UROWID

** Provider does not support calling stored procedures with parameters.