Pentaho Data Integration Quick Start Guide: Create ETL processes using Pentaho - Softcover

Maria Carina Roldan

Softcover

ISBN 10: 1789343321 ISBN 13: 9781789343328

Publisher: Packt Publishing, 2018

Synopsis

Get productive quickly with Pentaho Data Integration

Key Features

• Take away the pain of starting with a complex and powerful system
• Simplify your data transformation and integration work
• Explore, transform, and validate your data with Pentaho Data Integration

Book Description

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.

What you will learn

• Design, preview and run transformations in Spoon
• Run transformations using the Pan utility
• Understand how to obtain data from different types of files
• Connect to a database and explore it using the database explorer
• Understand how to transform data in a variety of ways
• Understand how to insert data into database tables
• Design and run jobs for sequencing tasks and sending emails
• Combine the execution of jobs and transformations

Who this book is for

This book is for software developers, business intelligence analysts, and others involved or interested in developing ETL solutions, or more generally, doing any kind of data manipulation.

Table of Contents

1. Getting Started with PDI
2. Getting Familiar with Spoon
3. Extracting Data
4. Tranforming Data
5. Loading Data
6. Orchestrating your Work

About this title

About the Author

María Carina Roldán was born in Argentina and has a bachelor's degree in computer science.

She started working with Pentaho back in 2006. She spent all these years developing BI solutions, mainly as an ETL specialist, and working for different companies around the world.

Currently, she lives in Buenos Aires and works as an independent consultant.

Carina is the author of Learning Pentaho Data Integration 8 CE, published by Packt in December 2017. She has also authored other books on Pentaho, all of them published by Packt.

Edition details

• Publisher: Packt Publishing
• Publication date: 2018
• ISBN 10: 1789343321
• ISBN 13: 9781789343328
• Binding: Paperback
• Language: English
• Number of pages: 178