This string includes the options you may need to connect through a proxy server with basic authentication.
Note: The strings demonstrated in this section use the DSN-less format. For additional formats, see "Using a connection string."

This string includes the options used to connect through a proxy server with authentication.

DRIVER=DataDirect 8.0 SAP S4HANA;HostName=host_name;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
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.
proxy_host
specifies the proxy server to use for the first connection.
proxy_password
specifies the password needed to connect to a proxy server for the first connection.
proxy_port

specifies the port number where the proxy server is listening for requests for the first connection. The default is 0.

proxy_user

specifies the user name needed to connect to a proxy server for the first connection.

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.
user_name

specifies the user name that is used to connect to the service. For example, JSMITH.

password

specifies the password used to connect to the 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.
The following example connection string includes the options required for using a proxy server with basic authentication.
For S/4HANA:
DRIVER=DataDirect 8.0 SAP S4HANA;HostName=https://mycompany.s4hana.ondemand.com;
ProxyHost=pserver;ProxyPassword=proxysecret;ProxyPort=808;ProxyUser=admin1;
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;
ProxyHost=pserver;ProxyPassword=proxysecret;ProxyPort=808;ProxyUser=admin1;
ServiceList=API_BUSINESS_PARTNER,API_SALES_ORDER_SRV;User=JSMITH;Password=secret;