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.

Dd433136.note(en-us,SQL.100).gifImportant:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Dd433136.note(en-us,SQL.100).gifNote:
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.

Show: