Autonomous REST Connector 6.0 (JDBC)

Progress DataDirect Autonomous REST Connector for JDBC

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 6.0.1

ENHANCEMENTS
  • Includes the DataDirect JDBC Driver Configuration Manager for quick configuration and testing of your driver. This tool allows you to:
    • Generate and edit connection URLs
    • Test connect connection URLs
    • Execute SQL commands for testing
    • Fetch OAuth tokens
    • Access connection property descriptions and the full product documentation
  • The Data Direct JDBC Configuration Manger has been enhanced to support the generation of input REST files. This provides you with a method to quickly generate and edit a REST input file.
  • The driver has been enhanced to support bearer token and digest authentication.
  • The new HealthURI connection property provides a method to allow you test connectivity for authentication methods, such as Basic, Digest, URL Parameter-based, or HTTP header-based, that do not perform an explicit action upon connection.
  • The new TransactionMode connection property allows you to determine how the driver handles manual transactions.
  • The driver has been enhanced to use proxy server settings defined in the JVM system properties by default. If no proxy settings are defined in the connection string or data source, the driver will attempt to use the values of the http.proxyHost and http.proxyPort JVM system properties to connect to the database.
  • The driver has been enhanced to support the following new paging parameters in the input REST file: fieldListParameter, hasMoreElement, pageSizeElement, totalPagesElement, and totalRowsElement.
  • The driver has been enhanced to include timestamp in the Spy and JDBC packet logs by default. If required, you can disable the timestamp logging by specifying the following at connection: For Spy logs, set spyAttributes=(log=(file)Spy.log;timestamp=no) and for JDBC packet logs, set ddtdbg.ProtocolTraceShowTime=false.
  • Interactive SQL for JDBC (JDBCISQL) is now installed with the product. JDBCISQL is a command-line interface that supports connecting your driver to a data source, executing SQL statements and retrieving results in a terminal. This tool provides a method to quickly test your drivers in an environment that does not support GUIs.
  • The driver has been enhanced to allow you to define custom authentication requests, including the new CustomAuthParams connection property. If your service does not support one of the standard authentication methods supported by the driver, you can modify the input REST file to define a custom authentication flow.
  • The driver has been enhanced to allow you to customize how HTTP response status codes are processed by the driver. By configuring the input REST file, you can define error responses for codes that are returned by the service, including driver actions and error messages.
  • The driver has been enhanced to support OAuth 2.0 authentication.
  • The driver has been enhanced to support requests for endpoints that use custom HTTP-headers.
CHANGED BEHAVIOR
  • The CreateMap and SchemaMap properties are no longer supported. The driver now generates the schema map for each session and stores it internal memory.
  • The LoginTimeout property is no longer supported. The LoginTimeout property was used to specify the amount of time that the driver waited for a connection to be established before timing out the connection request.

Version 6.0.0

CERTIFICATIONS
  • The driver has been certified with Oracle JDK 11*
    Driver version 6.0.0.000191 (C0075.F000174.U000090)
  • The driver has been certified with OpenJDK 11*
    Driver version 6.0.0.000191 (C0075.F000174.U000090)
  • The driver has been certified with OpenJDK 8 on Windows and Linux*
    Driver version 6.0.0.000191 (C0075.F000174.U000090) 
FEATURES
  • Supports SQL read-only access to REST API endpoints returning JSON payloads 
  • Supports JDBC core functions
  • Supports standard JSON data types and additional data types through data type inference
  • Supports using internal memory or a configurable REST file to define REST responses and relational mapping 
  • Heuristically maps data types, eliminating the need to define native data types in most scenarios 
  • Supports basic, HTTP-header based, URL-Parameter based and no authentication 
  • Supports the handling of large result sets with configurable paging and the FetchSize and WSFetchSize connection properties


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