Combine ETL jobs with Workflow process

Learn to use ETL with workflow process steps

Last published at: November 3rd, 2026

Use the following process steps for ETL workflows.  

  • clsExecuteETLJob - run ETL job
  • clsExecuteETLValidationJob - run ETL validation job
  • clsGetETLJobStatus - get ETL job status

In this example, let's combine a workflow with ETL jobs. Drag and drop the process definition XML from the GitHub link at the bottom of this page. 

Navigate to the Process > Definition page. Click Actions > Create. Enter a new name for the definition, then click Create, as shown below. 

 

Drag and connect the workflow steps (clsExecuteETLValidationJob, placeHolders) as below. 

 

Double-click the clsExecuteETLValidationJob step to configure the “Required” properties. Provide a step name. Select the ETL definition (existing) from the drop-down list. Click the Save button. 

 

Double-click the clsExecuteETLValidationJob step to configure the “Optional” properties. Provide a variable/global reference to store the ETL Instance ID during execution. 

 

Select the connection line to configure the properties as shown below. Use different line colors to help you understand the design quickly. 

 

Navigate to the ETL > Definition page. Click Actions > Create. Enter a new name for the definition, then click Create, as shown below. 

 

Drag and connect the workflow steps (csvInputFile, csvOutputFile, csvErrorFile, validateData) as below. 

 

Configure csvInputFile and csvOutputFile with the input and output file paths. Click the validateData step to configure the expression as shown in the example below. 

 

Navigate to the Process Designer page. Click Actions > Create Instance. Enter the Instance Name, then click “Generate”. The new process instance is created and executed. Click the link to render the instance on the new page.  

 

The process instance is displayed on the new page. The sample workflow process has completed the ETL job as configured. 

 

You can also watch the YouTube video included here. 

 

Definition Sample:

Download the sample definition(s) from the link here and later import it (drag-and-drop) to your FlowWright ETL Process Definition (XML file) page.

Note: After import, verify and complete any missing configurations, including file path references and database connections. Then save the definition to confirm the changes.

Click here to download the sample file.