Connections > SAP BW BEx Query connection properties
  

SAP BW BEx Query connection properties

To read data from SAP BEx queries, select the SAP BW BEx Query connection type and configure the connection properties.
The following table describes the SAP BW BEx Query connection properties:
Connection property
Description
Runtime Environment
Name of the runtime environment where you want to run tasks.
Select a Secure Agent or serverless runtime environment.
Authentication
Required. Authentication method for the connection.
Select SAP.
Username
Required. SAP user name with the appropriate user authorization.
Password
Required. SAP password.
Connection type
Required. Type of connection that you want to create.
To read data from SAP BEx queries, you must select the Application connection type. Use the application connection type to connect to a specific SAP BW server.
Default is Application.
Host name
Required. Host name or IP address of the SAP BW server that you want to connect to.
System number
Required. SAP system number.
Client
Required. SAP client number.
Language
Language code that corresponds to the language used in the SAP system.
SAP Additional Parameters
Additional SAP parameters that the Secure Agent uses to connect to the SAP system as an RFC client.
You can specify the required RFC-specific parameters and connection information to enable communication between Data Integration and SAP.
For example, you can specify the SNC connection parameters as additional arguments to connect to SAP:
GROUP=interfaces
ASHOST=<Application server hostname>
SYSNR=20
SNC_MODE=1
SNC_PARTNERNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>
SNC_MYNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>
SNC_LIB=<Secure Agent installation directory>/apps/server/bin/libsapcrypto.so
X509CERT=<X509 certificate>
TRACE=2
Note: If you have specified the mandatory connection parameters in the connection, those values override the additional parameter arguments.
Note: You can ignore the other connection properties because they are not relevant for SAP BW BEx Query Connector.