KETTLE Variables
The kettle.properties file contain all the global variables for KETTLE.
This Lab overviews the main configuration file - kettle.properties
• Learn about Global variables.
• Set variables in the kettle.properties file.
Global Variables ..
Variables can be used throughout Pentaho Data Integration, including in transformation steps and job entries. You define variables by setting them with the Set Variable step in a transformation or by setting them in the kettle.properties file in the directory.
The way to use them is either by grabbing them using the Get Variable step or by specifying meta-data strings like:
${VARIABLE} or:
%%VARIABLE%%
Both formats can be used and even mixed, the first is a UNIX derivative, the second is derived from Microsoft Windows. Dialogs that support variable usage throughout Pentaho Data Integration are visually indicated using a blue dollar sign.
You can use + space hot key to select a variable to be inserted into the property value. Mouse over the variable icon to display the shortcut help.
Set a Variable in kettle.properties
Select Edit -> Edit the kettle.properties file
Highlight the first row and right mouse click, and select the following option.
Add the following variable values.
| Variable Name | Value |
|---|---|
DIR_SAMPLES | /home/pentaho/Temp |
Save.
The kettle.properties can also be edited manually
In a Terminal.
The global variable is accessed, in transformations, by selecting Ctrl + Spacebar, wherever you see a blue diamond.
Last updated
