Essential Pentaho ETL: A self-study reference and practice book for ETL beginners

A self-study reference and practice book for ETL beginners. The Essential Pentaho ETL book provides an overview of the Pentaho Data Integration. This will develop the skill to create easy ETL solutions using the UI-based designer. The Pentaho Data Integration Spoon can connect to various sources including structured, semi-structured, and non-structured sources. This will also help you install the Pentaho Data Integration Spoon, customizing the Pentaho Data Integration Spoon, understanding how to deal with data, scheduling the ETL Jobs and Transformations, and Monitoring the ETLs. It is a self-study PDI ETL reference and practice book that will take you from dreaming of learning ETL and the potential to unlocking your success as an ETL beginner. So, the author of this book aims to assist you to get acquainted with PDI ETL. One of the goals of this edition of Essential Pentaho ETL is to provide a book that can be used as a teach-yourself book. Here are some of the concepts that cover in the Essential Pentaho ETL, First Edition, as a textbook: •Setup PDI ETL Spoon on your local machine •Setup Pentaho server on your local machine •Configure the PDI •Connect to the PDI Repository •Customise the PDI •Create Jobs and Transformation. •Create, preview, and run basic transformations containing steps and hops •View transformation results in the Step Metrics view and the Log view •Create a database connection and use Database Explorer to interact with a data source •Create more transformations that involve configuring the following steps: Table input, Table output, Text file output, CSV file input, Filter, Sort rows, Row normalizer, Get Data from XM, etc. •Use ETL design patterns to populate a data warehouse •Create Pentaho Data Integration jobs that: run multiple transformations, load and process multiple text files •Create a transformation that uses a rest API as an input and output •Create tranformation that uses table and flat files as an input