Progress DataDirect for ODBC for SAP S/4HANA User's Guide Release 8.0.1

What's new in this release?

Save PDF

Save PDF

Visit the following web pages for the latest support and certification information.

Enhancements
- The driver is now compiled with a Visual Studio 2022 compiler for the Windows platforms. As a result, you must have Microsoft Visual C/C++ runtime version 14.40.33810 or higher on your machine to run the driver.
- The driver has been enhanced to support SAP BW/4HANA and other SAP ODATA V2 services exposed through the SAP Gateway.
  - For details, see Supported SQL statements and extensions.
  - For information on SAP services that use ODATA V2 APIs, refer to the SAP API documentation: ODATA V2.
- The driver has been enhanced to support CDS views that require parameters. For details, see CDS views.
- The driver has been enhanced to support HTTP Header authentication for use with the S/4HANA sandbox hosted at https://api.sap.com. See HTTP header authentication (S/4HANA only) for details.
- The driver has been enhanced to support a default value of 100000 and a maximum value of 1000000 for the connection option Web Service Fetch Size.
- The driver has been enhanced to determine the maximum size of VARCHAR columns within the result set metadata using the new Maximum Varchar Size connection option.
- A Password Encryption Tool, called ddencpwd, is now included with the product package. It encrypts passwords for secure handling in connection strings and odbc.ini files. At connection, the driver decrypts these passwords and passes them to the data source as required. See Password Encryption Tool (UNIX/Linux only) for details.

The driver supports SQL read-write access to SAP S/4HANA. For details, see Supported SQL statements and extensions and Introduction to the SAP S/4HANA data model.
The driver supports all ODBC Core and Level 1 functions and some Level 1 and Level 2 features.
Refer to ODBC API and scalar functions in the Progress DataDirect for ODBC Drivers Reference for additional information.
Supports S/4HANA data types through data type inference. See Data types for details.
The driver supports custom fields, including many fields added through third-party plug-ins.
The driver supports Basic authentication. See Basic authentication for details.
The driver supports the handling of large result sets with paging, and the Fetch Size (FetchSize) and Web Service Fetch Size (WSFetchSize) connection options. See Fetch Size and Web Service Fetch Size for details.
On Windows platforms, the driver includes a redesigned ODBC setup dialog, the DataDirect ODBC Driver Configuration Manager, for quick configuration and testing of your driver. The Configuration Manager allows you to:
- Configure data sources
- Generate and edit connection URLs
- Test connect data sources and connection URLs
- Execute SQL commands for testing
- Access connection option descriptions and the full product documentation
See Configuring data sources with the Configuration Manager and Generating connection strings with the Configuration Manager for details.