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