ETL scenario in XML Format

When to use this Flow type

Etlworks includes a Flow type called Execute scenario in XML Format.

Since Etlworks internally translates Flows into the XML based ETL language, it can execute any Flow that is already in this Format.

To create a data integration Flow in the XML Format:

Step 1. Create a Flow in the XML. Use only named Connections (as opposed to the default source and destination Connections).

Step 2. Open the Flows window, click Add flow, and type execute scenario into the Select Flow Type box:

Step 3. Add all Connections and Formats required for the Flow. Use the Connection names created in step 1.

Step 4. Select the tab Parameters and copy and paste your XML Flow, which was created in step 1, into the Scenario field.

To view the flow in XML format, click the View Flow XML button next to the flow name in the Flows window.

Here is an example of the XML view: