Database (source ETL/ELT)

(1) First select a 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) Here you can easily create the SQL query (4) with a wizard.

(4) The SQL query created by the wizard (3). The ETL/ELT source fields are created based on the name after the AS. You can also adjust it manually. In addition, you can insert WHERE conditions and use ETL/ELT variables in them, e.g. WHERE id_partner=@VAR_ID@ Note: The value of the variable can be passed, for example, by a workflow when it starts the pipeline. Important note: Please note that you can only customise the ETL/ELT source field names using the AS keyword. SELECT id_partner... therefore cannot be successfully changed to SELECT my_id_partner... to get the ETL/ELT source field my_id_partner, but only via SELECT id_partner AS 'my_id_partner'...

(5) Tests the SQL query (4) and returns the first row of the result set.

(6) You can specify database properties here, which may override the properties from the alias. The changeable JDBC properties are predefined. Unknown properties are ignored and removed from the list.