datadirect-connectors-head-banner

Custom ODBC Driver for any Data Source or API

OpenAccess SDK
Table of Contents:

    Overview

    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

    Features

    Portable

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

    Powerful

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

    Usable

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

    Comprehensive

    Broaden data connection and application platform options while expanding developer knowledge

    Technology-Rich

    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

    Linux/UNIX

    • 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

    Documentation


    Related Resources

    Tutorial
    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.

    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.

    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.

    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.

    PAPER
    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.


    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 Salesforce.com 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