DataDirect Connectors Build JDBC Driver for any Data Source or API

OpenAccess SDK
Create

Easily develop custom JDBC driver across C, C++, Java, REST, ABL or C#

Efficient

Easily develop applications for the JDBC Client with pre-built components

Secure

Give users access to all enterprise data without compromising security

Features

portable

Portable

Provides accelerators, like the REST IP
Wizard, to produce the driver source code
for you using your REST data
source-based metadata
usability

Easy to Use

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

Single Interface

Enables implementation of a single
data access interface from all
standards-based APIs, from Windows
and Linux/UNIX
connectivity

Broad Coverage

Broadens data connection and
application platform options while
expanding developer knowledge
performance

Enterprise-Class Performance

Optimizes query execution using the OpenAccess SQL Engine to improve efficiency and speed
extensive_SQL_support

Extensive SQL Support

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

System Requirements

You can develop applications for the JDBC Client using J2SE 1.5.0_06 or higher, and the following APIs, which are supplied with the JDBC Client:

  • JDBC 2.0 Optional Package
  • JNDI 1.2
  • JTA 1.0.1
For Applications Using Minimum Product Requirements
JDBC 3.0 API J2SE 1.5.0_06 or higher
J2EE Connector Architecture J2SE 1.5.0_06 or higher
JDBC 2.0 Core API J2SE 1.5.0_06 or higher
JDBC 2.0 Optional Package J2SE 1.5.0_06 or higher
XADataSource J2SE 1.5.0_06 or higher and minimum J2EE 1.2
DataSource, ConnectionPoolDataSource JNDI 1.2

Standard installations of J2SE on some platforms do not include the jar file containing the extended encoding set that is required to support some of the less common database code pages. To verify whether your J2SE version provides extended code page support, check that charsets.jar is installed in the lib subdirectory of your J2SE installation directory.

If you do not have the required file, re-install J2SE, making sure you install the international version of J2SE.

Learning & Support

Types of JDBC Drivers

FAQ

Types of JDBC Drivers

Before you start building your own custom JDBC driver, this article will help you understand the different types of JDBC drivers. This is a good start to build a JDBC driver

Read the Blog


Quick Guide to Build Custom JDBC Driver

Quick Guide

Build a JDBC 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 JDBC Drivers for IBM Cognos

TUTORIAL

Build a Custom JDBC Driver for IBM Cognos

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

Read the Tutorial


Build Custom Driver Case Study - VoltDB

CASE STUDY

Learn how VoltDB used OpenAccess to build custom drivers

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. In this case study learn how to build a custom driver.

Read the Case


opening_the_salesforce_data_silo

WEBINAR

Build JDBC 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 JDBC driver.

Register for webinar

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.
Read the whole story
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.
Read the whole story
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.
Read the whole story
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.
Read the whole story

Partnerships

tableau
datastax
Oracle_Service_cloud

DataDirect Connectors are Part of Progress Data Connectivity & Integration Solutions

icon-info-b

DataDirect Connectors

Connect any data source to any application

icon-contact-us-b

Contact Us

A Progress sales representative will be glad get in
touch with you