Knowing the basics about Kettle variables

In this chapter, you used the string ${Internal.Entry.Current.Directory} to identify the folder where the current Job was saved. You also used the string ${MY_FOLDER} to define the name of the folder to be created. Both strings, ${Internal.Entry.Current.Directory} and ${MY_FOLDER}, are Kettle variables, that is, keywords linked to a value. You use the name of a variable, and when the Transformation runs, the name of the variable is replaced by its value.

The first of these two variables is an environment variable, and it is not the only one available. Other known environment variables are: ${user.home}, ${java.io.tmpdir}, and ${java.home}. All these variables, whose values are auto-populated by PDI, ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.