SAP BI Destination Editor (Connection Manager Page)

SAP BI Destination Editor (Connection Manager Page)

Use the Connection Manager page of the SAP BI Destination Editor to select the SAP BI connection manager that the SAP BI destination will use. On this page, you also select the parameters for loading the data into the SAP NetWeaver BI system.

To learn more about the SAP BI destination of the Microsoft Connector for SAP BI, see SAP BI Destination.

Dd433149.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 Connection Manager page

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

Dd433149.note(en-us,SQL.100).gifNote:
If you do not know all the values that are required to configure the destination, 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.

Test Load

Perform a test of the loading process that uses the settings that you have selected and loads zero rows.

InfoPackage/InfoSource Options

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

InfoPackage

Enter the name of the InfoPackage.

InfoSource

Enter the name of the InfoSource.

Type

Enter the single-character that identifies the type of the InfoSource. The following table lists the acceptable single-character values.

Value Description

D

Transaction data

M

Master data

T

Texts

H

Hierarchy data

Logical system

Enter the name of the logical system that is associated with the InfoPackage.

Look up

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

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.

Create SAP BI Objects Options

Select object type

Select the type of SAP NetWeaver BI object that you want to create. You can select one of the following types:

  • InfoObject
  • InfoCube
  • InfoSource
  • InfoPackage
Create

Create the selected type of SAP NetWeaver BI object.

Object Type Result

InfoObject

Create a new InfoObject by using the Create InfoObject dialog box. For more information about this dialog box, see Create New InfoObject.

InfoCube

Create a new InfoCube by using the Create InfoCube for Transaction Data dialog box. For more information about this dialog box, see Create InfoCube for Transaction Data.

InfoSource

Create a new InfoSource by using the Create InfoSource dialog box, and then by using the Create InfoSource for Transaction Data or the Create InfoSource for Master Data dialog box. For more information about these dialog boxes, see Create InfoSource, Create InfoSource for Transaction Data and Create InfoSource for Master Data.

InfoPackage

Create a new InfoPackage by using the Create InfoPackage dialog box. For more information about this dialog box, see Create InfoPackage.

Show:
© 2016 Microsoft