O'Reilly logo

Pentaho® Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration by Jos van Dongen, Roland Bouman, Matt Casters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required