Estudiante

01. Installing Kettle
Pentaho Data Integration (Kettle) Tutorial

02. Spoon Introduction

Installing Kettle
You can download PDI from Sourceforge.net. At the time of this writing, the newest released version is 3.0.3, so the file you have to download is
Kettle-3.0.3.GA-nnnn.zip.

Prerequisites
Kettle requires the Sun Java Runtime Environment (JRE) version 1.5 (also called 5.0 in somenaming schemes) or newer. You can obtain a JRE
for free from http://java.sun.com/.

Installation
PDI does not require installation unless you download the Windows .exe file, which needs no specific installation instructions. For all other
platforms, simply unpack the zip file into a folder of your choice. On Unix-like operating systems, you will need to make the shell scripts
executable byusing the chmod command:

cd Kettle
chmod +x *.sh

Pentaho Data Integration (Kettle) Tutorial

02. Spoon Introduction

02. Spoon Introduction
01. Installing Kettle

Pentaho Data Integration (Kettle) Tutorial

03. Hello World Example

Spoon Introduction
Spoon is the graphical tool with which you design and test every PDI process. The other PDI components execute the processesdesigned with
Spoon, and are executed from a terminal window.

Repository and files
In Spoon, you build Jobs and Transformations. PDI offers two methods to save them:
1. Database repository
2. Files
If you choose the repository method, the repository has to be created the first time you execute Spoon. If you choose the files method, the Jobs
are saved in files with the kjb extension, and theTransformations are in files with the ktr extension. In this tutorial you'll work with the second
method.

Starting Spoon
Start Spoon by executing spoon.bat on Windows, or spoon.sh on Unix-like operating systems. As soon as Spoon starts, a dialog window
appears asking for the repository connection data. Click the No Repository button.
The next thing you'll see is a welcome window. Go to the Editmenu and click Options.... A window will come up that enables you to change
various general and visual characteristics. If you change something, it will be necessary to restart Spoon in order to see the changes applied.
01. Installing Kettle

Pentaho Data Integration (Kettle) Tutorial

03. Hello World Example

03. Hello World Example
02. Spoon Introduction

Pentaho Data Integration(Kettle) Tutorial

04. Refining Hello World

Hello World Example
Although this will be a simple example, it will introduce you to some of the fundamentals of PDI:
Working with the Spoon tool
Transformations
Steps and Hops
Predefined variables
Previewing and Executing from Spoon
Executing Transformations from a terminal window with the Pan tool.

Overview
Let's suppose that you have aCSV file containing a list of people, and want to create an XML file containing greetings for each of them.
If this were the content of your CSV file:
last_name, name
Suarez,Maria
Guimaraes,Joao
Rush,Jennifer
Ortiz,Camila
Rodriguez,Carmen
da Silva,Zoe

This would be the output in your XML file:
-
-
Hello,

-
Hello,

-
Hello,

-
Hello,

-
Hello,

-
Hello,Maria!

Joao!

Jennifer!

Camila!

Carmen!

Zoe!

The creation of the file with greetings from the flat file will be the goal for your first Transformation.
A Transformation is made of Steps linked by Hops. These Steps and Hops form paths through which data flows. Therefore it's said that a
Transformation is data-flow oriented.

Preparing the environment

Before starting aTransformation, create a Tutorial folder in the installation folder or some other convenient place. There you'll save all the files for
this tutorial. Then create a CSV file like the one shown above, and save it in the Tutorial folder as list.csv.

Transformation walkthrough
The proposed task will be accomplished in three subtasks:
1. Creating the Transformation
2. Constructing the skeleton of...