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

    Latest OpenAccess SDK Stories

    Progress Featured in CRN 2015 Cloud Partner Program Guide 880x440
    BLOG
    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.

    QUICK GUIDE
    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#

    tableau-logo-USE-THIS-ONE
    CERTIFICATION
    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

    image3-build-custom-odbc
    TUTORIAL
    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.

    OpenAccess SDK
    DEMO
    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.

    opening_the_salesforce_data_silo
    CERTIFICATION
    Certified Connectors for BI Tools

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

    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.

    open_access_for_openedge
    USE CASE
    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

    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 © 2019 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 Trademarks License Agreements Careers Offices
    Powered by Progress Sitefinity