Custom ODBC Driver for any Data Source or API

OpenAccess SDK

Table of Contents:


    Progress DataDirect’s ODBC Driver for any Data Source or API offers a high-performing, secure and reliable connectivity solution for ODBC applications to access any Data Source or API 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.

    • Quickly develop custom ODBC driver across C, C++, Java, .NET, REST, ABL
    • Broad data connection and application platform options
    • Increase development productivity by using our robust SDK



    Use the same code to support of any API - ODBC, JDBC, OLE DB, ADO.NET


    Leverage granular tooling to help you measure, analyze and improve your application performance


    Get one interface to manage data access from all standards-based APIs


    Broaden data connection and application platform options while expanding developer knowledge


    Overpower any enterprise project you can dream up with vast SQL functionality

    Extensive SQL Support

    Code less and work more effectively with optimized CRUD operations via the OpenAccess SQL engine

    Technical Specifications

    Windows Client 32-bit platforms

    • Microsoft Data Access Components (MDAC), version 2.7 Service Pack 1 or higher

    Windows Client 64-bit platforms

    • Microsoft Data Access Components (MDAC), version 2.8 (64-bit) or higher


    • No product-specific requirements

    Requirements for Installing OpenAccess Local Client for ODBC and IP SDK on Windows Platforms

    • Minimum of 100 MB of free disk space
    • Microsoft Data Access Components (MDAC), version 2.7 Service Pack 1 or higher
    • MMC 2.0 or higher

    UNIX Platforms

    • Korn shell. This requirement applies to Linux, which by default is not shipped with a Korn shell


    Related Resources


    Build your own Custom ODBC driver for REST API - Quick Start

    Follow along with a quick and easy guide to building your own ODBC driver.

    Read Tutorial 


    Build a custom ODBC driver using .NET

    Learn how to build your own ODBC driver using .NET to connect or integrate with your favorite tools.

    Read Tutorial 


    Build your own custom ODBC Driver for a custom REST API - Advanced

    Detailed, step-by-step instructions for creating an ODBC driver in row-based or SQL pass-through mode.

    Read Tutorial 


    OpenAccess ODBC Pass Through Mode

    Learn how to build an ODBC driver that operates in SQL pass-through without relying on a template generator.

    Read Tutorial 


    Build Custom Driver for Any Data Source or API with OpenAccess SDK

    Progress DataDirect OpenAccess SDK is the industry’s leading custom driver development kit that enables custom drivers for any data source to be developed within weeks.

    Download Paper

    Customer Success Stories

    Success Story

    NetSuite Improves Application Connectivity and Integration with DataDirect

    NetSuite needed application data connectivity demanded by existing customers and by the market at large. To solve this problem they leveraged the OpenAccess™ SDK for data connectivity supporting an extensive breadth of standards and implementations.

    Learn More

    Success Story

    The Resource Network

    The Resource Network, which helps organizations develop business initiatives, needed to tie together diverse data from multiple on-premise or cloud-based applications. Leveraging DataDirect OpenAccess for Salesforce, any ODBC-compliant application was enabled to access data sources at in real time using SQL as the language.

    Learn More

    Success Story

    UZ Leuven

    UZ Leuven, one of Belgium’s largest hospitals, needed a efficient complex data migration from multiple sources to be shared across 200 applications and multiple facilities. Using Progress® DataDirect® OpenAccess their IT team was able to create a database emulation layer that made it possible to pre-configure and test database integration with DB2 on all 200 applications.

    Learn More

    Connect any application to any data source anywhere

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