ETL/ELT tasks
The ETL/ELT tasks are the core elements of data processing in ETL/ELT pipelines.
Each ETL/ELT pipeline consists of at least one ETL/ELT task. Each task has a source and a destination. One row of source data is read in and one row of destination data is generated from it until all of the source data has been processed. The error handling is described in sections Source data (ETL/ELT) and Destination data (action) (ETL/ELT). Note: The current iteration number can be accessed with $rownum.
If several tasks are specified, they will be processed one after the other from top to bottom.
If a task has a child task (indentation), the child task is executed per row of the parent task. The child tasks have access to the ETL/ELT fields of the parent t ask. See section Examples (ETL/ELT).
Sibling tasks (on the same level) can access ETL/ELT fields of a previous task only via the clipboard. See section Examples (ETL/ELT).
Settings
(1) ETL/ELT tasks: The task list.
(2) Task information: See section Task information.
(3) Source data: See section Source data.
(4) Custom ETL/ELT fields: See section Custom ETL/ELT fields.
(5) Destination data (action): See section Destination data (action).
(6) Clipboard: See section Clipboard.
(7) Summary: Here you will find a summary with the most important information about the ETL/ELT pipeline (source data, destination data), a diagram view and an XML debug file.