Export (0) Print
Expand All

SAP BI Connection Manager

SQL Server 2008

The SAP BI connection manager is the connection manager component of the Microsoft Connector for SAP BI. Thus, the SAP BI connection manager provides the connectivity to an SAP NetWeaver BI version 7 system that the source and destination components of the Microsoft Connector for SAP BI need. (The SAP BI source and destination that are part of the Microsoft Connector for SAP BI package are the only Integration Services components that use the SAP BI connection manager.)

Dd433132.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.

When you add an SAP BI connection manager to a package, the ConnectionManagerType property of the connection manager is set to SAPBI.

You can configure the SAP BI connection manager in the following ways:

  • Provide the client, user name, password, and language for the connection.
  • Choose whether to connect to a single application server or to a group of load-balanced servers.
  • Provide the host and system number for a single application server, or provide the message server, group, and SID for a group of load-balanced servers.
  • Enable custom logging of RFC function calls for the components of the Microsoft Connector for SAP BI. (This logging is separate from the optional logging that you can enable on Integration Services packages.) To enable logging of RFC function calls, you specify a directory in which to store 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.) If you do not select a log directory, logging is not enabled.
  • Use the values that you have entered to test the connection.

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

For a walkthrough that demonstrates how to configure and use the SAP BI connection manager, source, and destination, see the white paper, Using SQL Server 2008 Integration Services with SAP BI 7.0. This white paper also shows how to configure the required objects in SAP BI.

Using the SSIS Designer to Configure the Source

For more information about the properties of the SAP BI connection manager that you can set in SSIS Designer, click the following topic:

Show:
© 2014 Microsoft