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 Set Session Variables step allows you to set the value of session variable.
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 |
The name of the step as it appears in the transformation workspace. This name must be unique within a single transformation. |
Apply formatting check box |
Select this check box to convert your variable to string format. Variables can be of any data type, such as a date, integer, Boolean, or Array. Selecting this check box applies the string format to the variable so it can be used. |
# |
The order the fields will be passed. |
Field name |
Specify the name of the field which will provide the value to be stored in the session variable. If a value is not provided, the default value is used. |
Variable name |
Specify the name for the session variable which you want to create 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 a default value to use for this variable. |
Six example transformations are included in the attached archive.