datadirect-connectors-head-banner

Custom ODBC Driver for any Data Source or API

Download OpenAccess SDK for ODBC
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

    custom_odbc_for_rest_3

    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.

    Build a custom ODBC driver using .NET

    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.

    OpenAccess ODBC 8 hours 4

    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.

    3 OpenAccess ODBC Pass Through

    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.

    OpenAccess_SDK

    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

    coins

    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-sm

    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

    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

    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

    DataDirect Connectors

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

    Contact Us

    Copyright © 2020 Progress Software Corporation and/or its subsidiaries or affiliates.
    All Rights Reserved.

    Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

    Terms of Use Privacy Center Security Center Trademarks License Agreements Careers Offices
    Do Not Sell My Personal Info
    Powered by Progress Sitefinity