After a short description of data source categorization, you'll find links to specific data sources to have more about how that specific data source can be connected to SSIS. And finally, at the bottom of this article, you'll see the full list of available data sources for SSIS.
Data Sources are the source and destinations where SSIS can read/write data. In this section we will have a view of connectors (i.e. Microsoft OleDB provider for Oracle), capabilities (fast load), and tips & tricks per data source.
One way to categorize data sources is to separate them into logical chunks of how the target data is stored & processed. We can slice the data sources into Application Systems, Database Systems, Queue Systems and Protocols, and Unstructured & semi-structured data formats. Below, you'll see popular data source brands in each category and a link to more information about how SSIS can connect to these data sources.
*not supported out-of-the-box, however, components can do this.
** sFTP is not supported out-of-the-box
Data Source
Released By
Data Access API
Supported Database Versions
Vendor Support with SSIS?§§
64-bit support?
SQL Server
Microsoft
OLE DB
2000 and later
Y
x64, IA64
ADO.NET
ODBC
Attunity
CozyRoc
N
DB2
All DRDA compliant
IBM
z/OS and UDB 7.0 and later, AIX 5.0 and later, AS400 4.5 and later,
DB2 UDB 9.0
z/OS and UDB 7.0 and later, AIX 5.0 and later, AS400 4.5 and later
6.1, 7.x, 8.0 on z/OS 7.x, 8.0 on UNIX 7.x, 8.0 on Windows
DB2/400
On AS/400 5.1 and later
DataDirect
7.1 through 9.1 on Linux, UNIX, and Windows 7.x through 8.1 on z/OS V5R1 through V5R4 for iSeries (AS/400)
x64
HIT
z/OS and UDB 8.0 and later, AIX 5.x, AS400 4.5 and later
ETI
Bulk Load
iSeries (AS/400), UDB 8.0 and later
DB2 [1]
Persistent
Data Flow Component - Bulk Write & Bulk Read
-
All Except UniData® and UniVerse®
Oracle
7.3.4 and later [2]
8.0 and later
Oracle Corp
8i and later
9i and later
8i through 10gR2
9.0 and later
Data Flow Component - Bulk Write
8i & above
DataDefractor
9iR2 to 11gR1
SAP [2]
R/3 4.6C and later
SAP
Theobald Software
OLE DB - SAP Table Access, Queries, BW Cubes, BAPIs, ABAP Reports
R/3 4.0 B or higher
Hyperion Essbase
Star Analytics
Data Flow Component
Essbase 6.1 and greater & System 9
Hyperion Planning
Hyperion Financial Management
HFM 3.4 and greater & System 9
Salesforce
Web Services - Read & Write
Access
2003 and earlier
Excel
Low-level binary BIFF read; Open XML direct read;
2007 and earlier
Office 2007
2007
Open XML direct read
Sybase
11.5 and later
12.5 and later
12.0 and later
11.x through 15.x
Sybase IQ
OLEDB
?
contact Sybase
Informix
7.3 and later
7.31, 9.x, 10
Informix [4]
Teradata
2.6 and later
2.5 and later
Bulk Extract
MySQL
4.1 and later
PostgreSQL
FoxPro
File DBs
Any Jet 4.0 compatible
Adabas
6.2.2 to 7.4.x on z/OS 3.3 to 5.1 on Open Systems (UNIX, Windows, OpenVMS)
CISAM
On UNIX
DISAM
On UNIX, Linux, and Windows
Ingres II
2 to 2.56
Oracle Rdb
7.1.x, on OpenVMS Alpha and Integrity (Itanium)
Y (HP Integrity)
RMS
On OpenVMS Alpha and Integrity (Itanium)
Enscribe
On HP NonStop G-Series and H-Series
SQL/MP
IMS/DB
6.1 and later
VSAM
On z/OS 1.1 and higher
LDAP
All LDAP compliant servers
Yes
Lotus Notes
Team4
Custom Component
Proposion
.NET Connector
[1] Product is in beta
[2] Although this provider can connect to and use versions of Oracle up to and including Oracle 10gR2, it does not support database constructs (such as BLOB/CLOB data types) introduced after Oracle 8.0)
[3] Product is in beta
[4] Product is in beta
§ What does "Vendor Support with SSIS" column mean?
YES in that column means that the vendor actually tested their solution with SSIS and can be contacted if there are any issues with their connector when used with SSIS.
SSIS Connection Managers http://social.technet.microsoft.com/wiki/contents/articles/ssis-connection-managers.aspx
SSIS - Microsoft SQL Server Connectors http://social.technet.microsoft.com/wiki/contents/articles/ssis-microsoft-sql-server-connectors.aspx
SSIS with Unstructured and Semi-Structured Excel, CSV Data http://social.technet.microsoft.com/wiki/contents/articles/ssis-with-unstructured-and-semi-structured-excel-csv-data.aspx
SSIS: Excel Connectors http://social.technet.microsoft.com/wiki/contents/articles/1954.aspx
StarSQL (from StarQuest Ventures - www.starquest.com/.../infostarsql.shtml ) can be used with SSIS for connection to all DB2 systems. Available as 32 & 64-bit (x64).
Revision 8 - Added Microsoft SAP BI Connector details.