Example CSV File Destination

(1) Type of the destination data (file, database, email, functions, custom).

(2) The structure of the header can be entered manually.

(3) The output data can be built from ETL/ELT variables (surrounded with @ characters, e.g. @var_counter@), ETL/ELT fields (prefix $, e.g. $replace_store_location), see (5), or ETL/ELT source fields (prefix $, e.g. $1). The burger menu provides you with a selection of existing ETL/ELT fields, ETL source fields and ETL variables.

Note: ETL/ELT fields of a preceding task can only be passed on to the 'sibling tasks' (on the same level) with the clipboard. On the other hand, the nested 'child tasks' can always access the ETL/ELT fields of the 'parent tasks'.

(4) By entering test values, the output can be tested.

(5) ETL/ELT fields are defined here. These can be filled with values from source data columns, fixed values, values from the clipboard and function chains (with which actions can also be executed).

Note: ETL/ELT fields of a preceding task can only be passed on to the 'sibling tasks' (on the same level) with the clipboard. On the other hand, the nested 'child tasks' can always access the ETL/ELT fields of the 'parent tasks'.

Example SQL Database Destination

The SQL statement can be created in several ways. Important note: Please note the procedure when using a remote server!

(6) Via mapping, assignments of source data fields or fixed values for the target column can be stored. Alternatively, the desired output value can be created using functions. By specifying the ETL/ELT field of a previous task (that has been stored in the clipboard) and a search value of the current task, the value of the ETL/ELT field in the clipboard can be accessed (if the search value matches).

(7) Create your own SQL statement to execute a query, e.g. INSERT, DELETE, UPSERT.

(8) With the upsert via WHERE condition, each already existing record is updated (UPDATE). If the condition does not apply and no record is found, it will be added (INSERT).

(9) Here you can execute your own Scriptella instructions.

(10) Using the wizard, entries can be defined quickly and easily.