datadirect-connectors-head-banner

Powerful JDBC Driver for any Data Source or API

OpenAccess SDK

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


    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


    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    PAPER

    Build Custom Driver for Any Data Source or API with OpenAccess SDK

    Progress DataDirect OpenAccess SDK is the industry’s leading custom driver development kit that enables custom drivers for any data source to be developed within weeks.

    TUTORIAL

    Build Your Own Custom JDBC Driver for a Custom REST API - Advanced

    Detailed, step-by-step instructions for creating a JDBC driver in row-based or SQL pass-through mode.

    TUTORIAL

    Build your own Custom JDBC driver for REST API - Quick Start

    Follow along with a quick and easy guide to building your own JDBC driver.

    TUTORIAL

    OpenAccess JDBC Pass Through Mode

    Learn how to build a JDBC driver that operates in SQL pass-through without relying on a template generator.

    Connect any application to any data source anywhere

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