Installation and Configuration Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Import the Operational Data Store Event Loader Workflow to PowerCenter

This section applies only if you use the Dashboard using operational data store.

Import the operational data store (ODS) event loader workflow to load event information from the

Data Integration Hub

repository to the

Data Integration Hub

ODS.

If you use an existing workflow with the name DX_ETL, rename the existing workflow in PowerCenter Repository Manager before you import the ODS event loader workflow, or import the workflow to a different folder.

After you import the ODS event loader workflow, do not run the workflow manually. The workflow must start at the scheduled time. If you start the workflow manually it might fail to store aggregated events in the

Data Integration Hub

ODS.

In the PowerCenter Workflow Manager, select

Connections

Relational

Add the

DX_REPO

connection for the

Data Integration Hub

repository.

Add the

DX_ODS

connection for the

Data Integration Hub

ODS.

In the PowerCenter Repository Manager, import the

Data Integration Hub

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

Database Type	Workflow Location and Name
Oracle	< DIH InstallationDir>\powercenter\ETL\DX_ETL.xml
Microsoft SQL Server	< DIH InstallationDir>\powercenter\ETL\DX_ETL_SQLSERVER.xml

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

Data Integration Hub

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.

Do not change the variable after the first time the workflow runs.

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

The

Assign Integration Service

dialog box appears.

Select the

DX_ETL

check box and then click

Assign

PowerCenter assigns the Data Integration Service to the ODS event loader workflow.

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Import the Operational Data Store Event Loader Workflow to PowerCenter

Import the Operational Data Store Event Loader Workflow to PowerCenter