SAP BW Connector > Connections for SAP BW Connector > Connect to SAP BW

Connect to SAP BW

Let's configure the SAP BW Connector connection properties to connect to SAP BW.

Before you begin

Before you get started, you'll need to configure the Secure Agent machine and SAP system to establish an SAP BW connection.

Check out Prerequisites to learn more about these tasks.

Connection details

The following table describes the basic connection properties:

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	SAP BW Connector
Runtime Environment	The name of the runtime environment where you want to run tasks. Select a Secure Agent.
Username	The user name with the appropriate user authorization to connect to the SAP BW account.
Password	The password to connect to the SAP BW account.
Connection type	Type of connection that you want to create when you read SAP BW data. Select one of the following connection types from the list: - Application. Create an application connection when you want to connect to a specific SAP BW server. - Load balancing. Create a load balancing connection when you want to connect to the SAP BW server with the least load at run time. If you select the Load balancing option, you need to enter values in the dedicated connection fields along with the Message host name, R3 name/SysID, and Group fields in the Advanced Settings section. Default is Application.
Host name	The host name or IP address of the SAP BW server to which you want to connect.
System number	The system number of the SAP BW server. Get the required system number from the SAP system to which you want to connect.
Client	The client number of the SAP BW server. Get the required client number from the SAP system to which you want to connect.
Language	Language code that corresponds to the SAP language. Get the required language code from the SAP system to which you want to connect.

Advanced settings

The following table describes the advanced connection properties:

Property	Description
Message host name	The host name of the SAP message server. This property is required only when you create a load balancing connection.
R3 name/SysID	The system ID of the SAP message Server. This property is required only when you create a load balancing connection.
Group	The name of the SAP logon group through which you want to connect. This property is required only when you create a load balancing connection.
Trace	Determines whether to track the JCo calls that the SAP system makes. Enter one of the values between 0 and 8. By default, SAP doesn't store information about the JCo calls in a trace file. Default is 0. For more information about trace level values, see Setting up an SAP Java Connector (SAP JCo) and Related Traces. You can access the trace files from the following directories: - Design time information: <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\<Latest version>\ICS\main\tomcat - Run-time information: <Informatica Secure Agent installation directory>\apps\Data_Integration_Server\<Latest version>\ICS\main\bin\rdtm
Additional parameters	Additional JCo connection parameters that you can use when you read SAP BW data. You can enter multiple JCo connection parameters, separated by semicolon, in the following format: <parameter name1>=<value1>;<parameter name2>=<value2>;<parameter name3>=<value3>.... For example, if you want to create an SAP SNC connection, enter the following additional parameters: SNC_MODE=1;SNC_QOP=3;SNC_MYNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>, C=<Country>;SNC_PARTNERNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>, C=<Country>;SNC_LIB=C:\SNC_11\sapcrypto.dll;TRACE=1
Port Range	HTTP port range. The SAP BW connection uses the specified port numbers to connect to SAP BW using the HTTP protocol. Default range is 10000-65535. Enter a range in the default range, for example, 10000-20000. When a range is outside the default range, the connection uses the default range.
Use HTTPS	Connects to SAP through HTTPS protocol. To successfully connect to SAP through HTTPS, verify that your administrator has configured the Secure Agent machine and the SAP system. For more information about how to connect to SAP through HTTPS, see Configure HTTPS to connect to SAP.
Keystore location	The path and file name of the keystore file to connect to SAP. Enter both the path and file name in the following format: <Directory>/<Keystore file name>.jks
Keystore password	The password to access the keystore file.
Private Key password	The export password to access the .P12 file.
SAP Additional Parameters	Additional SAP properties that the Secure Agent uses to connect to the SAP system as an RFC client. Specify the required RFC-specific parameters and connection information that enable the Secure Agent to connect to SAP. For example, you can specify the SNC connection parameters as additional arguments listed in the following sample: MSHOST= <Message server hostname> GROUP=PUBLIC R3NAME=SLT SNC_MODE=1 SNC_QOP=3 SNC_MYNAME=p:CN=<Common name>, OU=<Organizational unit>, O=<Organization>, C=<Country> This is the SNC name of the Secure Agent machine. SNC_PARTNERNAME=p:CN=<Common name>, OU=<Organizational unit>, OU=SAP Web AS, O=<Organization>, C=<Country>. This is the SNC name of the SAP system. SNC_LIB =<Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/<libsapcrypto.so for Linux/sapcrypto.dll for Windows> X509CERT=<X509 certificate> For more information, see How to configure the SAP Secure Network Communication protocol Informatica How-To Library article. If you specify a parameter in both the SAP Additional Parameters and Additional parameters fields, the value specified in the SAP Additional Parameters field takes precedence. For more information about RFC-specific parameters, see the SAP documentation.