• Article

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.

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.

Important

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.

Static Options

Note

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

    Important

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

Execution Mode Dynamic Options

Note

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.