This string includes the options used to connect using basic user name and password authentication.
Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see Using a connection string. 
DRIVER=DataDirect 8.0 SAP S4HANA;HostName=host_name;ServiceList=service[,service[,...]];
User=user_name;Password=password;[attribute=value[;...]];

where:

host_name
specifies the base URL with either the IP address or the domain name of the service to which you want to issue requests. For example, for S/4HANA, it can be either https://mycompany.s4hana.ondemand.com or http://123.456.7.8.
user_name
specifies the user name that is used to connect to the service. For example, JSMITH.
service
(optional) specifies the standard and/or custom service(s) to which the driver connects.
Note: Service List (ServiceList) allows you to limit the services to which the driver connects, thereby eliminating the discovery process and improving performance at connection. In addition, this option provides a method to connect to services not included in your communication scenario.
password
specifies the password used to connect to your service.
attribute=value
specifies connection option settings. Multiple option attributes are separated by a semi-colon.
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.
Note: The following example connection string includes the options required for connecting with basic authentication:
For S/4HANA:
DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://mycompany.s4hana.ondemand.com;
ServiceList=API_BUSINESS_PARTNER,API_SALES_ORDER_SRV;User=JSMITH;Password=secret;
For BW/4HANA: 
DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://myinstance.company.com;
ServiceList=API_BUSINESS_PARTNER,API_SALES_ORDER_SRV;User=JSMITH;Password=secret;