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.

Related Content you might be interested in

Current Title:

Small book image
Pentaho Data Integration Quick Start Guide
María Carina Roldán
Aug, 2018 | 178 pages
No titles found
Table of Contents (15 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
Dedication
Dedication
Packt Upsell
Packt Upsell
Foreword
Foreword
Contributors
Contributors
Preface
Preface
Free Chapter
1
Getting Started with PDI
Getting Started with PDI
Introducing PDI
Installing PDI
Configuring the graphical designer tool
Creating a simple transformation
Understanding the Kettle home directory
Summary
2
Getting Familiar with Spoon
Getting Familiar with Spoon
Exploring the Spoon interface
Designing, previewing, and running transformations
Defining and using Kettle variables
Running transformations with the Pan utility
Summary
3
Extracting Data
Extracting Data
Getting data from plain files
Getting data from relational databases
Getting data from other sources
Combining different sources into a single dataset
Summary
4
Transforming Data
Transforming Data
Transforming data in different ways
Sorting and aggregating data
Filtering rows
Looking up for data
Summary
5
Loading Data
Loading Data
Generating different kinds of files
Inserting and updating data in database tables
Loading a datamart
Summary
6
Orchestrating Your Work
Orchestrating Your Work
Understanding the purpose of PDI jobs
Designing and running jobs
Combining the execution of jobs and transformations
Running jobs with the Kitchen utility
Summary
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
Index

Configuring the graphical designer tool

Spoon is PDI's desktop designer tool. With Spoon, you can design, preview, and test all of your work (that is, transformations and jobs).

Before starting to work with PDI, it's advisable to take a look at the Spoon interface and do some minimal configuration. The instructions are as follows:

  • Start Spoon: If your system is Windows, run Spoon.bat from within the PDI installation directory. On other platforms, such as Unix, Linux, and so on, open a Terminal window and type spoon.sh.
  • The main window will show up, with a Welcome! window already open, as shown in the following screenshot:

Welcome page

Note

The Welcome! page includes some links to web resources, forums, and more, as well as some shortcuts for working with PDI. You can reach that window at any time by navigating to the Help | Welcome Screen option.

In order to customize Spoon, do the following:

  • Click on Options... in the Tools menu. A window appears, where you can change various general characteristics, as follows:

Options

 

  • Many of the options in this tab will not make sense to you yet. Instead of doing anything here, select the tab Look & Feel:

Look & Feel options

  • Feel free to change any of the options in this tab (for example, the font color or size). Click on the OK button.
  • Restart Spoon to apply the changes.
Previous Section
End of Section 4
Next Section