Informatic Workflow

You can monitor the workflow status for a job in the Workflow Monitor. 

Workflow Monitor

After you create a workflow, you run the workflow in the Workflow Manager and monitor it in the Workflow Monitor. The Workflow Monitor is a tool that displays details about workflow runs in two views, Gantt chart view and Task view. You can monitor workflows in online and offline modes.

The Workflow Monitor consists of the following windows:

• Navigator window. Displays monitored repositories, servers, and repositories objects.
• Output window. Displays messages from the Power Center Server.
• Time window. Displays progress of workflow runs.
• Gantt Chart view. Displays details about workflow runs in chronological format.
• Task view. Displays details about workflow runs in a report format.

Workflow Manager

The Workflow Manager consists of three tools to help you develop a workflow:

• Task Developer. Create tasks you want to accomplish in the workflow in the Task Developer.
• Workflow Designer. Create a workflow by connecting tasks with links in the Workflow Designer. You can also create tasks in the Workflow Designer as you develop the workflow.
• Worklet Designer. Create a worklet in the Worklet Designer. A worklet is an object that groups a set of tasks. A worklet is similar to a workflow, but without scheduling information. You can nest multiple worklets inside a workflow.

Before you create a workflow, you must configure the following connection information:

• PowerCenter Server connection. Register the PowerCenter Server with the repository before you can start it or create a session to run against it.
• Database connections. Create connections to source and target systems.

• Other connections. If you want to use external loaders or FTP, you configure these connections in the Workflow Manager. 

Loading Data:

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.

After you create a workflow in the Workflow Designer, the next step is to add tasks to the workflow. The Workflow Manager includes tasks, such as the Session task, the Command task, and the Email task so you can design your workflow. The Session task is based on a mapping you build in the Designer.

You then connect tasks with links to specify the order of execution for the tasks you created. Use conditional links and workflow variables to create branches in the workflow.

When the workflow start time arrives, the PowerCenter Server retrieves the metadata from the repository to execute the tasks in the workflow.

  

Workflow Manager Windows

The Workflow Manager displays the following windows to help you create and organize workflows:

• Navigator. Allows you to connect to and work in multiple repositories and folders.
• Workspace. Allows you to create, edit, and view tasks, workflows, and worklets.
• Output. Displays messages from the PowerCenter Server and the Repository Server. The Output window also displays messages when you save or validate tasks and workflows.
• Overview. An optional window that makes it easier to view workbooks containing large workflows. Outlines the visible area in the workspace and highlights selected objects in color. Choose View-Overview Window to display this window.