|
Data-Connectivity Providers and SSIS
Note: The following is not a definitive list of all data providers, and not all data providers on this list have been tested by Microsoft with SSIS. Only current Beta or shipping products are listed. Information about third-party products was provided by the product vendors and could not be independently verified.
Source : Microsoft.com [http://technet.microsoft.com/en-us/library/bb332055.aspx]
Last Updated : 4/1/2008 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
versions | Y | x64,
IA64 | | SQL Server | Microsoft | ADO.NET | 2000 and later
versions | Y | x64,
IA64 | | SQL Server | Microsoft | ODBC | 2000 and later
versions | Y | x64,
IA64 | | SQL Server | Attunity | OLE DB | 2000 and later
versions | Y | | | SQL Server | DataDirect | OLE DB | 2000 and later
versions | Y | | | DB2 | Microsoft | OLE DB | All DRDA-compliant versions | Y | x64,
IA64 | | DB2 | IBM | OLE DB | z/OS and UDB 7.0
and later, AIX 5.0
and later, AS400 4.5
and later versions | Y | | | DB2 | IBM | ADO.NET | DB2 UDB 9.0 | N | | | DB2 | IBM | ODBC | z/OS and UDB 7.0
and later versions AIX 5.0 and later
versions, AS400 4.5
and later versions | N | N | | DB2 | Attunity | OLE DB | 6.1, 7.x, 8.0 on
z/OS 7.x, 8.0 on UNIX 7.x, 8.0 on Windows | Y | | | DB2/400 | Attunity | OLE DB | On AS/400 5.1 and
later versions | Y | | | DB2 | DataDirect | OLE DB | z/OS and UDB 7.0
and later versions AIX 5.x AS400 4.5 and later
versions | N | | | DB2 | HIT | OLE DB | z/OS and UDB 8.0
and later versions AIX 5.x, AS400 4.5
and later versions | N | | | DB2 | DataDirect | ADO.NET | z/OS and UDB 7.0
and later AIX 5.x, AS400 4.5
and later versions | Y | | | DB2 | ETI | Bulk Load | 8.0 and later
versions | Y | | | DB2¹ | Persistent | Data Flow Component Bulk Write & Bulk Read | - | N | | | Oracle | Microsoft | OLE DB | 7.3.4 and later
versions² | Y | N | | Oracle | Microsoft | ADO.NET | 8.0 and later
versions | Y | x64,
IA64 | | Oracle | Oracle Corp | OLE DB | 8i and later versions | Y | x64,
IA64 | | Oracle | Oracle Corp | ADO.NET | 8i and later versions | Y | x64,
IA64 | | Oracle | Oracle Corp | ODBC | 8i and later versions | N | | | Oracle | Microsoft | ODBC | 8i and later versions | N | | | Oracle | Attunity | OLE DB | 9i and later versions | Y | | | Oracle | DataDirect | OLE DB | 8i and later versions | Y | | | Oracle | DataDirect | ADO.NET | 8i and later versions | Y | | | Oracle | ETI | Bulk Load | 9.0 and later
versions | Y | | | Oracle | Persistent | Data Flow Component Bulk Write | 8i and later versions | N | | | SAP¹ | Microsoft | ADO.NET | R/3 4.6C and later
versions | Y | | | SAP | Theobald | OLE DB | R/3 | Y | | | Office Access | Microsoft | OLE DB | 2003 and earlier
versions | Y | | | Office Excel | Microsoft | OLE DB | 2003 and earlier
versions | Y | | | Office 2007 | Microsoft | OLE DB | 2007 | N | | | Sybase | Sybase | OLE DB | 11.5 and later
versions | N | | | Sybase | Sybase | ADO.NET | 11.5 and later
versions | N | | | Sybase | Attunity | OLE DB | 12.0 and later
versions | Y | | | Sybase | DataDirect | OLE DB | 11.5 and later
versions | Y | | | Sybase | DataDirect | ADO.NET | 11.5 and later
versions | Y | | | Informix | IBM | OLE DB | 7.3 and later
versions | N | | | Informix | Attunity | OLE DB | 7.31, 9.x, 10 | Y | | | Informix¹ | Persistent | Data Flow Component Bulk Write & Bulk Read | - | N | | | Teradata | Teradata | OLE DB | 2.6 and later
versions | N | | | Teradata | Teradata | ADO.NET | 2.6 and later
versions | N | | | Teradata | ETI | Bulk Load | 2.5 and later
versions | Y | | | Teradata | ETI | Bulk Extract | 2.5 and later
versions | Y | | | FoxPro | Microsoft | OLE DB | 8.0 and later
versions | N | | | File DBs | Microsoft | OLE DB | Any Jet 4.0– compatible version | N | | | Adabas | Attunity | OLE DB | 6.2.2 to 7.4.x on
z/OS 3.3 to 5.1 on Open
Systems (UNIX,
Windows, OpenVMS) | Y | | | CISAM | Attunity | OLE DB | On UNIX | Y | | | DISAM | Attunity | OLE DB | On UNIX, Linux, and
Windows | Y | | | Ingres II | Attunity | OLE DB | 2 to 2.56 | Y | | | Oracle Rdb | Attunity | OLE DB | 7.1.x, on OpenVMS
Alpha and Integrity
(Itanium) | Y | Y (HP
Integrity) | | RMS | Attunity | OLE DB | On OpenVMS Alpha
and Integrity
(Itanium) | Y | Y (HP
Integrity) | | Enscribe | Attunity | OLE DB | On HP NonStop G-
Series and H-Series | Y | Y (HP
Integrity) | | SQL/MP | Attunity | OLE DB | On HP NonStop G-
Series and H-Series | Y | Y (HP Integrity) | | IMS/DB | Attunity | OLE DB | 6.1 and later
versions | Y | | | VSAM | Attunity | OLE DB | On z/OS 1.1 and
later versions | Y | | | LDAP | Persistent | ODBC | All LDAP-compliant
servers | N | Y | |
About Nayan Patel
Nayan Patel, MCSD, MCDBA, MCSE is a Product Manager at Pragmatic Works and also Architect/Lead Developer of DTS xChange and SSIS xPress products. He is a consultant, trainer, mentor and developer who is enthusiastic about developing robust BI Tools. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Database Administration, and .Net Software Development. Nayan has created BI and software solutions for Pragmatic Works. He has also worked on several projects related to Windows Applications, Web Applications and BI Applications using Microsoft technologies.
How Big Is Your Package?