Need to replicate OpenEdge data to SQL Server or Oracle?

Learn More

Table of Contents:

    Overview

    Progress DataDirect’s ODBC Driver for OpenEdge offers a high-performing, secure and reliable connectivity solution for ODBC applications to access OpenEdge data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris and Windows. 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.


    OpenEdge Licensing Options

    If you are an existing licensed Progress OpenEdge RDBMS customer and you are under active maintenance with Progress then you are likely already licensed for the ODBC and JDBC drivers.

    However, if you obtained the OpenEdge RDBMS from a 3rd party Progress Application Partner (that has built a commercial application on top of Progress OpenEdge) then you have two choices:

    1. You can work directly with your Progress Application Partner to request an OpenEdge ODBC or JDBC driver.

      Since your relationship is with that Application Partner (and not directly with Progress) all OpenEdge software distribution, license keys and technical support is handled by that Application Partner.

    2. You can choose to purchase an annual subscription for the DataDirect OpenEdge ODBC or JDBC and have the ability to work directly with Progress DataDirect Technical Support.

       

    Alternatively, instead of directly querying your live OpenEdge data from your favorite BI or ETL too, another solution to consider is to replicate your OpenEdge data into an Oracle or SQL Server data warehouse and run your SQL requests against that warehouse. If this approach is of interest then consider Progress OpenEdge Pro2 which is an easy approach to replicating OpenEdge data to Oracle and SQL Server.

    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 

    Technical Specifications

    Note: All 32-bit versions of this driver are part of the Connect for ODBC Series, and all 64-bit versions are part of the Connect64 for ODBC Series.

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

    • Progress OpenEdge 12.0 and higher
    • Progress OpenEdge 11.0 and higher

    Operating System Support

    AIX (32- and 64-bit)

    • AIX, version 7.3 and higher
    • AIX, version 7.1 and higher

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

    • Debian Linux x86, version 12.0 and higher
    • Oracle Linux x86, version 9.0 and higher
    • Red Hat Enterprise Linux x86, version 8.0, 9.0 and higher
    • SUSE Linux Enterprise Server Linux x86, version 12, 15 and higher
    • Ubuntu Linux x86, version 20.04, 22.04 and higher

    Solaris (64-bit)

    • Solaris on SPARC, version 10, 11 and higher

    Windows (32- and 64-bit)

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

    Driver/Client Software Requirements

    • No Requirements

    Documentation

    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