Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for Oracle offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Oracle data. Our ODBC driver can be easily used with SQL 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.

    • Handle high volume and velocity easily with high performing Oracle ODBC Driver
    • Gain value and time from failover features that ensure data integrity and reliability
    • Remove dependancy on vendor client libraries and vendor clients by using our ODBC driver for Oracle

    Features

    Fast

    Superfast data loading and extraction that reduces the time and cost of running enterprise infrastructures 

    Support for Oracle Security Features

    Our driver supports Oracle Advanced Security Data Integrity Checks, Oracle Wallet SSL Authentication and Oracle Internet Directory (OID) authentication without additional driver configuration.

    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 

    Technical Specifications

    All 32-bit versions of this driver are part of the Connect for ODBC Series. All 64-bit versions are part of the Connect64 for ODBC Series.

    Progress DataDirect for ODBC for Oracle 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

    • Oracle Database:
      • Oracle 19c R1 (19.1) and higher
      • Oracle 18c R1 (18.1) and higher
      • Oracle 12c R1 (12.1) and higher
      • Oracle 11g R1 (11.1) and higher
      • Oracle 10g R1 (10.1) and higher
      • Oracle 9i R2 (9.2) and higher
      • Oracle8i R3 (8.1.7) and higher
    • Oracle Autonomous Data Warehouse Cloud 12c R2 (12.2) and higher
    • Oracle Autonomous Transaction Processing Cloud 19c R1 (19.1)
    • Oracle Database Cloud Exadata Service
    • Oracle Database Cloud Service 18c R1 (18.1)

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 5.3 and higher

    HP

    • HP-UX IPF, 11i version 2.0 (B.11.23) and higher
    • HP-UX PA-RISC (32-bit only),11i version 2.0 (B.11.23) 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 (AMD and Intel only)
    • 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 (AMD and Intel only)
    • Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher (AMD and Intel only)

    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

    Customer Success Stories

    SS_Toyota Motor Sales

    Success Story

    toyota-min Enabling Business Intelligence for Thousands of Analysts 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