Variables (ETL/ELT)
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. |