Pentaho Data Integration Beginner's Guide - Second Edition

Get up and running with the Pentaho Data Integration tool using this hands-on, easy-to-read guide with this book and ebook

Key Features

• Manipulate your data by exploring, transforming, validating, and integrating it
• Learn to migrate data between applications
• Explore several features of Pentaho Data Integration 5.0
• Connect to any database engine, explore the databases, and perform all kind of operations on databases

Book Description

What you will learn

• Install and get started with Pentaho Data Integration
• Get started with MySQL
• Learn the ins and outs of Spoon, the graphical designer tool
• Transform data in several ways such as performing simple and complex calculations, cleaning, counting, de-duplicating, filtering, and ordering
• Learn to get data from all kind of data sources as plain files, Excel spreadsheets, databases, XML files and more, then preview it, and send it back to the same or different destinations
• Discover how to read and parse unstructured files
• Embed Java and JavaScript code in your Pentaho Data Integration transformations to enrich the treatment of data
• Use Pentaho Data Integration to perform CRUD (create, read, update, and delete) operations on databases
• Learn the basic concepts of data warehousing
• Populate a data warehouse with Pentaho Data Integration including loading slowly changing dimensions, junk dimensions, time dimensions and more
• Implement business processes by scheduling tasks, checking conditions, organizing files and folders, running daily processes, treating errors, and so on in a way that meets your requirements

Who this book is for

This book is a must-have for software developers, database administrators, IT students, and everyone involved or interested in developing ETL solutions, or, more generally, doing any kind of data manipulation. Those who have never used Pentaho Data Integration will benefit most from the book, but those who have, they will also find it useful.

This book is also a good starting point for database administrators, data warehouse designers, architects, or anyone who is responsible for data warehouse projects and needs to load data into them.