Variables (ETL/ELT)

In this menu you can create, modify, delete ETL/ELT variables and import them from profiles or workflows.

images/download/attachments/91133005/ETL_variables_EN-version-1-modificationdate-1656929076531-api-v2.png

(1) The ETL/ELT system variable BASE_PATH is automatically set to the path of the _data installation directory. The variable can then be used within path specifications in the ETL/ELT entry. Note: Changes have no effect because the value is always set again automatically.

(2) Analogous to (1) for test runs.

(3) Creates a new variable.

(4) The context menu can be used to import variables from a specific profile or workflow into the ETL/ELT entry.

(5) When calling an ETL/ELT entry via a workflow, the values of workflow variables are passed to ETL/ELT variables with the same name. For this, however, this option here must be set for these ETL/ELT variables.