Explaining predefined variables

Predefined variables are Kettle variables mainly related to the environment in which PDI is running. These variables are ready to be used both in Jobs and Transformations and their scope is the Java Virtual Machine (JVM).

The following table lists some of the most used predefined variables:

Subject

Predefined variables

Operating system

${os.name}${os.version}

Current user

${user.home}${user.name}${user.timezone}${user.language}

Java installation

${java.home}${java.io.tmpdir}${java.version}

Kettle (aka PDI) installation

${Internal.Kettle.Build.Date}${Internal.Kettle.Build.Version}${Internal.Kettle.Version}

 

Among the internal or predefined variables, there is ...

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.