• Article

SAP BI Connection Manager Editor

Use the SAP BI Connection Manager Editor to specify the properties to use to connect to an SAP NetWeaver BI version 7 system.

The SAP BI connection manager provides connectivity to an SAP NetWeaver BI 7 system for use by the SAP BI source or destination. To learn more about the SAP BI connection manager of the Microsoft Connector for SAP BI, see SAP BI Connection Manager.

Important

The documentation for the Microsoft Connector for SAP BI assumes familiarity with the SAP NetWeaver BI environment. For more information about SAP NetWeaver BI, or for information about how to configure SAP NetWeaver BI objects and processes, see your SAP documentation.

To open the SAP BI Connection Manager Editor

  1. In Business Intelligence Development Studio, open the Integration Services package that contains the SAP BI connection manager.
  2. In the Connection Managers area on the Control Flow tab, do one of the following steps:
    • Double-click the SAP BI connection manager.
      —or—
    • Right-click the SAP BI connection manager, and then select Edit.

Options

Note

If you do not know all the values that are required to configure the connection manager, you might have to ask your SAP administrator.

  • Client
    Specify the client number of the system.
  • Language
    Specify the language that the system uses. For example, specify EN for English.
  • User name
    Specify the user name that will be used to connect to the system.
  • Password
    Specify the password that will be used with the user name.

  • Use single application server
    Connect to a single application server.

    To connect to a group of load-balanced servers, use the Use load balancing option instead.

  • Host
    If connecting to a single application server, specify the host name.

    Note

    This option is only available if you have selected the Use single application server option.

  • System number
    If connecting to a single application server, specify the system number.

    Note

    This option is only available if you have selected the Use single application server option.

  • Use load balancing
    Connect to a group of load-balanced servers.

    To connect to a single application server, use the Use single application server option instead.

  • Message server
    If connecting to a group of load-balanced servers, specify the name of the message server.

    Note

    This option is only available if you have selected the Use load balancing option.

  • Group
    If connecting to a group of load-balanced servers, specify the name of the server group name.

    Note

    This option is only available if you have selected the Use load balancing option.

  • SID
    If connecting to a group of load-balanced servers, specify the System ID for the connection.

    Note

    This option is only available if you have selected the Use load balancing option.

  • Log directory
    Enable logging for the components of the Microsoft Connector for SAP BI.

    To enable logging, specify a directory for the log files that are created before and after each RFC function call. (This logging feature can create many small log files in XML format.)

    To specify the log directory, you can either enter the directory path manually, or click Browse and browse to the log directory.

    If you do not select a log directory, logging is not enabled.

  • Browse
    Browse to select a folder for the log directory.
  • Test Connection
    Test the connection using the values that you have provided. After clicking Test Connection, a message box appears and indicates whether the connection succeeded or failed.