The driver supports basic user ID and password authentication.

To configure the driver to use basic authentication:

  • Set the Host Name (HostName) option to the IP address or domain name of the service to which you want to connect. For example, for S/4HANA, it can be either https://mycompany.s4hana.ondemand.com or http://123.456.7.8.
  • Set the User (User) option to specify the name of the user connecting to the service.
  • Set the Password (Password) option to specify the password for the user connecting to the service.
Note: The User and Password options are not required to be stored in the connection string. They can also be sent separately by the application using the SQLConnect ODBC API. For SQLDriverConnect and SQLBrowseConnect, they will need to be specified in the connection string.

The following examples show the connection information required to establish a session using basic authentication.

Connection string for S/4HANA

DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://mycompany.s4hana.ondemand.com;
User=jsmith;Password=secret;

Connection string for BW/4HANA

DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://myinstance.company.com;
User=JSMITH;Password=secret;

odbc.ini for S/4HANA

[SAP S4HANA]
Driver=ODBCHOME/lib/ivs4hana28.so
...
Description=DataDirect 8.0 SAP S4HANA 
...
HostName=https://mycompany.s4hana.ondemand.com
...
User=JSMITH
...
Password=secret
...

odbc.ini for BW/4HANA

[SAP BW4HANA]
Driver=ODBCHOME/lib/ivs4hana28.so
...
Description=DataDirect 8.0 SAP BW4HANA 
...
HostName=https://myinstance.company.com
...
User=JSMITH
...
Password=secret
...