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)

Exploring the Spoon interface

In Chapter 1, Getting Started with PDI, you used Spoon to create your first transformation. In this chapter, you will learn more about the experience of working with Spoon. First, let's take a look at its interface. The following screenshot shows you the different areas, menus, and toolboxes present in Spoon:

Spoon interface

The following provides a brief description of every component shown in the preceding screenshot:

  • Main Menu: This menu includes general options, such as opening and saving files (namely, transformations and jobs), editing and searching features, configuration settings, and help options.


Most of the options in the main menu contain shortcuts that you can memorize and use, if you prefer to do so.


  • Main Toolbar: This toolbar serves as an alternative way to create, open, and save files.
  • Transformation Toolbar: This toolbar contains options for running, previewing, and validating the open transformation.
  • Work Area: This is the area where you create...