Database (destination ETL/ELT)
(1) The destination database alias. Note: Variables (syntax @MYVAR@, type String) can also be used here. These are available via the drop-down menu.
(2) See section SQL Console.
(3) Generation of the SQL statement. See following sections. You can use ETL/ELT variables (@VAR@) and ETL/ELT fields ($field).
Mapping (Insert)
(1) The destination database alias.
(2) See section SQL Console.
(3) Selection of destination table.
(4) With auto commit, the SQL statements are not transaction-based, but executed directly.
(5) Selection of ETL/ELT source fields, custom ETL/ELT fields, index columns and ETL/ELT variables. See also (6).
(6) Allows you to move selected items (5) and (7) to the right. With the symbol at the bottom, entries selected on the left can be assigned to existing entries on the right in order. Drag and drop is also possible.
(7) Selection of columns of the selected table (3). See also (6).
(8) Fixed values, ETL/ELT source fields, custom ETL/ELT fields and ETL/ELT variables can be assigned to the columns.
(9) The replacement value for destination fields without value.
(10) Here you can view the generated statement.
Mapping (Upsert)
The configuration here is the same as for the insert, but there is an additional field for the WHERE condition. ETL/ELT source fields and custom ETL/ELT fields can be used and ETL/ELT variables (1).
Custom SQL Statement
Here you can specify your own SQL statement.