SAP BI Source Editor (Connection Manager Page)

Use the Connection Manager page of the SAP BI Source Editor to select the SAP BI connection manager for the SAP BI source. On this page, you also select the execution mode and the parameters for extracting the data from the SAP NetWeaver BI system.

To learn more about the SAP BI source component of the Microsoft Connector for SAP BI, see SAP BI Source.

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

Dd433139.note(en-us,SQL.100).gifImportant:
Extracting data from SAP NetWeaver BI requires additional SAP licensing. Check with SAP to verify these requirements.

To open the Connection Manager page

  1. In Business Intelligence Development Studio, open the Integration Services package that contains the SAP BI source.
  2. On the Data Flow tab, double-click the SAP BI source.
  3. In the SAP BI Source Editor, click Connection Manager to open the Connection Manager page of the editor.

Dd433139.note(en-us,SQL.100).gifNote:
If you do not know all the values that are required to configure the source, you might have to ask your SAP administrator.

SAP BI connection manager

Select an existing connection manager from the list, or create a new connection by clicking New.

New

Create a new connection manager by using the SAP BI Connection Manager dialog box.

For more information about this dialog box, see SAP BI Connection Manager Editor.

OHS destination

Select the Open Hub Service (OHS) destination to use to extract data from the source.

Execution mode

Specify the method for extracting data from the source.

Option Description

P - Trigger Process Chain

Trigger a process chain. In this case, the Integration Services package starts the extraction process.

W - Wait for Notify

Wait for notification from the SAP NetWeaver BI system to begin extracting the data. In this case, the SAP NetWeaver BI system starts the extraction process.

E - Extract Only

Retrieve the data that is associated with a particular Request ID. In this case, the SAP NetWeaver BI system has already extracted the data into an internal table, and the Integration Services package just reads the data.

Preview

Open the Preview dialog box in which you can preview results. For more information, see Preview (SAP BI Source Editor).

Dd433139.note(en-us,SQL.100).gifImportant:
The Preview option, that is available on the Connection Manager page of the SAP BI Source Editor, actually extracts data. If you have configured SAP NetWeaver BI to extract only data that has changed since the previous extraction, selecting Preview will exclude the previewed data from the next extraction.

When you click Preview, you also open the Request Log dialog box. You can use this dialog box to view the events that are logged during the request that is made to the SAP NetWeaver BI system for sample data. For more information, see Request Log (SAP BI Source Editor).

Dd433139.note(en-us,SQL.100).gifNote:
If you do not know all the values that are required to configure the source, you might have to ask your SAP administrator.

Execution Mode = P - Trigger Process Chain

RFC Destination Options

You do not have to know and enter these values in advance. Use the Look up button to find and select the appropriate RFC destination. After you select an RFC destination, the component enters the appropriate values for these options.

Gateway host

Enter the server name or IP address of the gateway host. Usually, the name or IP address is the same as the SAP application server.

Gateway service

Enter the name of the gateway service, in the format sapgwNN, where NN is the system number.

Program ID

Enter the Program ID that is associated with the RFC destination.

Look up

Look up the RFC destination by using the Look Up RFC Destination dialog box. For more information about this dialog box, see Look Up RFC Destination.

Process Chain Options

You do not have to know and enter these values in advance. Use the Look up button to find and select the appropriate process chain. After you select a process chain, the component enters the appropriate value for the option.

Process chain

Enter the name of the process chain to be triggered by the source.

Look up

Look up the process chain by using the Look Up Process Chain dialog box. For more information about this dialog box, see Look Up Process Chain.

Execution Mode = W - Wait for Notify

RFC Destination Options

You do not have to know and enter these values in advance. Use the Look up button to find and select the appropriate RFC destination. After you select an RFC destination, the component enters the appropriate values for the options.

Gateway host

Enter the server name or IP address of the gateway host. Usually, the name or IP address is the same as the SAP application server.

Gateway service

Enter the name of the gateway service, in the format sapgwNN, where NN is the system number.

Program ID

Enter the Program ID that is associated with the RFC destination.

Look up

Look up the RFC destination by using the Look Up RFC Destination dialog box. For more information about this dialog box, see Look Up RFC Destination.

Execution Mode = E - Extract Only

Request ID

Enter the Request ID that is associated with the extraction.

Show: