Book Image

Pentaho Data Integration Quick Start Guide

By : María Carina Roldán
Book Image

Pentaho Data Integration Quick Start Guide

By: María Carina Roldán

Overview of this book

Pentaho Data Integration(PDI) is an intuitive and graphical environment packed with drag and drop design and powerful Extract-Transform-Load (ETL) capabilities. Given its power and flexibility, initial attempts to use the Pentaho Data Integration tool can be difficult or confusing. This book is the ideal solution. This book reduces your learning curve with PDI. It provides the guidance needed to make you productive, covering the main features of Pentaho Data Integration. It demonstrates the interactive features of the graphical designer, and takes you through the main ETL capabilities that the tool offers. By the end of the book, you will be able to use PDI for extracting, transforming, and loading the types of data you encounter on a daily basis.
Table of Contents (15 chapters)

Running jobs with the Kitchen utility


In Chapter 2, Getting Familiar with Spoon, you learned how to run transformations in production environments by using the Pan command-line utility. There is a counterpart tool for running jobs: the Kitchen command. Using Kitchen is no different than using Pan. The tool comes in two flavors: Kitchen.bat and Kitchen.sh, for use in a Windows or a Linux system, respectively. Let's review the different options. The simplest way to run a job is to indicate the full path of the kjb file. You do so with the following syntax:

Kitchen.bat /file=<kjb file name>

You can also use the following command:

Kitchen.sh /file=<kjb file name>

For example, if you want to load the datamart from the command line in Windows, you can do so by running the following command:

Kitchen.bat /file=c:/pdi/load_datamart.kjb

Kitchen can receive the same parameters that Pan does; the most common are as follows:

  • level: This indicates the log level. The syntax for setting the log level...