- 13 Jun 2023
- Print
- DarkLight
- PDF
Editing a Flow
- Updated on 13 Jun 2023
- Print
- DarkLight
- PDF
Overview
This page explains how to set up a Workflow in trocco.
Defining a Flow
First, you must create a Flow for your Workflow configuration.
Setting up a Flow makes it easy to set dependencies for your ETL, and Data Mart Jobs.
In this tutorial, we will set up a Flow as follows:
- Execute ETL Jobs 1 and 2 concurrently
- After the ETL Jobs are complete, refresh our Tableau tables by running a Tableau Data Extraction
1. Add the ETL Job to the Flow
Follow the steps below to add an ETL Job to the Flow:
Under the Add Task panel, click trocco ETL Job
From the Add Task popup window, select your ETL Job, and click Add
2. Set up concurrency for the ETL Jobs
Follow the steps below to set up your jobs to run concurrently:
Add ETL Job 2 by following the same steps as above
Click the > symbol, then connect the arrow between 1 and 2 as shown below.
3. Add a Tableau Data Extraction Job
Follow the steps below to add a Tableau Extraction Job to the flow:
Under the Add Task panel, click Tableau Extraction Job
In the Add New Task popup window, enter the required fields and click Add.
For more information on setting up your Tableau Connection Configuration, see here.
Link your newly added Tableau job with the two ETL jobs created in the previous step.
You can set up your Flow to execute the Tableau job after the concurrent execution of your two ETL jobs completes, by linking the jobs as shown below:
4. Save the Flow
- Click Save in the upper right corner of the page.
After successful saving, you will be redirected to the Workflow details page.