Create a New Workflow

10.2 Create a New Workflow

You can add data flows, workflows, or data loads in a workflow.

To create a new workflow for your project:

On the Home page, click the required Project title.
You are navigated to the Project Details page.
In the left pane, click Workflows.
The Workflow page appears.
On the Workflow page, click Create Workflow.
The Create Workflow page appears.
In the Name field provide a name for the new workflow and click Create.
The new workflow is created and listed in the Workflow page with its Name and Folder details.
Click the Workflow to configure the Workflow Details.
From the left panel drag the data flows, workflows, or data loads that you want to run in the workflow. If you have connected to any other Data Transforms instance, you can also add data loads that you have created in that Data Transforms instance. See Create a Data Transforms Connection for Remote Data Load and Run a Data Load for more information.
Select either the ok (green arrow) icon, the not ok (red arrow) or the ok/not ok (black arrow) in the toolbar.
This defines the mode that subsequent links drawn on the canvas will be set to.
- ok (green) defines the success path.
- not ok (red) defines the failure path.
- ok/not ok (black) defines a path that is followed on success or failure.
Use the Sleep (clock icon) to add a delay in the workflow. Drag the Sleep icon on the canvas and connect it in the flow with either the ok (green), not ok (red) or ok/not ok (black) links. This will add a delay at that point in the flow.
If you wan to add a SQL or PL/SQL query as a step in the workflow, do the following:
- Drag the SQL icon () on the canvas.
- Double click the SQL step in the editor to open the step properties page.
- Select the Attributes tab.
- From the Connection drop-down select the connection you want to run the query on.
  
  Note:
  The drop-down lists only Oracle database connections.
- In the SQL textbox add the query that you want to run.
Select the step and click the Connector icon () next to it to connect it with the next step.
After defining all the required Workflow details,
- Click , to save the created/designed workflow.
- Click , to align the nodes of the designed workflow.
- Click , to execute the created workflow.
- Select a single step in the canvas and click the Execute Step icon (), to execute only the selected data flow or workflow.
  To check the status of the workflow, see the Status panel on the right below the Properties Panel. For details about the Status panel, see Monitor Status of Data Loads, Data Flows, and Workflows. This panel shows the link to the Job ID that you can click to monitor the execution status on the Jobs page. For more information about jobs see Create and Manage Jobs.
- Click , to maximize or minimize the created workflow diagram in the design canvas.
  The newly created workflows get listed in the Project Details page. The following details are displayed:
  - Name of the Workflow
  - Folder corresponding to the workflow - Default Folder
  To view the details of a workflow, click the name of the workflow and you are navigated to the Workflow Details page.
In the left pane, you can search for the required Data Flow or Workflow using the Name filter. In the Name text box, enter the name of the required Data Flow or Workflow.

Select a step in the canvas and check the Properties Panel available at the right side of the design canvas to know the following properties of the selected step in a created Data Flow or Workflow:
- Name
- Linked Object
  
  Note:
  You cannot edit this field.
- Step -
  - First Step - Select the First Step check-box, to execute the selected step as the first step for execution in a Data Flow or Workflow.
    
    Note:
    You can select only a single step as a first step for execution in a Data Flow or Workflow.
- Number of attempts on Failure
- Time between attempts in seconds(s)
- Log steps in journal - Select any of the following options from the drop-down box:
  - Always
  - Never
  - Error

Parent topic: Workflows