Interface-Hero-Background

OpenAccess SDK

Build a Custom JDBC Driver for Any Data Source or API

Download OpenAccess SDK for JDBC

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

    See Also

    Get Customer Support

    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

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

    Contact Us