SAP BW/4HANA Sources > Before you begin > Create a connection
  

Create a connection

Create an SAP BW/4HANA connection object in Administrator with the connection details of the SAP BW/4HANA source system.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Select the SAP BW and click Next.
    4Enter the connection properties.
    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.
    Use Secret Vault
    Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
    This property appears only if secrets manager is set up for your organization.
    When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
    Note:
    If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
    For information about how to configure and use a secrets manager, see Secrets manager configuration.
    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
    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.
    The following table describes the basic connection properties for an application 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.
    The following table describes the advanced connection properties for an application connection:
    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:
    • - 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 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
    Select this option to enable https streaming.
    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.
    The following table describes the basic connection properties for a load balancing 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.
    The following table describes the advanced connection properties for a load balancing connection:
    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:
    • - 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 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
    Select this option to enable https streaming.
    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.
    5Click Test to test your connection to the source system.
    6Click Save.