Pentaho 3.2 Data Integration: Beginner's Guide

Explore, transform, validate, and integrate your data with ease

Pentaho 3.2 Data Integration: Beginner's Guide

María Carina Roldán

Explore, transform, validate, and integrate your data with ease
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$10.00
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook

Frequently bought together


Pentaho 3.2 Data Integration: Beginner's Guide Book Cover
Pentaho 3.2 Data Integration: Beginner's Guide
$ 29.99
$ 10.00
Pentaho Data Integration 4 Cookbook Book Cover
Pentaho Data Integration 4 Cookbook
$ 26.99
$ 5.40
Buy 2 for $15.40
Save $41.58
Add to Cart

Book Details

ISBN 139781847199546
Paperback492 pages

Book Description

Pentaho Data Integration (a.k.a. Kettle) is a full-featured open source ETL (Extract, Transform, and Load) solution. Although PDI is a feature-rich tool, effectively capturing, manipulating, cleansing, transferring, and loading data can get complicated.

This book is full of practical examples that will help you to take advantage of Pentaho Data Integration's graphical, drag-and-drop design environment. You will quickly get started with Pentaho Data Integration by following the step-by-step guidance in this book. The useful tips in this book will encourage you to exploit powerful features of Pentaho Data Integration and perform ETL operations with ease.

Starting with the installation of the PDI software, this book will teach you all the key PDI concepts. Each chapter introduces new features, allowing you to gradually get involved with the tool. First, you will learn to work with plain files, and to do all kinds of data manipulation. Then, the book gives you a primer on databases and teaches you how to work with databases inside PDI. Not only that, you'll be given an introduction to data warehouse concepts and you will learn to load data in a data warehouse. After that, you will learn to implement simple and complex processes.
Once you've learned all the basics, you will build a simple datamart that will serve to reinforce all the concepts learned through the book.

Table of Contents

What You Will Learn

  • Install Penataho Data Integration and get familiar with the graphical designer—Spoon
  • Work with files to get data from simple input sources, preview, and send it back in any of the common output formats
  • Perform basic transformation operations on data such as performing calculations, adding constants, counting, filtering, ordering, and searching data
  • Solve real-world problems by manipulating the flow of data by combining or splitting it
  • Solve sophisticated problems such as normalizing data from pivoted tables with ease
  • Explore the various PDI options to validate data and to handle errors
  • Connect to a database engine of your choice to get and store information coming from any source
  • Perform advanced operations with databases such as loading data dimensions
  • Create advanced processes such as nesting jobs, iterating on jobs and transformations, and creating subtransformations
  • Implement business processes by scheduling tasks, checking conditions, organizing files and folders, sending emails with alerts, and treating errors in a way that meets your requirements

Authors

Table of Contents

Book Details

ISBN 139781847199546
Paperback492 pages
Read More

Read More Reviews

These popular $10 titles might interest you

Pentaho Data Integration 4 Cookbook Book Cover
Pentaho Data Integration 4 Cookbook
$ 26.99
$ 5.40
Getting Started with Talend Open Studio for Data Integration Book Cover
Getting Started with Talend Open Studio for Data Integration
$ 26.99
$ 10.00
Pentaho Data Integration 4 Cookbook Book Cover
Pentaho Data Integration 4 Cookbook
$ 26.99
$ 5.40
Oracle E-Business Suite R12 Supply Chain Management Book Cover
Oracle E-Business Suite R12 Supply Chain Management
$ 35.99
$ 10.00
Pentaho Data Integration 4 Cookbook Book Cover
Pentaho Data Integration 4 Cookbook
$ 26.99
$ 5.40
PHP Ajax Cookbook Book Cover
PHP Ajax Cookbook
$ 26.99
$ 10.00