This feature generates instances of ETL definitions and executes them
Navigate to the ETL > Instances menu option.
The ETL page is rendered using the existing instances, as shown in the example below.
Create ETL Instance.
Use one of these 2 methods to create an ETL Instance.
On the ETL designer page, select Actions > Create to start.
Enter an instance name or click the “Generate” button to create a unique name. Provide values for variables or globals (optional). Select the “Execute” checkbox to run the instance after creation. Click the “Create and Execute” button. The ETL instance is generated in the background, and a notification appears in the top-right corner. Click the “View Instance” hyperlink to view the instance.
The ETL Instance appears on the new page, as shown in the example below. The instance status is displayed at the top. Note: All dates and times are stored in the database as UTC and displayed in the user's local time zone. Engine runtime data is in ISO + UTC format.
Create a new instance on the ETL Instance page. Select the Actions - Create menu option.
A configuration popup window is displayed. Select the ETL Definition from the drop-down list. Use the button filters to sort the definition list by last modified date or by name. Click the Generate button to create an instance name, or enter it manually. Enable the Execute checkbox, then click the Create and Execute button to start execution.
The ETL Instance is created, and a confirmation message appears in the top-right corner.
Select the View - Render menu option to view the instance.
The ETL Instance is displayed on the new page as shown below. Use the Search text box to locate any ETL process step.
Remove ETL Instance.
This function removes an ETL Instance permanently.
On the ETL Instances page, select an instance from the table and click the Actions > Remove menu option.
Click OK to confirm.
The instance is removed, and a confirmation message appears in the top-right corner.
ETL Favorites.
This function marks an ETL Instance as a favorite and moves it to the favorite folder.
On the ETL Instances page, select the instance from the table and click on the Actions-Favorite-Add menu option.
The ETL Instance is marked and moved to the Favorites folder, and a confirmation message appears in the top-right corner.
The instance in the Favorites folder appears as shown below.
In the Favorites folder, select the ETL Instance, then click Actions > Favorites > Remove.
The ETL Instance is removed from Favorites and moved back to the All folder, and a confirmation message appears in the top-right corner.
Execute - Selected.
This function executes a selected ETL Instance that has not yet started.
Let's generate a new ETL Instance and not execute it.
On the ETL Instance page, select the Actions > Create menu option. A configuration pop-up window opens. Select the ETL Definition from the drop-down list. Use the button filters to sort the definition list by last modified date or by name. Click the Generate button to create an instance name, or enter the instance name manually. Uncheck the Execute checkbox. Click the Create and Execute button to start execution.
The ETL Instance has been generated but has not yet been started.
Select this ETL Instance, then click the Execute - Selected menu option.
Click OK to confirm.
The ETL instance is running and shows a processing status as shown below.
Execute - With Params.
This function executes a selected ETL Instance with parameter values input by the user.
Let's generate a new ETL Instance and not execute it.
On the ETL Instance page, select the Actions—Create menu option. A configuration popup window opens. Select the ETL Definition from the drop-down list. Use the button filters to sort the definition list by last modified date or by name. Click the Generate button to create an instance name, or enter the instance name manually. Uncheck the Execute checkbox. Click the Create and Execute button to initiate execution. The ETL Instance has been generated but has not yet started.
Select this ETL Instance, then click the Execute - With Params menu option.
The variables are displayed on the new page. You may provide the variable values (parameters) by clicking the Execute button.
The ETL Instance is executed with the input parameters (variable values) listed below.
Execute - Run Engine.
This function executes a selected ETL Instance when FlowWright Engines are in Auto Off mode.
The “Run Engine” option is disabled when the Engines are in Auto mode.
Export - XML.
This function downloads the ETL Instance as an XML file.
On the ETL Instances page, select the definition from the table list, then click the Export—XML menu option. The XML file is generated and downloaded to the local folder.
Export - ETL XML.
This function downloads the ETL Instance as an XML file.
On the ETL Instances page, select the definition from the table list, then click Export > XML. The system generates and downloads the XML file to the local folder.
Export - PNG.
This function downloads the ETL Instance as a PNG.
On the ETL Instances page, select the definition from the table list, then click the Export—PNG menu option. The PNG file is generated and downloaded to the local folder.
The PNG file is included below for reference.
View - Render.
This function renders the ETL instance, helping us visualize the execution workflow.
On the ETL Instances page, select the instance in the table, then click the View-Render menu option.
The ETL Instance is displayed on the new page. You notice the instance's creation and modification information.
You may use the Search text box to find a process step, then click the hyperlink to navigate to that step on the execution image.
View - History.
This function displays the event history for the selected ETL instance.
On the ETL Instances page, select the instance in the table, then click the View-History menu option.
The event's history is displayed on the new page as shown below.
View - Permissions.
This function displays the permissions granted for the ETL Definition to an individual user or an App user (group).
On the ETL Instances page, select the instance in the table and click the View-Permission menu option.
The Manage Permissions are displayed on a new page. You can search for and add individual users, then grant them View, Design, and Remove definition permissions. Click the Save Permissions button to confirm. You can also grant or revoke permissions for App users using the other function below.
Archive.
This function archives the ETL instance.
On the ETL Instances page, select the instance in the table, then click the Utils-Archive menu option.
The ETL Instance is archived, and a confirmation message appears in the top-right corner.
