Creating a PowerCenter Workflow for an SAP BI Session
Creating a PowerCenter Workflow for an SAP BI Session
After you configure an SAP BI session, create a PowerCenter workflow to execute the session. The following restrictions apply to workflows containing sessions that load SAP BI targets:
The workflow name in the repository must match the workflow name in the InfoPackage.
When you create the InfoPackage, you include the workflow name. The PowerCenter Integration Service validates the workflow name in the repository and the workflow name in the InfoPackage. These names must match exactly, including case.
Configure the workflow to run on demand.
You can configure the schedule when you create the InfoPackage in SAP BI. You cannot schedule a PowerCenter workflow to load data into SAP BI.
In the Workflow Designer, click
Workflows
Create
.
In the workflow properties, accept the default workflow name or rename the workflow.
Make sure the workflow name in the workflow properties matches both the workflow name in the InfoPackage and the SAP BI session name.
Select the PowerCenter Integration Service name you configured in the SAP BW Service properties.
The PowerCenter Integration Service runs the workflow and uses the session to load data into SAP BI.
To prepare the workflow for recovery, click
Suspend on Error
.
On the
Scheduler
tab of the workflow properties, click the right side of the
Scheduler
field to edit scheduling settings for the scheduler.
The
Edit Scheduler
dialog box appears.
Click the
Schedule
tab.
Select
Run on Demand
for
Run Options
.
Click
OK
to exit the scheduler.
Click
OK
to exit the workflow properties.
Add the session you created to the workflow.
You can only include one session in the workflow. Ensure that the session name is identical to the workflow name.