Progress DataDirect for JDBC for SAP S/4HANA Driver
An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.
For a list a list of issues resolved since general availability, refer to the fixes.
The installer program has been enhanced to support Azul Zulu JRE 11. As a result of this change, the installer has ended support for some of the old operating systems. The installer supports the following operating systems after the enhancement:*
Any operating system on a machine using a JRE that is Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
Windows 8.1 or higher
Windows Server 2012 RC2 or higher
Important: These changes do not affect the operating system requirements of the driver.
The driver has been enhanced to support SAP BW/4HANA and other SAP ODATA V2 services exposed through the SAP Gateway.
The driver has been enhanced to support CDS views that require parameters.
The driver has been enhanced to support HTTP Header authentication for use with the S/4HANA sandbox hosted at https://api.sap.com.
The driver has been enhanced to support a default value of 100000 and maximum value of 1000000 for the connection property WSFetchSize.
The driver has been enhanced to set the maximum size of VARCHAR columns within the result set metadata using the MaxVarcharSize connection property.
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 HostName connection property has been renamed ServerName. To support existing configurations, HostName will continue to be supported as an alias for ServerName.
Supports SQL read-write access to SAP S/4HANA cloud data source
Supports JDBC core functions
Supports the core SQL-92 grammar
Supports SAP S/4HANA data types through data type inference
Supports Basic authentication
Supports SSL data encryption
Supports connection to custom business objects and views via custom services, including custom fields added through SAP S/4HANA UI.
Supports the handling of large result sets with paging and the FetchSize connection property
Includes Interactive SQL for JDBC (JDBCISQL). It 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.
Includes the Progress DataDirect S/4HANA Configuration Manager for quick configuration and testing of your driver in a web browser. The tool allows you to:
Generate and edit connection URLs
Test connect connection URLs
Execute SQL commands for testing
Access connection property descriptions and the full product documentation