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

Orchestrating Your Work

In this chapter, you will learn how to organize your work with PDI jobs. By the end of the chapter, you will be able to use PDI jobs to sequence tasks, dealing with files, sending emails, and other useful tasks.

The following topics will be covered in this chapter: