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
  • The driver now includes a library of Progress developed Recipe (input REST) files to connect to publicly accessible REST services. The Recipe files fully define the requests and pagination settings for a data source, eliminating the need to create your own input REST file. After selecting your data source from the Configuration Manager, you only need to provide your authentication credentials to begin accessing your data.*
  • The Configuration Manager has been enhanced with role-specific work flows:*
    • The developer view of the Configuration Manager provides access to the new Recipes library, REST Management Tool, and configuration properties. In addition, the Hub window has been added that includes access to training videos, documentation, and technical support. The developer's view can be launched through the new desktop and Start menu icons.
    • The user's view provides a simplified interface that allows you to configure and test your connection. You can launch the user's view by double-clicking on the autorest.jar file or launching it from a command prompt.
  • The driver now supports responses returned in XML and CSV formats in addition to JSON. When sampling an endpoint, the driver detects the format of the response before mapping the objects to the relational view of the data. If multiple formats are supported by the service, the driver defaults to using JSON; however, you can also configure the driver to use your preferred format.*
  • The driver has been enhanced to support passing custom HTTP headers when using OAuth 2.0 authentication. When OAuth 2.0 is enabled (AuthenticationMethod=OAuth2), you can now pass the HTTP header name with the AuthHeader property and the ID value with the SecurityToken property. This functionality can be used for passing the ID string for tenant ID authentication.*
  • The driver has been enhanced to support AWS (Amazon Web Services) credentials authentication. When AWS credentials authentication is enabled (AuthenticationMethod=AWS), you can configure AWS credentials using the new AccessKey, Region, and SecretKey properties.
  • The driver has been enhanced to support issuing POST requests that use custom parameters. This allows for filtering in scenarios where complex parameter syntax is employed, such as using complicated JSON data or empty arrays.*
  • The driver has been enhanced to support issuing GET requests that use custom parameters, such as those supported by JQL or SOQL, when filtering results. Using the custom parameters supported by your service allows queries to be processed before returning results to the driver, thereby resulting in more efficient processing.*
  • 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