OpenAccess SDK
Build a Custom JDBC Driver for Any Data Source or API
Table of Contents:
Overview
Progress DataDirect’s JDBC Driver for any Data Source or API offers a high-performing, secure and reliable connectivity solution for JDBC applications to access any Data Source or API data. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.
- Easily develop custom JDBC driver across C, C++, Java, REST, ABL or C#
- Easily develop applications for the JDBC Client with pre-built components
- Give users access to all enterprise data without compromising security
Features
Portable
Provides accelerators, like the REST IP Wizard, to produce the driver source code for you using your REST data source-based metadata
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
Enables implementation of a single data access interface from all standards-based APIs, from Windows and Linux/UNIX
Broad Coverage
Broadens data connection and application platform options while expanding developer knowledge
Enterprise-Class Performance
Optimizes query execution using the OpenAccess SQL Engine to improve efficiency and speed
Extensive SQL Support
Optimize CRUD operations with the OpenAccess SQL engine to reduce coding and improve usability
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
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.
Documentation
Progress DataDirect OpenAccess SDK
- Installation Guide
- Upgrade Notes
- Readme
- Administrator's Guide
- Client Reference
- Troubleshooting Guide
- Programmer's Guide
- Programmer's Reference for C and C++
- Programmer's Reference for Java
- Programmer's Reference for .NET
- Third-party SQL Engine Programmer's Guide
- SQL Reference
- Debugging the IP
- Data Conversions Supported by the OpenAccess SQL Engine