In the PowerCenter Workflow Manager, select

Connections

Relational

.

Add the

DX_REPO

connection for the

B2B Data Exchange

repository.

Add the

DX_ODS

connection for the

B2B Data Exchange

ODS.

In the PowerCenter Repository Manager, import the

B2B Data Exchange

ODS workflow file. The name of the workflow file depends on type of database on which the ODS is installed.

In the PowerCenter Workflow Manager, connect to the PowerCenter repository.

If

B2B Data Exchange

was previously installed at your site, and you want to exclude old events from the dashboard reports, instruct the workflow to load only events that finished processing after a specific date and time. Click

Workflow

Edit

Variables

and change the value of the

$$WF_Last_Load_End_Time

variable.

By default, the workflow runs every 15 minutes. You can schedule the workflow start time.

Right-click the PowerCenter Integration Service that you want to assign to the ODS event loader workflow and select

Assign to Workflows

.

Select the

DX_ETL

check box and then click

Assign

.