SAP BW Sources > Before you begin > Create a connection
  

Create a connection

Before you configure the SAP BW catalog source, create a connection object in Administrator.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Search for and select SAP BW Connector and then click Next.
    4Enter the 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.
    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. Choose to connect using the Application connection type.
    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.
    The following table describes the advanced connection properties:
    Property
    Description
    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.
    Note:
    The
    SAP BW
    catalog source supports only Secure Network Communication (SNC). You can configure SNC with an X.509 certificate or with a user name and password.
    5Click Test to test your connection to the source system.
    6Click Save.