The premier open source ETL tool is at your command with this recipe-packed cookbook. Learn to use data sources in Kettle, avoid pitfalls, and dig out the advanced features of Pentaho Data Integration the easy way.Key FeaturesIntergrate Kettle in integration with other components of the Pentaho Business Intelligence Suite, to build and publish Mondrian schemas,create reports, and populatedashboardsThis book contains an organized sequence of recipes packed with screenshots, tables, and tips so you can complete the tasks as efficiently as possibleManipulate your data by exploring, transforming, validating, integrating, and performing data analysisBook DescriptionPentaho Data Integration is the premier open source ETL tool, providing easy, fast, and effective ways to move and transform data. While PDI is relatively easy to pick up, it can take time to learn the best practices so you can design your transformations to process data faster and more efficiently. If you are looking for clear and practical recipes that will advance your skills in Kettle, then this is the book for you. Pentaho Data Integration Cookbook Second Edition guides you through the features of explains the Kettle features in detail and provides easy to follow recipes on file management and databases that can throw a curve ball to even the most experienced developers. Pentaho Data Integration Cookbook Second Edition provides updates to the material covered in the first edition as well as new recipes that show you how to use some of the key features of PDI that have been released since the publication of the first edition. You will learn how to work with various data sources – from relational and NoSQL databases, flat files, XML files, and more. The book will also cover best practices that you can take advantage of immediately within your own solutions, like building reusable code, data quality, and plugins that can add even more functionality. Pentaho Data Integration Cookbook Second Edition will provide you with the recipes that cover the common pitfalls that even seasoned developers can find themselves facing. You will also learn how to use various data sources in Kettle as well as advanced features.What you will learnConfigure Kettle to connect to relational and NoSQL databases and web applications like SalesForce, explore them, and perform CRUD operationsUtilize plugins to get even more functionality into your Kettle jobsEmbed Java code in your transformations to gain performance and flexibilityExecute and reuse transformations and jobs in different waysIntegrate Kettle with Pentaho Reporting, Pentaho Dashboards, Community Data Access, and the Pentaho BI PlatformInterface Kettle with cloud-based applicationsLearn how to control and manipulate data flowsUtilize Kettle to create datasets for analyticsWho this book is forPentaho Data Integration Cookbook Second Edition is designed for developers who are familiar with the basics of Kettle but who wish to move up to the next level.It is also aimed at advanced users that want to learn how to use the new features of PDI as well as and best practices for working with Kettle.