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=hostname;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
ServiceList=service[,service[,...]];User=user_name;Password=password;[attribute=value[;...]];
where:
hostname
specifies the base URL of the SAP S/4HANA instance to which you want to issue requests. For example,https://mycompany.s4hana.ondemand.com.
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 SAP S/4HANA instance. For example, JSMITH.
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.
The following example connection string includes the options required for using a proxy server with basic authentication.
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;
