This step helps users who want to use variables at the session level for transformations. For example, users can include this step with the Call Endpoint step in a transformation which allows them to hit their BA Server session when the transformation is run.
The Get Session Variables step allows you to retrieve the value of a session variable. This step can return rows or add values to input rows.
Note: You must specify the complete variable specification in the format ${variable} or %%variable%% (as described in Variables). You can also enter complete strings in the variable column, not just a variable. For example, you can specify: ${java.io.tmpdir}/kettle/tempfile.txt and it will be expanded to /tmp/kettle/tempfile.txt on Unix-like systems.
See Also:
Option |
Description |
---|---|
Step Name |
Name of the step as it appears in the transformation workspace. This name must be unique within a single transformation. |
# |
The order the fields will be passed. |
Field |
Name of the field which will receive the value retrieved from the session variable. If a value cannot be retrieved, the default value is used. |
Variable |
Specify the name for the session variable which you want to retrieve for this step. Specify the value using a complete string to return rows or add values to input rows. For example, you can specify: ${java.io.tmpdir}/kettle/tempfile.txt and it will be expanded to /tmp/kettle/tempfile.txt on Unix-like systems. |
Default Value |
Specify the default value for the variable. |
Six example transformations are included in the attached archive.