Sign In Start Free Trial

Pentaho Data Integration Quick Start Guide

By : Carina Roldán

3 (1)

Pentaho Data Integration Quick Start Guide

3 (1)

By: 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.

Preface

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

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

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

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

Transforming data in different ways

Sorting and aggregating data

Filtering rows

Looking up for data

Summary

Loading Data

Loading Data

Generating different kinds of files

Inserting and updating data in database tables

Loading a datamart

Summary

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

Customer Reviews

3 (1)

5 star

0

4 star

0

3 star

100%

2 star

0

1 star

0

Installing PDI

The following are the instructions to install the PDI Community Edition (CE), irrespective of the operating system that you may be using:

Make sure that you have JRE 8.0 installed.

If you don't have JRE 8.0 installed, download it from http://www.java.com Redash source code by cloning the repository, and install it before proceeding. Make sure that the JAVA_HOME system variable is set.

Go to the download page at: https://sourceforge.net/projects/pentaho/files/Data%20Integration/.
Choose the latest stable release. At the time of writing this book, it is 8.1, as shown in the following screenshot:

PDI on SourceForge.net

Download the available ZIP file, which will serve you for all platforms.
Unzip the downloaded file in a folder of your choice (for example, c:/software/pdi or /home/pdi_user/pdi).
Browse your disk and look for the PDI folder that was just created. You will see a folder named data-integration, with several subfolders (lib, plugins, samples, and more) and a bunch of scripts (spoon.bat, pan.bat, and others), which we will soon learn how to use.

Search

Your notes and bookmarks