Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for IBM Db2 Warehouse on Cloud offers a high-performing, secure and reliable connectivity solution for ODBC applications to access IBM Db2 Warehouse on Cloud 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 all its versions
    • 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 

    Enterprise Features

    Extensive support of data types to enable the full use of Greenplum functionality 

    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 Connect and Connect64 for ODBC DB2 Wire Protocol Driver
    Version 7.1.6
    (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

    • IBM Db2 Warehouse on Cloud (formerly IBM dashDB)

    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

    • No Requirements

    Documentation

    Progress DataDirect Connect and Connect64 for ODBC DB2 Wire Protocol Driver
    Version 7.1.6

    Customer Success Stories

    SS_UZ Leuven

    Success Story

    uz-leuven-min How UZ Leuven Migrates 200 Applications Without Disrupting Medical Care Read story
    ;
    See all Success Stories

    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