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=hostname;ServiceList=service[,service[,...]];User=user_name;
Password=password;[attribute=value[;...]];
where:
hostname
specifies the URL of the SAP S/4HANA instance to which you want to issue requests. For example,
https://mycompany.s4hana.ondemand.com.
user_name
specifies the user name that is used to connect to the SAP S/4HANA instance. 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 SAP S/4HANA instance.
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:
DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://mycompany.s4hana.ondemand.com;
ServiceList=API_BUSINESS_PARTNER,API_SALES_ORDER_SRV;User=JSMITH;
Password=secret;
