Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for Oracle Autonomous Data Warehouse Cloud (ADWC) offers a high-performing, secure and reliable connectivity solution for ODBC applications to access Oracle Autonomous Data Warehouse Cloud (ADWC) 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.

    • Handle high volume and velocity easily with high performing Oracle ADWC 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 Autonomous Data Warehouse Cloud

    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.

    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.

    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 .


    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

    Mac OS X (32- and 64-bit)

    • Mac OS X, v10.9.x 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 and higher

    Driver/Client Software Requirements

    • For Mac OS X: iODBC Driver Manager, version 3.52.7 or higher.

    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.


    Related Resources

    Webinar

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

    Companies are relying more and more on cloud-based data warehousing as a solution to some of the critical needs of today’s digital business world. See how Progress DataDirect Connectors for Cloud Data Warehouses can help you access and analyze the data from cloud data warehouses at the speed of business.

     

     

    Watch Webinar

    Paper

    Accelerate Your Cloud Data Warehouse Productivity

    Enterprises are increasingly migrating to cloud data warehouses but the value of these cloud data warehouses is ultimately limited by how quickly you can access the data within them. See how Progress DataDirect connectors for cloud data warehouses solve that challenge and provide you with secure data access at the speed of business.

    Download Paper

    Customer Success Stories

    Success Story

    Toyota Motor Sales

    When Toyota Motor Sales introduced Progress DataDirect for ODBC to their intricate data architecture, they saved $100,000 in 24 hours. Learn more in this case study from Progress Software.

    Learn More

    Connect any application to any data source anywhere

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