dci-transparent-bg

OpenAccess SDK

Quickly Build a Custom Driver for Any Data Source or API

Develop

Build standards-based connectivity (ODBC, JDBC, ADO.NET) for underlying data that is compatible with the most popular analytical and data integration tools. 

Compliance

Personally identifiable information that shouldn’t be seen by all users can be hidden or exposed only on a need-to-know basis. 

Accelerate

OpenAccess SDK is a tool developers can use to handle 99% of the code required to produce a standards-based driver with SQL support

OpenAccess SDK

CUSTOM SOFTWARE DEVELOPMENT KITS

ODBC JDBC ADO.NET

Features

Rapid

Quickly generate a custom driver 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

Learning & Support

Blog

Build Custom ODBC/JDBC Connectors for REST Data Sources Using DataDirect OpenAccess SDK

Need to access RESTful data when your database or BI platform can’t speak the language? Progress DataDirect makes it easy to translate your business-critical data.

Read More

Blog

REST APIs as a SQL Data Source for SAP BOBJ, Cognos or OBIEE

How can you integrate your internal API layer into various BI tools? We answer this and show how to enable SQL access to enterprise APIs in our latest webinar.

Read 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

Success Story

NetSuite Improves Application Connectivity and Integration with DataDirect

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.

Learn More

Success 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.

Learn More

Tutorial

OpenAccess ODBC Pass Through Mode

Read More

Tutorial

Build a custom ODBC driver using .NET

Read More 

Webinar

Why Sotero Trusts Progress DataDirect OpenAccess SDK to Deliver a Secure, Compliant Solution

Register for this webinar to hear why Sotero chose DataDirect OpenAccess SDK and the benefits they've been able to provide their customers.

Watch Webinar

Webinar

Deliver Secure SQL Access for Enterprise APIs

Companies typically build numerous internal applications and complex APIs for enterprise data access. These APIs are often engineered for application developers and based on protocols such as REST or SOAP with payloads in XML or JSON.

However, enterprise data teams need to access this data for analytics, which requires standard query capabilities and the ability to surface metadata. As enterprises adopt new analytical and data management tools, a SQL access layer for this data becomes imperative. Many industries such as financial services, healthcare and technology rely on Progress® DataDirect® OpenAccess™ SDK to build a custom ODBC, JDBC, ADO.NET or OLE DB layer on top of their internal APIs and hosted multi-tenant databases.

Watch this on-demand webinar to learn about:

  • Use cases for providing SQL access to your enterprise data
  • How organizations provide SQL Access to their APIs
  • Pitfalls and best practices to building SQL access

Plus—don’t miss our live demo using OpenAccess SDK to provide SQL access for a REST API.

Watch Webinar

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

Customer Success Stories

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

Unisys Global Media embeds DataDirect Technologies’ wire protocol ODBC driver for Oracle within Hermes, its news content manager. As a result, Unisys customers have fast-to-the-wire access to Oracle databases and seamless integration between Unisys' editorial solutions and their existing databases and software packages.

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