PowerExchange for SAP NetWeaver User Guide for PowerCenter

10.5.8
- 10.5.9
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating an SAP BI Session

After you create an application connection, create a session. Because SAP BI only supports inserts from PowerCenter, configure sessions to load data to SAP BI targets as insert only.

In the Task Developer, click

Tasks

Create

Select

Session

for the task type.

Enter a name for the task.

In the

Mappings

dialog box, select the mapping that you want to use in the session and click

Done

Double-click the SAP BI session to open the session properties.

Click the

Properties

tab.

In the general options settings, select

Insert

for the

Treat Source Rows As

property.

To configure sessions for workflow recovery, set the recovery strategy to resume from the last checkpoint.

Click the

Config Object

tab.

In the advanced settings, set the default buffer block size.

For optimum performance, set the default buffer block size to 5 MB to 10 MB. You can also create a reusable session configuration object with the default buffer block size set to 5 MB to 10 MB.

Click the

Mapping

tab.

Click the

Targets

node and select the connection defined for the SAP BI server.

Set the value of the packet size.

This property determines the size of the packet that the PowerCenter Integration Service sends to SAP BI. The default is 10 MB. The value of the packet size must be equal to or less than the following values:

Packet size configuration in SAP BI.
By default, SAP BI allows packets of 10 MB. The SAP BI administrator can change this packet size configuration.

Available memory on the node where the PowerCenter Integration Service process runs.
When the PowerCenter Integration Service processes an SAP BI session, it stores data in memory until the size equals the value of the packet size. The PowerCenter Integration Service then loads the data to SAP BI as a packet.

Rename Saved Search

Table of Contents

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Creating an SAP BI Session

Creating an SAP BI Session