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

Preface

Pentaho Data Integration Quick Start Guide provides the guidance needed to get started with Pentaho Data Integration (PDI), covering the main features of the tool. The book shows the interactive features of the graphical designer, and explains the main ETL capabilities that the tool offers.

The book's content is based on PDI 8.1 Community Edition (CE), the latest version. However, it can be used with the Enterprise Edition (EE) as well. Many of the examples will also work with earlier versions of PDI.