" Over 70 recipes to solve ETL problems using Pentaho Kettle Manipulate your data by exploring, transforming, validating, integrating, and more Work with all kinds of data sources such as databases, plain files, and XML structures among others Use Kettle in integration with other components of the Pentaho Business Intelligence Suite Each recipe is a carefully organized sequence of instructions packed with screenshots, tables, and tips to complete the task as efficiently as possible In Detail Pentaho Data Integration (PDI, also called Kettle), one of the data integration...

Explore, transform, validate, and integrate your data with ease Get started with Pentaho Data Integration from scratch. Enrich your data transformation operations by embedding Java and JavaScript code in PDI transformations. Create a simple but complete Datamart Project that will cover all key features of PDI. Part of Packt's Beginner's Guide series: Each task gradually develops from the previous task with an organized sequence of instructions accompanied with relevant explanation and a set of challenging tasks that the reader will be able to accomplish. In...

A complete guide to Pentaho Kettle, the Pentaho Data lntegration toolset for ETL This practical book is a complete guide to installing, configuring, and managing Pentaho Kettle. If you're a database administrator or developer, you'll first get up to speed on Kettle basics and how to apply Kettle to create ETL solutions—before progressing to specialized concepts such as clustering, extensibility, and data vault models. Learn how to design and build every phase of an ETL solution. Shows developers and database administrators how to use the open-source Pentaho Kettle for...

Create advanced reports, including cross tabs, sub-reports, and charts that connect to practically any data source using open source Pentaho Reporting. Create great-looking enterprise reports in PDF, Excel, and HTML with Pentaho's Open Source Reporting Suite, and integrate report generation into your existing Java application with minimal hassle Use data source options to develop advanced graphs, graphics, cross tabs, and sub-reports Dive deeply into the Pentaho Reporting Engine's XML and Java APIs to create dynamic reports Work with a multitude of examples throughout the...

Your all-in-one resource for using Pentaho with MySQL for Business Intelligence and Data Warehousing Open-source Pentaho provides business intelligence (BI) and data warehousing solutions at a fraction of the cost of proprietary solutions. Now you can take advantage of Pentaho for your business needs with this practical guide written by two major participants in the Pentaho community. The book covers all components of the Pentaho BI Suite. You'll learn to install, use, and maintain Pentaho-and find plenty of background discussion that will bring you thoroughly up to speed on BI and...