datadirect-connectors-head-banner

Powerful IBM Db2 ODBC Driver

Select your platform

IBM_DB2
Do you work for a software company?

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

    SQL Up Leveling/ Full ANSI SQL Support

    SQL up-leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases’ SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.

    Encryption SSL 3.0, TLS 1.0, 1.1, 1.2 Compliant

    We keep our SSL version up to date. Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy.

    Performance Tuning

    Progress DataDirect management of packet-based network communication provides unsurpassed packet transport, network round trips and data buffering optimization. (socket management). Includes performance methodology for throughput and resource utillization (CPU/memory)

    TSANet Multi-Vendor Support Channel

    We live for your next big customer. Make sure your customers are successful with 24/7 partner support and access to expertise from our engineering teams, partnerships and leading technology companies such as Microsoft, Oracle, and IBM through our TSANet multi vendor support channel.

    Day 1 Support for any new versions

    Day One Support for disruptive technologies with frequent release cycles. With this strategy - the first of its kind for any data connectivity provider - Progress DataDirect on-premises ODBC and JDBC drivers will support any new versions of supported data sources.

    Cross-platform Support

    Use one ODBC driver for all versions of SQL that works across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX .

    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

    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.)

    • 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

    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 7, 8.1, 10 and higher
    • Windows Server (x86), version 2008, 2012, 2016, 2019 and higher

    Driver/Client Software Requirements

    • No Requirements

    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.

    IN THE SPOTLIGHT

    Top 10 Reasons You Need High-Performance Data Connectivity

    Data Connectivity is a critical, but often overlooked component of the IT infrastructure. These components have dramatic effects on application performance, reliability and portability. Learn about the top 10 reasons high-performance data connectivity is critical for your business.

    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