DataDirect Connectors Build ODBC Driver for any Data Source or API

Create

Quickly develop custom ODBC driver across C, C++, Java, .NET, REST, ABL

Flexible

Broad data connection and application platform options

Bankable

Increase development productivity by using our robust SDK

Download OpenAccess SDK for ODBC

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

System Requirements

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

In Depth

PAPER

OpenAccess SDK Overview

USE CASE

Progress DataDirect OpenAccess for Progress OpenEdge

Learning & Support

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.

Read the Blog

Whitepaper

Deliver Secure SQL Access for Enterprise APIs

Download the whitepaper to learn:
1. How to how to quickly integrate your internal API layer into leading tools such as Microsoft Excel, SAP BusinessObjects, IBM Cognos, Oracle Business Intelligence and others
2. What to look for in a connector SDK for delivering SQL clients (ODBC, JDBC, ADO.NET and OLE-DB)
3. Steps to deliver custom SQL connectivity in under five days

Download the Whitepaper

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#

Read the Blog

Build Custom ODBC driver for REST Sources

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.

Read the Tutorial

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

Read the Blog

WEBINAR

Build ODBC Driver for Your SaaS Application, This Week

Check out this on-demand webinar and learn how to SQL-enable your SaaS application and streamline BI connectivity for your customers. Learn how easy it is to build a custom ODBC driver.

Resources

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.

Read the whole story

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.

Read the whole story

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.

Read the whole story

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.

Read the whole story

Partnerships

DataDirect Connectors are Part of Progress Data Connectivity & Integration Solutions