Pentaho® Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration

Appendix C. Built-in Variables and Properties Reference

This appendix starts with a description of all the internal variables that are set automatically by Kettle. That is followed by a list of all the variables that you can set to influence the way that Kettle operates at run-time. Next, we discuss how you can define variables to help secure FTP authentication using VFS. Finally, we mention a few noteworthy variables from the Java Runtime Environment.

For more information on how to use variables, see Chapter 2.

Internal Variables

Table C-1 shows all the variables that are defined at run-time by the Kettle transformation or job engine.

Table C.1. Internal Variables

VARIABLE	DESCRIPTION
Internal.Kettle.Version	This contains the version string of Kettle, for example, 4.0.0.
Internal.Kettle.Build.Version	This contains the subversion revision of the Kettle source of the build you're using.
Internal.Kettle.Build.Date	The build date.
Internal.Job.Filename.Directory	If you are running a job from a file (.kjb), this variable will contain the folder in which that file is located. This variable allows you to specify other jobs, transformations, and files in a relative fashion.
Internal.Job.Filename.Name	If you are running a job from a file (.kjb), this variable will contain the name of that file.
Internal.Job.Name	The name of the currently executing parent job.
Internal.Job.Repository.Directory	If you are running a job from a repository, this variable will contain the path to the repository directory from which ...