Overview
Progress DataDirect’s ODBC Driver for IBM Db2 offers a high-performing, secure and reliable connectivity solution for ODBC applications to access IBM DB2 data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.
- Get simple fast connectivity without any IBM client software dependencies
- Single driver supports all flavors of IBM Db2 across AS/400 iSeries, z/OS and LUW
- Improve application performance and scalability through the driver's wire protocol architecture
Features
Fast
Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures
Secure
Supports the latest TLS protocols for data encryption, secure authentication methods for connections and HTTP Proxy for client security while connecting to cloud deployments
Robust
Ensure high availability via application failover and workload balancing without changing application code
Easy to Use
True standards compliance with ODBC and JDBC
Versatile
Supported on every major platform and certified to work with leading applications such as Power BI, Tableau, Informatica, Cognos, SAS, Business Objects and more
Advanced Connection Pooling
Connection pooling allows you to reuse connections rather than creating a new one every time the driver needs to establish a connection to the underlying database. The DataDirect Connect Series for ODBC drivers enable connection pooling without requiring changes to your client application.
Technical Specifications
Progress DataDirect for ODBC for Db2 Wire Protocol Driver
Version 8.0.2
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)
ODBC Version Support
- Compatible with ODBC 3.8 applications
Database Support
- DB2 v11.5 for Linux, UNIX, Windows and higher
- DB2 v11.1 for Linux, UNIX, Windows and higher
- DB2 v12 for z/OS and higher
- DB2 i 7.3 and higher
Operating System Support
AIX (32- and 64-bit)
- AIX, version 5.3, 6.1, 7.1 and higher
HP
- HP-UX IPF (32- and 64-bit), 11i version 2.0 (B.11.23) and higher
-
HP-UX PA-RISC (32-bit only), version 11 and higher
Linux x86 (32- and 64-bit for AMD and Intel processors. 64-bit for Itanium II.)
- CentOS Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- Debian Linux x86, version 7.0, 8.0 and higher
- Oracle Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher
- Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher
Linux on System Z (64-bit only)
- CentOS Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- Oracle Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- Red Hat Enterprise Linux x64, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
- SUSE Linux Enterprise Server Linux x64, version 10, 11, 12, 15 and higher
Solaris (32- and 64-bit)
- Solaris x86 version 10 (Solaris 5.10), 11 and higher
- Solaris on SPARC, version 8 (Solaris 5.8), 9, 10, 11 and higher
Windows (32- and 64-bit)
- Windows (x86), version 7, 8.1, 10 and higher
- Windows Server (x86), version 2008, 2012, 2016, 2019 and higher
Driver/Client Software Requirements
Documentation
Progress DataDirect for ODBC for Db2 Wire Protocol Driver
Version 8.0.2