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 property | Description |
|---|---|
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. |
Property | Description |
|---|---|
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:
|
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 a 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 connect to SAP through HTTPS, verify that your administrator has configured HTTPS for 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 about SNC parameters, see How to configure the SAP Secure Network Communication protocol Informatica How-To Library article. For more information about RFC-specific parameters, see the SAP documentation. Note: 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. |
Connection property | Description |
|---|---|
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. |
Property | Description |
|---|---|
Message host name | Required. The host name of the SAP message server to which you want to connect when you use a load balancing connection. |
R3 name/SysID | Required. The system ID of the SAP message server to which you want to connect when you use a load balancing connection. |
Group | Required. The name of the SAP logon group through which you want to connect when you use 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:
|
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 a 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 connect to SAP through HTTPS, verify that your administrator has configured HTTPS for 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 about SNC parameters, see How to configure the SAP Secure Network Communication protocol Informatica How-To Library article. For more information about RFC-specific parameters, see the SAP documentation. Note: 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. |