Progress DataDirect Autonomous REST Connector for ODBC
An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.
Version 8.0.1
Certifications
- Certified with Windows Server 2019
Driver version 08.00.0134 (B0427, U0289)
- Certified with SUSE Enterprise Server 15
Driver version 08.00.0316 (B0612, U0433)
- Certified with Ubuntu Linux 18.04
Driver version 08.00.0024 (B0547, U0390)
- Certified with Red Hat Enterprise 8.0
Driver version 08.00.0024 (B0547, U0390)
- Certified with Red Hat Enterprise 8.0
Driver version 08.00.0273 (B0569, U0402)
Enhancements
- On Windows, the driver now includes the DataDirect ODBC Driver Configuration Manager for quick
configuration and testing of your driver. This Configuration Manager allows you to:
- Configure data sources
- Generate and edit connection strings
- Test connect data sources and connection strings
- Execute SQL commands for testing
- Fetch OAuth tokens and configure OAuth
- Access connection option descriptions and the full product documentation
- On Windows, the DataDirect ODBC Configuration Manager 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 now includes a library of Progress developed Recipe (input REST) files to connect to publicly
accessible REST services. The Recipe files 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.
- On Windows, the Configuration Manager has been enhanced with role-specific work flows:
- On Windows, 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 through the ODBC Administrator.
- 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 Authentication Header (AuthHeader) option and the ID value with the
Security Token (SecurityToken) option. 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=43), you can configure
AWS credentials using the new Access Key (AccessKey), Region (Region), and Secret Key (SecretKey)
options.
- 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 driver, thereby resulting in more
efficient processing.
- The driver has been enhanced to support bearer token and digest authentication.
- The new Health Check URI (HealthURI) connection option provides a method to 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 driver has been enhanced with the new Array Normalization Threshold (ArrayNormalizationThreshold)
connection option. Array Normalization Threshold allows you to specify the length of arrays (in elements)
at which the driver begins to normalize arrays to child tables when generating a flattened view. This
provides you with a method to control the size and focus of your parent table when encountering large
arrays or nested arrays.
- The driver has been enhanced to support connecting through a proxy server. You can configure this
feature using the new Proxy Host (ProxyHost), Proxy Port (ProxyPort), Proxy User (ProxyUser),
and Proxy Password (ProxyPassword) connection options.
- The new Encryption Method (EncryptionMethod) connection option allows you to determine when
TLS/SSL data encryption is enabled.
- The new Port Number (PortNumber) connection option allows you to specify the port number of the
server listener the TCP port of the server that is listening for REST API requests.
- The new Refresh Dirty Cache (RefreshDirtyCache) connection option allows you to determine whether
the driver refreshes a dirty cache on the next fetch operation from the cache.
- The new Refresh Schema (RefreshSchema) connection option allows you to determine whether the
driver automatically refreshes the relational map of when connecting.
- The new Authorization URI (AuthURI) connection option allows you to specify the endpoint used for
obtaining an authorization code from a third-party authorization service for OAuth 2.0 implementations.
- The new Statement Call Limit (StmtCallLimit) and Statement Call Limit Behavior
(StmtCallLimitBehavior) connection options allow you to limit the number of calls made to your
web service.
- The new Web Service Fetch Size (WSFetchSize) allows you to specify the number of rows of data the
driver attempts to fetch for each JDBC call. This provides you with a method to tune the driver for your
ideal balance throughput and response time.
- The new Web Service Pool Size (WSPoolSize) specifies the maximum number of sessions the driver
uses. This allows the driver to have multiple web service requests active when multiple JDBC connections
are open, thereby improving throughput and performance. See Web Service Pool Size on page 164 for
details.
- The new Web Service Retry Count (WSRetryCount) connection options specifies the number of times
the driver retries a timed-out Select request.
- The new Web Service Timeout (WSTimeout) connection option specifies the time, in seconds, that the driver waits for a response to a web service request.
- The driver has been enhanced to support the following new paging parameters in
the input REST file: fieldListParameter, hasMoreElement, pageSizeElement,
totalPagesElement, and totalRowsElement.
- The drivers using base version B0649 and later have been enhanced to
include timestamp in the internal packet logs by default. If you want to
disable the timestamp logging in packet logs, set PacketLoggingOptions=1.
The internal packet logging is not enabled by default. To enable it,
set EnablePacketLogging=1.
- The Driver Manager for UNIX/Linux has been enhanced to support setting the
Unicode encoding type for applications on a per connection basis. By passing a
value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your
application can specify the encoding at connection. This allows your
application to pass both UTF-8 and UTF-16 encoded strings with a single
environment handle.
The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8
and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.
This enhancement is available in build 08.02.0449 of the driver manager.
- The driver has been enhanced to allow you to define custom authentication
requests, including the new Custom Auth Params (CustomAuthParams) connection
option. 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
token-based authentication flows.
- 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 attribute for User connection option has changed from LogonID to User.
- The behaviors assigned to valid values for the Create Map (CreateMap) have been modified.
- The supported valid values for the Authentication Method (AuthenticationMethod) option have changed
from enum to numeric types. If you are using a connection string or odbc.ini file for an earlier version
of the driver, you will need to update the values specified for these options.
- The Application Using Threads (ApplicationUsingThreads) connection option is no longer supported.
The driver now works with single-threaded and multi-threaded applications for all connections.
- The Result Memory Size (ResultMemorySize) connection option is no longer supported. The size of
an intermediate result set is now determined by a percentage of the max Java heap size.
- The IANAAppCodePage (IANAAppCodePage) connection option is longer supported. IANAAppCodePage specified Internet Assigned Numbers Authority (IANA) value if your application was not Unicode enabled or if your database character set was not Unicode.
- The Login Timeout (LoginTimeout) is no longer supported. As a result, connection requests do not
timeout, but the driver responds to the SQL_ATTR_LOGIN_TIMEOUT attribute.
- The Report Codepage Conversion Errors (ReportCodepageConversionErrors) is no longer
supported. As a result, the driver behavior has changed to substitute 0x1A for each character that cannot
be converted and does not return a warning or error.
Version 8.0.0
Features
- The driver supports SQL read-only access to REST API endpoints that return JSON payloads.
- The driver supports all ODBC Core and Level 1 functions and some Level 1 and Level 2 features.
-
The driver supports standard JSON data types and additional data types through data type inference.
- The driver supports using internal memory or a configurable REST file to define REST responses and relational mapping.
- The driver heuristically maps data types, eliminating the need to define native data types in most scenarios.
- The driver supports basic, HTTP-header based, URL-Parameter based and no authentication.
-
The driver supports the handling of large result sets with configurable paging and the Fetch Size connection option.
- The driver includes a new Tableau data source file (Windows only) that provides improved functionality when accessing your data with Tableau.
Changed Behavior
-
The following Windows platforms have reached the end of their product lifecycle
and are no longer supported by the driver*:
- Windows 8.0 (versions 8.1 and higher are still supported)
- Windows Vista (all versions)
- Windows XP (all versions)
- Windows Server 2003 (all versions)