Progress DataDirect for JDBC for SAP S/4HANA User's Guide Release 6.0.1

Adding a driver

Save PDF

Table of Contents

Adding a driver

Save PDF

Last Updated: July 4, 2023
1 minute read

DataDirect Connectors
JDBC
SAP S/4HANA 6.0
Documentation

To add a driver with DbVisualizer:

Open DbVisualizer.
From the menu, select Tools>Driver Manager. The Driver Manager window opens.
From the Driver Manager menu, select Driver>Create Driver.
Click the button to navigate to the location of the driver jar file; then, click OK. The following are the default locations for the driver:
Windows
```
C:\Program Files\Progress\DataDirect\JDBC\lib\60\s4hana.jar
```
Linux
```
/opt/Progress/DataDirect/JDBC/lib/60/s4hana.jar
```
Note: The same .jar file, s4hana.jar, is used for all SAP ODATA V2 services exposed through the SAP Gateway, including S/4HANA and BW/4HANA.
Provide values for the following fields; then, close the Driver Manager window.
- Name: Type an alias for your driver. For example:
```
S4HANA
```
- URL Format: Optionally, specify the format of the connection string for your driver. For example:
```
jdbc:datadirect:s4hana:ServerName=<server>
```
- Driver Class: From the drop-down menu, select the driver class for your driver:
```
com.ddtek.jdbc.s4hana.S4HanaDriver
```
  Note: The same driver class is used for all SAP ODATA V2 services exposed through the SAP Gateway, including S/4HANA and BW/4HANA.

You can now use your driver with DbVisualizer. Proceed to "Connecting and executing SQL statements" for information on connecting and executing SQL statements.