10.3 Define a Data Studio Data Load in a Work Flow

You can add a Data Studio Data Load as a step in a workflow and run the data load at scheduled intervals.

To do this, you need to create a connection, import data entities, create a data flow and then schedule the data load run.
To define and run a Data Studio Data Load within a workflow:
  1. On the Home page, click the required Project title.

    You are navigated to the Project Details page.

  2. In the left pane, click Workflows.

    The Workflow page appears.

  3. On the Workflow page, click Create Workflow.

    The Create Workflow page appears.

  4. 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 Actions icon (Actions icon) next to the workflow to edit, rename, copy, change folder, start, export, or delete it.

  5. Click the Workflow to configure the Workflow Details.
  6. To add a Data Studio Data Load as a step in the workflow, drag the Data Studio Load icon (
    Data Studio Load icon

    ) on the canvas.
  7. Double click the Data Studio Load step in the editor to open the step properties page.
  8. Select the Attributes tab.
  9. From the Connection drop-down select the connection you want to load the data from.

    Note:

    The drop-down lists only Oracle database connections.
  10. Select a Data Studio Load from the drop down.
  11. Click save icon, to save the created/designed workflow.
  12. Click execute icon, to execute the created workflow.
  13. 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.

    The newly created workflows get listed in the Project Details page.