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 enterprise-level ETL processes (Extracting, Transforming, and Loading data) Assumes no prior knowledge of Kettle or ETL, and brings beginners thoroughly up to speed at their own pace Explains how to get Kettle solutions up and running, then follows the 34 ETL subsystems model, as created by the Kimball Group, to explore the entire ETL lifecycle, including all aspects of data warehousing with Kettle Goes beyond routine tasks to explore how to extend Kettle and scale Kettle solutions using a distributed “cloud” Get the most out of Pentaho Kettle and your data warehousing with this detailed guide—from simple single table data migration to complex multisystem clustered data integration tasks. From the Back Cover The ultimate resource on building and deploying data integration solutions with Kettle Kettle is a scaleable and extensible open source ETL and data integration tool that lets you extract data from databases, flat and XML files, web services, ERP systems, and OLAP cubes. It provides over 120 built-in transformation steps to validate, cleanse, and conform data, as well as numerous options to load data into data warehouses and many other targets. Kettle is a comprehensive, low-cost alternative to traditional data integration tools like Informatica PowerCenter, IBM InfoSphere DataStage, and BusinessObjects Data Integrator. This book explains in detail how to use Kettle to create, test, and deploy your own ETL and data integration solutions. You'll learn to use Kettle's programs to create transformations and jobs, use version control, audit data, and schedule your ETL solution. Then you'll progress to more advanced concepts such as clustering and cloud computing, real-time data integration, loading a Data Vault model, and extending Kettle by building your own plugins. In addition, you'll find hands-on examples and case studies that show exactly how to put Kettle's features into practice. Explore the components of the Kettle ETL toolset

Discover how to install and configure Kettle and connect it to various data sources and targets

Design and build every aspect of an ETL solution using Kettle

Learn how to load a data warehouse with Kettle

Understand the steps for deploying and scheduling ETL solutions

Gain the skills to integrate Kettle with third-party products

Learn to extend Kettle and build your own plugins

Use clustering and cloud computing to scale and improve the performance of your Kettle ETL solutions

Find out how to use Kettle for real-time data integration

Matt Casters是一位具有多年工作經驗的獨立商業智能顧問。他為許多大公司建立瞭無數個數據倉庫和 BI解決方案。在過去的 8年裏， Matt Casters把自己的時間都用於研發一個 ETL工具—— Kettle。2005年12月， Kettle成為開源軟件。 2006年初期， Kettle走進 Pentaho。隨後， Matt就職於 Pentaho，成為數據集成總監。在 Pentaho,他繼續從事 Kettle的研發工作。 Matt緻力於幫助建設 Kettle社區，迴答論壇上的提問，有時在世界會議上發錶演講。博客： http://www.ibridge. be。Twitter：@mattcasters。

Roland Bouman目前從事前颱頁麵和商業智能的研發工作。他從 1998年開始從事 IT行業。多年來一直緻力於開源軟件的研發，尤其是數據庫技術、商業智能以及頁麵開發框架。同時， Roland Bouman還是 MySQL和Pentaho社區的成員。他經常參加 MySQL使用者會議、 OSCON、 Pentaho社區等國際會議。 Roland Bouman不僅是 MySQL 5.1 Cluster Certification Guide和Pentaho Solutions兩本書的閤著者之一，也是 MySQL和Pentaho相關書籍的技術評論傢。技術博客： http:// rpbouman.blogspot.com。Twitter：@rolandbouman。

Jos van Dongen是一位著名的商業智能專傢、作傢和演說傢。他從 1991年開始從事軟件開發、商業智能以及數據倉庫等領域的工作。 Jos van Dongen曾先後就職於頂級的係統集成公司和管理谘詢公司。 1998，他創立瞭自己的谘詢公司， Tholis Consulting。他為許多商業和福利組織構建瞭 BI和數據倉庫係統。 Jos為丹麥 Database Magazine撰寫瞭新的 BI研發成果，並且經常在國內和國際會議上發言。 Jos van Dongen撰寫瞭一本關於開源 BI的書，並且和 Roland Bouman閤作編寫瞭 Pentaho Solutions。更多信息參考： http://www.tholis.com。Twitter：@josvandongen。