ETL and ELT Tasks

This is where the individual tasks (4) of an ETL/ELT entry are managed and settings for loading the source data (8) and the handling of the destination data (9) are defined.

(1) Via the expert mode you can adapt the existing Scriptella script (the engine underlying this module). Important note: A change in the script cannot be undone. Please duplicate the ETL/ELT entry in advance before changing the script!

(2) The ETL/ELT entry is only executed if the conditions remain empty or the created function chain returns true. Only ETL/ELT fields of parent ETL/ELT tasks (4) can be used here.

(3) If tolerant error handling is enabled, the entry jumps to the next task (4) in case of an error in the execution of the action (destination data). Errors within the source data always lead to a termination of the entire ETL/ELT entry.

(4) In this overview, the individual ETL/ELT tasks of the ETL/ELT entry can be managed structurally ('parent task', 'child task', 'sibling tasks') and new tasks can be added. ETL/ELT fields of a preceding task can only be passed on to the 'sibling tasks' (on the same level) with the clipboard (10). On the other hand, the nested 'child tasks' can always access the ETL/ELT fields of the 'parent tasks'.

(5) Provides the most important information about the ETL/ELT entry (source data, destination data), a diagram view and an XML debug file (provides information about the execution of the ETL/ELT task actions).

(6) The entry is saved and executed. The actions of the individual tasks run over all records of the source and generate destination data from them.

(7) The entry is saved and a test run is performed. The actions run over a selected number of test records of the source and generate destination data.

(8) See section Source Data (ETL/ELT).

(9) See section Action (Destination Data) (ETL/ELT).

(10) See section Clipboard (ETL/ELT).