Interface-Hero-Background

IBM Db2 ODBC Driver

db2 logo

Select your platform

Download ODBC connectors

Table of Contents:

    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
    • IBM Db2 Hosted
    • IBM Db2 Warehouse on Cloud (formerly IBM dashDB)

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 7.1 and higher

    HP

    • HP-UX IPF (32- and 64-bit), 11i version 3.0 (B.11.3x) and higher
    • HP-UX PA-RISC (32-bit only), version 11 and higher

    Note: For HP-UX PA-RISC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.

    Linux x86 (32- and 64-bit for AMD and Intel processors. 64-bit for Itanium II.)

    • Debian Linux x86, version 10.0 and higher
    • Oracle Linux x86, version 6.0, 7.0, 8.0, 9.0 and higher
    • Red Hat Enterprise Linux x86, version 6.0, 7.0, 8.0, 9.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 12, 15 and higher
    • Ubuntu Linux x86, version 14.04, 16.04, 18.04, 20.04 and higher

    Linux on System Z (64-bit only)

    • Oracle Linux x64, version 6.0, 7.0, 8.0, 9.0 and higher
    • Red Hat Enterprise Linux x64, version 6.0, 7.0, 8.0, 9.0 and higher
    • SUSE Linux Enterprise Server Linux x64, version 12, 15 and higher

    Solaris (32- and 64-bit)

    • Solaris x86 version 10 (Solaris 5.10), 11 and higher
    • Solaris on SPARC, version 10, 11 and higher

    Note: For Solaris and Solaris on SPARC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.

    Windows (32- and 64-bit)

    • Windows (x86), version 10, 11 and higher
    • Windows Server (x86), version 2012, 2016, 2019, 2022 and higher

    Driver/Client Software Requirements

    • No Requirements

    Documentation

    Progress DataDirect for ODBC for Db2 Wire Protocol Driver
    Version 8.0.2

    Best Practices for Connecting to Your Cloud Data Warehouse Webinar
     
    Making the Leap: Best Practices for Connecting to Your Cloud Data Warehouse

    See Also

    Tutorials Product Compatibility Guide Blogs Release Notes
    Get Customer Support

    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

    A product specialist will be glad to get in touch with you

    Contact Us