SAP Connector

Back Next

SAP BW Reader connection properties

To read data from SAP BW objects, select the

SAP BW Connector

connection type and configure the connection properties.

The following table describes the SAP BW 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	Required. SAP user name with the appropriate user authorization.
Password	Required. SAP password.
Connection type	Required. Type of connection that you want to create. Select one of the following values: 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 use SAP load balancing. Default is Application.
Host name	Required when you create an SAP application connection. Host name or IP address of the SAP BW server that you want to connect to.
System number	Required when you create an SAP application connection. SAP system number.
Message host name	Required when you create an SAP load balancing connection. Host name of the SAP message server.
R3 name/SysID	Required when you create an SAP load balancing connection. SAP system name.
Group	Required when you create an SAP load balancing connection. Group name of the SAP application server.
Client	Required. SAP client number.
Language	Language code that corresponds to the language used in the SAP system.
Trace	Use this option to track the JCo calls that the SAP system makes. Specify one of the following values: 0. Off 1. Full Default is 0. SAP stores information about the JCo calls in a trace file. 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 want to use. Use the following format: <parameter name1>=<value1>, <parameter name2>=<value2>
Port Range	HTTP port range that the Secure Agent must use to read data from the SAP BW server in streaming mode. Enter the minimum and maximum port numbers with a hyphen as the separator. The minimum and maximum port number can range between 10000 and 65535. Default is 10000-65535.
Use HTTPS	Select this option to enable https streaming.
Keystore location	Absolute path to the JKS keystore file.
Keystore password	Password for the .JKS file.
Private key password	Export password specified for the .P12 file.
SAP Additional Parameters	Additional SAP parameters that the Secure Agent uses to connect to the SAP system as an RFC client. Specify the required RFC-specific parameters and connection information to enable communication between Data Integration and SAP. You can specify the Secure Network Communication (SNC) parameters as additional arguments to securely connect to SAP as shown in the following format: 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 the SNC parameters that you can configure in this field, see the How-To Library article, How to Configure the SAP Secure Network Communication Protocol in Informatica Cloud Data Integration. The values of any required connection parameters override SAP additional parameter values that you have entered.

Rename Saved Search

Table of Contents

SAP Connector

SAP Connector

SAP BW Reader connection properties

SAP BW Reader connection properties