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


    Latest OpenAccess SDK Stories

    Three questions to ask when you build a Custom ODBC driver

    In this expert blog written by Sumit Sarkar, he describes what are the basic things you need to understand before you begin to build an ODBC driver or distribute an ODBC Driver.

    Build ODBC Driver in C/C++, Java or C#

    Are you struggling to find a driver for your amazing, unique application? Here's our quick guide for building a custom driver. This one stop guide gives you all the resources to build a custom driver in ODBC, JDBC, ADO.NET or OLEDB standard in C, C++, Java or C#

    Learn how to build an ODBC Driver and get certified by Tableau

    As a trusted Tableau technology partner, we want to set the record straight. Configuring third party ODBC drivers is fully documented by Tableau. In this blog, learn how to build an ODBC Driver and get it certified by Tableau

    Related Resources

    2 Hour Tutorial: Build your own custom ODBC driver for REST API

    A hot trend we’re seeing is out-of-box connectivity to REST APIs to Business Intelligence and Data Warehousing infrastructure. In this blog, our developer evangelist developed a step by step tutorial to build an ODBC Driver for a REST data source of your choice. It also has the steps to enable logging and troubleshooting.

    ODBC SDK for REST APIs to Connect in Real-Time

    Connect Live from Tableau with SQL ODBC access to your REST APIs and security policies. This video contains a brief introduction to OpenAccess SDK and eventually describes the step by step process of creating a custom ODBC driver from REST APIs.

    Certified Connectors for BI Tools

    Progress® DataDirect® offers powerful BI connectors that have been certified against industry standards for BI Tools.

    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.

    Create Custom Driver for OpenEdge

    For Progress® OpenEdge® applications, Progress® DataDirect® OpenAccess® is the best solution for securely integrating your application with virtually all reporting tools and BI analytics.

    Customer Success Stories

    Global leader in enterprise software for the construction industry needs to share Progress OpenEdge application data with third party BI tools. COINS leveraged OpenAccess to build a semantic layer on top of OpenEdge that enables efficient, flexible data connectivity that includes business logic.

    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.

    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.

    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.

    Connect any application to any data source anywhere

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