Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Workflows Overview

Workflows Overview

A workflow is a set of instructions that tells the Integration Service how to run tasks such as sessions, email notifications, and shell commands. After you create tasks in the Task Developer and Workflow Designer, you connect the tasks with links to create a workflow.
In the Workflow Designer, you can specify conditional links and use workflow variables to create branches in the workflow. The Workflow Manager also provides Event-Wait and Event-Raise tasks to control the sequence of task execution in the workflow. You can also create worklets and nest them inside the workflow.
Every workflow contains a Start task, which represents the beginning of the workflow.
The following figure shows a sample workflow:
The sample workflow contains a Start task, a Session task, a Command task, and a Stop task.
You can create workflows with branches to run tasks concurrently.
When you create a workflow, select an Integration Service to run the workflow. You can start the workflow using the Workflow Manager, Workflow Monitor, or
pmcmd
.
Use the Workflow Monitor to see the progress of a workflow during its run. The Workflow Monitor can also show the history of a workflow.
Use the following guidelines when you develop a workflow:
  1. Create a workflow.
    Create a workflow in the Workflow Designer or by using the Workflow Generation Wizard in the PowerCenter Designer.
  2. Add tasks to the workflow.
    You might have already created tasks in the Task Developer. Or, you can add tasks to the workflow as you develop the workflow in the Workflow Designer.
  3. Connect tasks with links.
    After you add tasks to the workflow, connect them with links to specify the order of execution in the workflow.
  4. Specify conditions for each link.
    You can specify conditions on the links to create branches and dependencies.
  5. Validate workflow.
    Validate the workflow in the Workflow Designer to identify errors.
  6. Save workflow.
    When you save the workflow, the Workflow Manager validates the workflow and updates the repository.
  7. Run workflow.
    In the workflow properties, select an Integration Service to run the workflow. Run the workflow from the Workflow Manager, Workflow Monitor, or
    pmcmd
    . You can monitor the workflow in the Workflow Monitor.