Destination data (action) (ETL/ELT)

Settings


(1) Conditions for each row/execution: Here you can define conditions for each row. If these conditions are not met, you can decide how the row should be handled.

Skip that record

The row is skipped and the next row is processed.

Perform a separate action for that record

The row is skipped (as far as the primary data destination is concerned), but a secondary data destination can be specified for this row. After that the next row will be processed.

Pass on record and perform extra action

The processing of this row will continue (primary data destination), but a secondary data destination can also be specified for this row. After that, the next row will be processed.


(2) Error handling: If a row survives the condition checks, the error handling takes effect. If an error occurs for the row when writing to the primary data destination ("Type destination data"), the following options are available.

Cancel entire ETL/ELT pipeline

If an error occurs while writing a row to the primary data destination, the entire ETL/ELT pipeline is aborted.

Tolerant (continue with next record)

If an error occurs while writing in a row to the primary data destination, the row is ignored and processing continues for the next row.

Perform a separate action on this record

If an error occurs when writing a row to the primary data destination, the row is ignored (as far as the primary data destination is concerned), but a separate action can then be performed for this row, i.e. a secondary data destination can be defined. After that the next row will be processed.


(3) Release resources created for further processing: If this checkbox is set, later sources (in following tasks) are allowed to access files newly created by this task (if any are created).

(Primary) Data destination types


  • Database (destination ETL/ELT)

  • MongoDB (destination ETL/ELT)

  • CSV/Text (destination ETL/ELT)

  • Fix record (destination ETL/ELT)

  • Template (destination ETL/ELT)

  • E-mail (destination ETL/ELT)

  • Functions (destination ETL/ELT)

  • Custom (destination ETL/ELT)

  • Without (destination ETL/ELT)