dci-transparent-bg

Build Custom Driver for Any Data Source or API Within Days

Create

Develop a custom driver in ODBC, JDBC, ADO.NET or OLE DB

Comprehensive

Quickly integrate data across any C, C++, Java, .NET, REST, ABL or C# application

Fast

Create quicker data access solutions to proprietary files or APIs

OpenAccess SDK
CUSTOM SOFTWARE DEVELOPMENT KITS
ODBC JDBC ADO.NET OLE DB

Features

Rapid

Generate a custom driver in 2 hours using our prebuilt addons or develop directly against SDK interfaces

Ease of Use

Provides the fastest way to make your application compatible with data-centric tools, such as BI and analytics, ETL and more

Single Interface

Enables implementation of a single interface for data access from all standards-based APIs

Broad Coverage

Broadens data connection and application platform options while expanding developer knowledge

Enterprise-class Performance

Improve efficiency and speed with optimized query execution completed by an OpenAccess SQL Engine

Extensive SQL Support

Optimizes CRUD operations with the OpenAccess SQL engine to reduce coding and improve usability

OpenAccess Add-ons

OpenAccess REST IP Generator to accelerate development.

custom-connector-sdk
OpenAccess for REST API

Framework that enables you to build a driver for any REST data source quickly and easily. Available for all platforms listed for Server and IP SDK.

Technical Specs

  • Compatible with the latest ODBC (3.8) and JDBC (4.0) standards
  • Supports all major OS platforms including Microsoft Windows, Linux, AIX, Solaris, and more 
  • Built in SQL engine is SQL 92 compliant to allow queries with joins, unions, nested query, stored procedures, insert, update, delete, group by, order by, and other SQL syntax to be executed over any data source
  • Supports both 32 bit and 64 bit applications
  • OpenAccess SDK components are covered by Progress' Security Vulnerability Response Policy

Learning & Support

Blog

Quick Guide: Build a Custom ODBC Driver in C/C++, Java or C#

Are you struggling to find a driver for your amazing, unique application? Here's the quickest way to create a custom driver.

Read More

Paper

OpenAccess SDK Overview

Download Paper

Paper

Deliver Secure SQL Access for Enterprise APIs: For Enterprise Architects and ISVs

IT needs a fast way to SQL-enable their internal API layer for business intelligence.

Organizations are investing heavily in API layers to control authentication and data access from one place. However, enterprise data teams can’t access this data from their favorite BI tools such as IBM Cognos, OBIEE, TIBCO or MicroStrategy without complex custom coding.

As companies adopt multiple analytical and data management tools, SQL access to the enterprise API layer (or data access layer) is crucial. The ideal solution enables you to quickly build real-time access to your API layer from popular BI tools, while taking advantage of centralized API management capabilities.

Download the whitepaper to learn:

  • 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
  • What to look for in a connector SDK for delivering SQL clients (ODBC, JDBC, ADO.NET and OLE-DB)
  • Steps to deliver custom SQL connectivity in under five days

Download Paper

Tutorial

Build a Custom Driver for IBM Cognos

Several consultants of IBM Cognos often get requests to support data sources with a custom ODBC driver or a Custom JDBC driver. In this tutorial, you can learn how to use OpenAccess to build custom drivers.

Read More
Success Story

VoltDB

Using the Progress DataDirect OpenAccess SDK, VoltDB reduced its time to market by 50% versus using other solutions, developing a prototype in one month and releasing its new driver in just three months.

Learn More

Video

ODBC SDK for REST APIs with Tableau

Watch this quick demo video to learn how to connect from Tableau with SQL ODBC access to your REST APIs and security policies.

Watch Video

Customer Success Stories

coins-min

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

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

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

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

tableau
datastax
Oracle_Service_cloud

Connect any application to any data source anywhere

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