SSIS Connectors for IBM DB2
Connectors for IBM DB2. The Connection strings for IBM DB2 site lists connection strings for the DB2 .NET Data Provider from IBM, Microsoft OLEDB provider for DB2, IBM OLE DB provider for DB2, and the IBM DB2 Driver for ODBC and CLI.
| By | Name | Data Access API | Supported IBM DB2 Versions | 64 bit | Metadata support |
Provider Notes | FAQ | |
| DataDirect | Connect64 for SSIS | Ole DB | 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) | yes |
Supports deriving parameters for parameterized SQL statements | No need to download, install, and configure DB2 Connect client libraries, OLE DB providers, or bulk load utilities - connects directly to DB2 via the DB2 DRDA wire-level protocol | Product Overview | |
| Devart | Devart SSIS Data Flow Components | Data Flow Component | DB2 for LUW: 8.0 and higher. | yes | Product Overview | |||
| ETI | DB2 Destination HPC | Fast Load | Z/OS, UDB 7.0 and later | yes |
Product Overview | |||
| ETI | DB2 Destination HPC | Native: embedded SQL, Autoloader, Load | Windows 7.0 and later,AIX 5.x, 7.0 and later, AS400 4.5 and later, z/OS, UDB 7.0 and later | yes |
Product Overview | |||
| CozyRoc | DB2 Destination | ADO.NET | UniData® and UniVerse® data servers are not supported. | yes |
More Information | |||
| StarQuest | StarSQL ODBC/JDBC Database Drivers | yes | Product Overview | |||||
**Note: **This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest or with other appropriate information.