Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

SAP S/4HANA ODBC 8.0.1 Windows

  • Last Updated: May 8, 2026
  • 11 minute read
    • OpenAccess SDK
    • Documentation

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for SAP S/4HANA(TM)

     Windows Platforms (32- and 64-bit) 

     8.0.1 Release
     February 2026


***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved.
 
***********************************************************************


CONTENTS

Post-GA Product Announcements
Installation Directory 
Requirements
Data Source and Platform Support 
Changes Since 8.0.1 GA 
Changes for 8.0.1 GA 
Release 8.0.0 Features  
DataDirect ODBC Driver Configuration Manager 
Notes, Known Problems, and Restrictions
Driver Workaround Options
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers


   Post-GA Product Announcements

The readme files will no longer be updated with product announcements and new 
features after the General Availability (GA) of the product. For the latest 
updates and enhancements, please refer to the release notes 
(https://www.progress.com/datadirect-connectors/whats-new).


    Installation Directory

* The default installation directory for the 32-bit driver on a 64-bit 
  system is:

  C:\Program Files (x86)\Progress\DataDirect\ODBC

* The default installation directory for all other installations is:

  C:\Program Files\Progress\DataDirect\ODBC


    Requirements

* The installer program requires a JVM that is Java SE 11 or higher, including
  Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

* The driver requires a Java Virtual Machine (JVM): Java SE, version 8 or 
  higher, including Oracle JDK, OpenJDK, IBM SDK (Java), or higher 
  LTS versions.

* The driver requires the following runtime library:
  Microsoft Visual C/C++ runtime version 14.40.33810 or higher

* IMPORTANT: You must have the Microsoft Data Access Components (MDAC) 
  installed to use this product.
 
  - For 32-bit Windows systems, version 2.6 or higher is required.
  - For 64-bit Windows systems, version 2.8 or higher is required.

  Depending on the version of your Windows operating system, these 
  components may already be installed. You can download a utility that 
  determines whether MDAC is installed and its version from the following
  Microsoft site:

  http://msdn.microsoft.com/en-us/data/aa937730.aspx

  You can also download MDAC from the same site.


    Data Source and Platform Support

For the latest data source and platform support information, refer to the 
Product Compatibility Guide: 
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf  

  
    Changes Since 8.0.1 GA 

CVE-2022-41853 - Use of Externally-Controlled Input to Select Classes or Code 
('Unsafe Reflection')
-----------------------------------------------------------------------------
Several Progress DataDirect ODBC drivers utilized a version of HyperSQL 
Database that was vulnerable to remote code execution described in 
CVE-2022-41853.  All impacted drivers have been patched to fix this 
vulnerability.  For details on impacted drivers and fixed versions, refer to 
the following KB article: 
https://community.progress.com/s/article/DataDirect-ODBC-Critical-Security-
Bulletin-November-2022-CVE-2022-41853	

Enhancements
------------
* The product package now includes .pdb files. These files contain debugging 
  symbols that can be used for diagnosing and debugging issues in the driver.

* The driver is now compiled with a Visual Studio 2022 compiler for 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 ICU library files that are installed with the product have been 
  upgraded to version 74.1. As a part of this upgrade, the ICU library 
  file names have changed:
  - For the 32-bit driver: From ivicu28.dll to ivicu.dll
  - For the 64-bit driver: From ddicu28.dll to ddicu.dll

  This upgrade is available starting in build 08.02.1072 of the ICU 
  library files.

Changed Behavior
----------------
* The installer program now requires you to install a JRE that is Java SE 11 or
  higher before running the installer. In earlier versions, the JRE used by the
  installer program was included in the product. However, to avoid potential
  security vulnerabilities, the installer program no longer includes a JRE.
  Instead, the installer program uses the JRE in your environment to allow for
  the most secure version of a JRE to be used.
 
  Notes:
  - This change does not affect the JVM requirements for the driver. For the latest 
    driver requirements, refer to the Product Compatibility Guide:
    https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
    datadirect-product-compatibility.pdf
  - The installer program cannot remove the already installed JRE files from the 
    install directory automatically. Remove them manually.
  - To install the 32-bit drivers on 64-bit Windows platforms and start the SQL 
    engine service, the installer requires the 32-bit version of Java SE 11 or 
    higher installed on your machine and defined on your path.

  
  
    Changes for 8.0.1 GA
	
Enhancements 
------------
* The driver has been enhanced to support 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 determine the maximum size of VARCHAR columns 
  within the result set metadata using the new Maximum Varchar Size connection 
  option.
  
* The driver has been enhanced to support a default value of 100000 and a
  maximum value of 1000000 for the Web Service Fetch Size connection option.

Changed Behavior
----------------
* The installer program has been updated to no longer install common components 
  for drivers that do not use them. As a result, the installer program no longer 
  installs the following common components for the SAP S/4HANA driver: 

  - OpenSSL library files, such as ivopenssl30.dll, ddopenssl30.dll, fips.dll, and
    openssl.cnf.
  - Curl library files, such as ivcurl28.dll and ddcurl28.dll.

  If the files are not used by any other DataDirect driver on your machine, you 
  can safely remove them from existing product directories.  
 

    Release 8.0.0 Features   

The Progress DataDirect for ODBC for SAP S/4HANA driver supports SQL read-write
access for ODBC applications to S/4HANA. To support SQL access, the driver
creates a relational map of the S/4HANA data model and translates SQL statements
to S/4HANA OData requests. In addition, the driver employs a SQL engine
component that provides support to SQL constructs unavailable in S/4HANA. This
functionality offers a number of advantages, including support for reporting
data and metadata in a form that ODBC applications are ready to use.

Features:
    
* Supports SQL read-write access to SAP S/4HANA

* Supports all ODBC Core and Level 1 functions and some Level 1 and 
  Level 2 features
  
* Supports S/4HANA data types through data type inference

* Supports custom fields, including many fields added through third-party
  plug-ins

* Supports basic (user ID and password) authentication

* Supports SSL data encryption 

* Supports the handling of large result sets with paging, and the
  Fetch Size (FetchSize) and WSFetch Size (WSFetchSize) connection options 
  
* 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 URLs
  - Test connect data sources and connection URLs  
  - Execute SQL commands for testing  
  - Access connection property descriptions and the full product
    documentation
 
 
    DataDirect ODBC Driver Configuration Manager 
    
The driver includes a browser-based configuration tool, the DataDirect ODBC
Driver Configuration Manager, that allows you to generate and test connection
URLs that you can use with your application. You can launch the Configuration
Manager by opening the ODBC Administrator from the Progress DataDirect 
program group and creating or configuring a data source for the driver.  

The Configuration Manager will open in your default web browser. For more
information, refer to the user's guide for your driver. 
 
 
    Notes, Known Problems, and Restrictions 

The following are notes, known problems, and restrictions for the driver:

Specifying values for the same connection option multiple times
--------------------------------------------------------------- 
The driver does not support specifying values for the same connection 
option multiple times in a connection string or DSN. If a value is 
specified using the same attribute multiple times or using both 
long and short attributes, the connection may fail or the driver may 
not behave as intended.

Inaccurate Error Message for Unsupported Delete Operations
----------------------------------------------------------
If you attempt to execute Delete operations against SAP OData services that do 
not support them, the driver will return the following inaccurate error 
message: "Expected a string but was BOOLEAN." Contact Technical Support if you
encounter issues.

Filtering by NULL Values in columns associated with NOT NULL constraints
------------------------------------------------------------------------
Updating a NULL value in a column associated with a NOT NULL constraint in a 
schema table updates the value in the respective column as an empty string.  
To filter based on a NULL value in this scenario, specify an empty string in 
the WHERE clause of a SQL statement. Contact Technical Support if you encounter
issues.

Update and Delete support on services with E-Tag validation
------------------------------------------------------------
The driver does not support update or delete operations on services that 
require E-Tag validation. If you execute update or delete operations on a
service requiring E-Tag validation, the driver returns a 428 error.

Services with non-standard paths 
--------------------------------
The driver does not connect to services specified by the Service List 
(ServiceList) option that have a different relative path than the standard, 
which is https://<hostname>/sap/opu/odata/sap.

NULL and empty values service inconsistency
-------------------------------------------
When a column without a value is queried, the driver returns a NULL instead of
an empty string. All filter operations require the use of empty strings for 
such columns.

Connection issues when specifying ExtendedOptions 
-------------------------------------------------
When specifying a value for the Extended Options (ExtendedOptions) option in 
the Configuration Manger, the driver currently adds the option and its value to
the Connection String field. However, the ExtendedOptions attribute is not 
supported in Connection Strings; therefore, attempting to connect with the 
generated connection string or executing a test connect with the configuration
manager will result in the an "Invalid attribute in the connection string: XO" 
error. 

To work around this issue, manually edit the connection string to remove 
"ExtendedOptions=" from the connection string; then, specify the value of 
ExtendOptions as semi-colon separated options in the string. 

For example:  
Driver=<driver_name>;HostName=<host_name>;ExtendedOptions=WorkArounds2=4096,
WorkArounds2=8192;

Becomes: 
Driver=<driver_name>;HostName=<host_name>;WorkArounds2=4096;WorkArounds2=8192;

Out-of-memory Errors
--------------------
The driver has been designed to handle large result sets that result. However,
out-of-memory errors can still occur. The following items outline how to reduce
the likelihood of out-of-memory errors for your environment.

* Reduce Fetch Size (FetchSize) to reduce demands on memory. By lowering the 
  maximum number of rows as specified by Fetch Size, you lower the number of 
  rows the driver is required to process before returning data to the 
  application. Thus, you reduce demands on memory and decrease the likelihood 
  of out-of-memory errors.

* Increase the JVM heap size. By increasing the max Java heap size, you increase
  the amount of data the driver can accumulate in memory and avoid 
  out-of-memory errors.

126 Error When Modifying Data Sources on Windows 10
---------------------------------------------------
You may receive a 126 error when adding or configuring a data source stored
on a network location. This might be caused by the settings of the User Account
Control (UAC) security feature on Windows 10. To work around this issue:

Important: Implementing this fix disables security safeguards that are designed
to protect your machine. Before starting, refer to the following Microsoft 
documentation for potential risks associated with disabling the UAC feature:  
http://windows.microsoft.com/en-us/
windows/what-are-user-account-control-settings

1.  From the Start menu, type regedit in the search field; then, select regedit
    from the results list. The Registry Editor window opens. 

2.  Navigate to the following registry subkey: 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

3.  Right click on the subkey; then, select New > DWORD Value. 

4.  Rename the new value EnableLinkedConnections. 

5.  Right-click EnableLinkedConnections, and then click Modify. The Edit DWORD 
    Value window opens. 

6.  In the Value data field, type 1. Click OK. 

7.  Close the Registry Editor; then, restart your computer. 


    Driver WorkAround Options

Progress DataDirect has included non-standard connection options (workarounds)
for the driver that enable you to take full advantage of  packaged ODBC-enabled
applications requiring non-standard or extended behavior. Refer to the chapter
"WorkAround options" in THE PROGRESS DATADIRECT FOR ODBC DRIVERS REFERENCE for a
description of these options.


    Documentation

PROGRESS DATADIRECT FOR ODBC FOR SAP S/4HANA DOCUMENTATION SET
--------------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:

https://docs.progress.com/category/datadirect-sap-s4hana

You can access the online help system directly in either of the following ways.
* Via the HTML redirect in the installation Help directory
* By selecting Help from the information menu (? button) in the Configuration
  Manager  
  
  
 
   Installed Files for the 32-bit Driver

This file list assumes a full installation of the driver and 
documentation.

The installer copies the following file to the Windows system 
directory:

ivtrc28.dll           DataDirect trace library

The installer copies the following files and subdirectories to the 
product installation directory, by default:

For 32-bit drivers on 64-bit machines:
  C:\Program Files (x86)\Progress\DataDirect\ODBC\:

For all other installations:
  C:\Program Files\Progress\DataDirect\ODBC\:

\<install_dir>\:
----------------
license.txt                      Progress DataDirect license agreement


\drivers:
---------
ivs4hana28.dll                   DataDirect S/4HANA driver
ivs4hana28.pdb                   Debugging symbols for DataDirect 
                                 S/4HANA driver  
ivs4hana28r.dll                  DataDirect S/4HANA driver resource file
ivicu.dll                        Unicode conversion tables
ivicu.pdb                        Debugging symbols for ICU library
IVODBC.LIC                       DataDirect License File
ivtrc28.dll                      DataDirect trace library
ivtrc28.pdb                      Debugging symbols for DataDirect trace library
qesqlext.h                       Header file for DataDirect-specific 
                                 ODBC Definitions


\FIXES\:
--------
fixes8.0.txt                     List of fixes since last release


\help\:
-------
*.html                           HTML redirects to online connector help
                                 systems and documentation resources    


\install\:
---------
*.*                              Files associated with the installer program


\java\lib\:
-----------
s4hana.jar                       Java components for the driver


\NOTICES\:
---------
ODBC for SAP S4HANA 
v8.0 notices.txt                 Third-party vendor license agreements


\READMES\:
---------
ODBC for SAP S4HANA   
v8.0 readme.txt                  This file


\samples\bulk\:
---------------
bulk.c                           Bulk example source
bulk.exe                         Bulk application
bulk.mak                         Bulk example make file
bulk.sln                         Bulk example solution file
bulk.vcproj                      Bulk example project file
ddlogging.properties             Log configuration file for
                                 the S/4HANA driver

\samples\bulkstrm\:
------------------
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulk.rc                          Bulk streaming example resource file
bulkstreaming.sln                Bulk streaming example solution file
bulkstreaming.vcproj             Bulk streaming example project file
bulkstrm.exe                     Bulk streaming example application
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 S/4HANA driver
msgprintf.hpp                    Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp                      Bulk streaming example source file


\samples\example\:
------------------
ddlogging.properties             Log configuration file for the 
                                 S/4HANA driver  
example.c                        Example source
Example.exe                      Example application
example.h                        Example header
Example.mak                      Example make file
Example.sln                      Example solution file
Example.vcproj                   Example project file


\samples\translat:
-----------------
LIBMAIN.C
README.TRN                       Translation Library example description
TRANSLAT.C                       Translation Library example source file
WINNT.MAK                        Translation Library example make file

\tools\:
--------
ddextwin.exe                     License Extender utility
ddprocinfo.exe                   Processor Information utility
DSNConverterSil.exe              Data Source Converter utility
S4hanaserver32.exe               The S/4HANA driver SQL 
                                 Server Engine
XMLP.exe                         A GUI demo tool that persists a result set to
                                 an XML data file


\tools\Power BI:
----------------
DataDirectS4HANA.pqx             S/4HANA Power BI connector file
install.bat                      Batch file to install Power BI connectors


\tools\Tableau\:
----------------
DataDirect SAP S4HANA.tdc        Tableau data source file                                 
                
                
\uninstall\:
------------
*.*                              Files used to uninstall the product                                


   Installed Files for the 64-bit Driver

This file list assumes a full installation of the driver and 
documentation.

The installer copies the following file to the Windows system 
directory:

ddtrc28.dll                      DataDirect trace library

The installer copies the following files and subdirectories to the 
product installation directory, by default:

  C:\Program Files\Progress\DataDirect\ODBC\:

\<install_dir>\:
----------------
license.txt                      Progress DataDirect license agreement


\drivers\:
----------
dds4hana28.dll                   DataDirect S/4HANA driver
dds4hana28.pdb                   Debugging symbols for DataDirect 
                                 S/4HANA driver   
dds4hana28r.dll                  DataDirect S/4HANA driver resource file
ddicu.dll                        Unicode conversion tables
ddicu.pdb                        Debugging symbols for ICU library
DDODBC.LIC                       DataDirect License File
ddtrc28.dll                      DataDirect trace library
ddtrc28.pdb                      Debugging symbols for DataDirect trace library
qesqlext.h                       Header file for DataDirect-specific ODBC 
                                 Definitions


\FIXES\:
--------
fixes8.0.txt                     List of fixes since last release


\help\:
-------
*.html                           HTML redirects to online connector help
                                 systems and documentation resources    
                    
                    
\java\lib\:
-----------
s4hana.jar                       Java components for the driver


\NOTICES\:
----------
ODBC for SAP S4HANA 
v8.0 notices.txt                 Third-party vendor license agreements


\READMES\:
----------
ODBC for SAP S4HANA 
v8.0 readme.txt                  This file


\samples\bulk\:
---------------
bulk.c                           Bulk example source
bulk.exe                         Bulk application
bulk.mak                         Bulk example make file
bulk.sln                         Bulk example solution file
bulk.vcproj                      Bulk example project file
ddlogging.properties             Log configuration file for
                                 the S/4HANA driver

\samples\bulkstrm\:
------------------
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulk.rc                          Bulk streaming example resource file
bulkstreaming.sln                Bulk streaming example solution file
bulkstreaming.vcproj             Bulk streaming example project file
bulkstrm.exe                     Bulk streaming example application
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 S/4HANA driver
msgprintf.hpp                    Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp                      Bulk streaming example source file


\samples\example\:
------------------
ddlogging.properties             Log configuration file for the 
                                 S/4HANA driver  
example.c                        Example source
Example.exe                      Example application
example.h                        Example header
Example.mak                      Example make file
Example.sln                      Example solution file
Example.vcproj                   Example project file


\samples\translat:
-----------------
LIBMAIN.C
README.TRN                       Translation Library example description
TRANSLAT.C                       Translation Library example source file
WINNT.MAK                        Translation Library example make file


\tools\:
-------
ddextwin.exe                     License Extender utility
ddprocinfo.exe                   Processor Information utility
DSNConverterSil.exe              Data Source Converter utility
s4hanaserver64.exe               The S/4HANA driver SQL Server Engine 
XMLP.exe                         A GUI demo tool that persists a result set to
                                 an XML data file


\tools\Power BI:
----------------
DataDirectS4HANA.pqx             S/4HANA Power BI connector file
install.bat                      Batch file to install Power BI connectors


\tools\Tableau\:
----------------
DataDirect SAP S4HANA.tdc        Tableau data source file 


\uninstall\:
------------
*.*                              Files used to uninstall the product

  
  
~~~~~~~~~~~~~~~
February 2026
End of README.TXT
TitleResults for “How to create a CRG?”Also Available inAlert