PowerCenter - Workflows

1 - About

A workflow is a set of instructions that tells the integration service how to execute tasks, such as :

  • email notifications,
  • decisions,
  • timers,
  • pre-session SQL commands,
  • post-session SQL commands,
  • and shell commands.

The tasks are connected by workflow link.

You create a workflow for each session you want the integration service to run.

You can group session (in parallel or sequentially) in a workflow to :

  • improve performance,
  • or to ensure that targets load in a set order.

The integration service uses the instructions configured in the workflow to run sessions and other tasks.

You create and maintain tasks and workflows in the Workflow Manager.

3 - Components

PowerCenter Workflows is composed of two components :

In the Workflow Manager, you define a set of instructions to execute tasks, such as sessions, emails, and shell commands. This set of instructions is called a workflow.

When the PowerCenter - Integration Service runs workflows, you can monitor workflow progress in the Workflow Monitor. You can view details about a workflow or task in either a Gantt Chart view or a Task view. You can start, stop, and abort workflows from the Workflow Monitor. The Workflow Monitor displays workflows that have run at least once.

4 - Parallel or sequentially

By default, when you link both sessions directly to the Start task in the workflow manager, the integration service runs both sessions at the same time when you run the workflow. If you want the Integration Service to run the sessions one after the other, connect the Start task to one session, and connect that session to the other session.

5 - Manage Workflow

5.1 - Creating a Workflow

In PowerCenter - Workflow Manager, to create a workflow:

  • Click Tools > Workflow Designer.
  • Click Workflows > Create to create a new workflow.

When you have a workflow already open, the Workflow Manager prompts you to close the current workflow. Click Yes to close any current workflow. The workflow properties appear.

  • Name the workflow wf_WorkflowName.
  • Click the Browse Integration Service button to select an PowerCenter - Integration Service to run the workflow. The Integration Service Browser dialog box appears.
  • Select an Integration Service and click OK.

5.2 - Start a workflow

  • Right-click the Start task in the workspace and select Start Workflow from Task.
  • Or right-click the workflow in the Navigator and select Start Workflow.

The PowerCenter - Workflow Monitor opens and connects to the PowerCenter - Repository.

5.3 - Scheduled

By default, the workflow is scheduled to run on demand. The Integration Service only runs the workflow when you manually start the workflow. You can configure workflows to run on a schedule. For example, you can schedule a workflow to run once a day or run on the last day of the month.

  • Menu Workflows > Edit > Scheduler

6 - Documentation

  • Documentation: PC_861_WorkflowBasicsGuide.pdf, PC_861_AdvWorkflowGuide.pdf
dit/powercenter/workflow.txt · Last modified: 2017/10/27 15:54 by gerardnico