In this menu you can create, modify, delete ETL/ELT variables and import them from profiles or workflows.
Settings
(1) Plus icon: Creates a new variable.
(2) Changeable at start: When calling an ETL/ELT pipeline 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.
Context menu
Create copy | Self-explanatory. |
Delete entry | Self-explanatory. |
Delete all entries | Self-explanatory. |
Import variables from | Variables can be imported from a specific profile or workflow into the ETL/ELT pipeline. |
Export | Exports variables as CSV file. |
Copy all entries | Self-explanatory. |
New entry | Self-explanatory. |
ETL/ELT system variables
BASE_PATH | Is automatically set to the path of the installation directory of the Integration Server. Note: Changes have no effect because the value is always set again automatically. |
TEST_PATH | Analogous to "BASE_PATH" for test runs. |
JOB_ID | Will be filled with the ID of the job at runtime. |
LAST_RUN | The time of the last run of the ETL/ELT pipeline. |