Book Overview & Buying
Table Of Contents
Feedback & Rating

Pentaho Data Integration Quick Start Guide

By : Carina Roldán

3 (1)

Buy this Book

Pentaho Data Integration Quick Start Guide

3 (1)

By: Carina Roldán

Buy this Book

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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Getting Started with PDI

Introducing PDI

Installing PDI

Configuring the graphical designer tool

Creating a simple transformation

Understanding the Kettle home directory

Summary

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

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

Transforming Data

Transforming data in different ways

Sorting and aggregating data

Filtering rows

Looking up for data

Summary

Loading Data

Generating different kinds of files

Inserting and updating data in database tables

Loading a datamart

Summary

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

Leave a review - let other readers know what you think

Customer Reviews

3 (1)

5 star

4 star

3 star

100%

2 star

1 star

Transforming data in different ways

So far, we have seen how to create a PDI dataset mainly using data coming from files or databases. Once you have the data, there are many things you can do with it depending on your particular needs. One very common requirement is to create new fields where the values are based on the values of existent fields.

The set of operations covered in this section is not a full list of the available options, but includes the most common ones, and will inspire you when you come to implement others.

The files that we will use in this section were built with data downloaded from www.numbeo.com, a site containing information about living conditions in cities and countries worldwide.

For learning the topics in this chapter, you are free to create your own data. However, if you want to reproduce the exercises exactly as they are explained, you...