Build a Custom ODBC Driver - OpenAccess SDK

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

Data Security

Keep the data secure during transit with latest security protocols like TLS v1.3, also use the SDK to support data encryption at rest by integrating with custom data encryption and business rules providers

Technical Specifications

Requirements for OpenAccess SDK Client for ODBC

Windows Client 32-bit Platforms
- Microsoft Data Access Components (MDAC), version 2.7 Service Pack 1 or higher
- Microsoft Visual C++ Redistributable (x86) version 14.42.34438.0 or higher
Windows Client 64-bit Platforms
- Microsoft Data Access Components (MDAC), version 2.8 (64-bit) or higher
- Microsoft Visual C++ Redistributable (both x86 and x64) version 14.42.34438.0 or higher
Linux Platforms
- C/C++ runtime libraries of GCC 8.5 or higher

Requirements for OpenAccess SDK Local Client for ODBC and IP SDK

Windows Platforms
- Microsoft Data Access Components (MDAC), version 2.7 Service Pack 1 or higher
- MMC 2.0 or higher
- Runtime requirement:
  - Windows 32-bit: Microsoft Visual C++ Redistributable (x86) version 14.42.34438.0 or higher
  - Windows 64-bit: Microsoft Visual C++ Redistributable (both x86 and x64) version 14.42.34438.0 or higher
Linux Platforms
- Korn shell. This requirement applies to Linux, which by default is not shipped with a Korn shell
- C/C++ runtime libraries of GCC 8.5 or higher