Pentaho Kettle Solutions and over 2 million other books are available for Amazon Kindle . Learn more
FREE Delivery in the UK.
Only 2 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Pentaho Kettle Solutions:... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by momox co uk
Condition: Used: Good
Comment: Please allow 1-2 weeks for delivery. For DVDs please check region code before ordering.
Trade in your item
Get a £4.07
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration Paperback – 24 Sep 2010

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£17.69 £16.29
£33.99 FREE Delivery in the UK. Only 2 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Special Offers and Product Promotions

  • When you trade in £15 or more you’ll receive an additional £5 Gift Card for the next time you spend £10 or more.

Frequently Bought Together

Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration + Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL + Pentaho Data Integration 4 Cookbook
Price For All Three: £95.97

Buy the selected items together

Trade In this Item for up to £4.07
Trade in Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration for an Amazon Gift Card of up to £4.07, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 720 pages
  • Publisher: John Wiley & Sons; 1 edition (24 Sept. 2010)
  • Language: English
  • ISBN-10: 0470635177
  • ISBN-13: 978-0470635179
  • Product Dimensions: 18.7 x 3.7 x 23.5 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 545,614 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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

About the Author

Matt Casters is Founder of Kettle and works as Chief Data Integration at Pentaho, where he leads Kettle software development. Roland Bouman is an application developer focusing on open source web technology, databases, and business intelligence. Jos van Dongen is an independent business intelligence consultant and well–known author, analyst, and presenter.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

2 of 2 people found the following review helpful By Mr. Jonathan Levin on 21 Sept. 2012
Format: Paperback
This book is very thorough and clear. It not only explains how to use Pentaho's data integration tool called Kettle, but it also does a very good job explaining data warehousing principles as well.

While reading this book, I have to say that I found the information about what I may or may not encounter in my data warehouse project to be useful and somewhat comforting.

All in all, it explains how the tool works quite clearly and how you may need to use it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 12 reviews
7 of 8 people found the following review helpful
It's in the book 1 Nov. 2010
By Doug Moran - Published on
Format: Paperback Verified Purchase
I wanted to do this review much sooner but I've been too busy using the book.

Jos and Roland have taken the proven formula they used in Pentaho Solutions and focused it on ETL and Kettle, AKA Pentaho Data Integration. Their magic formula is to seamlessly mix a product users guide with equal parts of real world examples and best practices training. With the addition of Matt Casters, Mr Kettle himself, the depth of knowledge in the book is now equal to it's breadth. The result is a book that you can read cover to cover and learn about all aspects of building and deploying ETL solutions, and is equally useful as a day to day reference.

The book is divided into five parts starting with an obligatory Getting Started. Getting Started, however, goes beyond the traditional "here's how to install it guide" and presents a nice tutorial on the sometimes confusing terminology and practices used in the data world. It explains how Kettle fits into this world and talks about the key concepts in Kettle. The first part ends with an excellent example ETL solution to populate a non trivial yet easily understood star schema. The example covers fact and dimension tables, change data capture, generating date dimensions and the ETL jobs and transforms required to populate the data.

The organization of the second part of the book is based on the 34 subsystems of ETL as defined by Ralph Kimball in "The Data Warehouse Lifecycle Toolkit", considered by many (including me) as the bible of data warehousing. For each subsystem, Kettle Solutions refers to the original chapters that describe the topic and provides examples on how to solve those issues using Kettle. It is a must have for anyone struggling with the concepts presented in the Kimble book. For the rare cases that Kettle does not have a straight forward solution, the book points you to other open source software that can get the job done. The authors stay true to the task of helping the ETL developer solve real problems regardless of whether Kettle is the complete solution or not.

The first two parts take up about half the book and if the authors stopped there, it would be worthy of at least 4 stars. But like most software development, the base code (in this case, the jobs and transforms) are the easy part and usually the most fun. The real hard stuff comes when you have deploy your solution into the real world, keep it running, add new capability, explain it to others and be confident that it is actually working. Part three walks you through the ETL lifecycle with best practices and pitfalls by 3 people who do (or have done) this for a living. Everything is covered from development and testing through documentation, monitoring, migrating and auditing. Part four finishes what part 3 started by covering performance tuning and scaling with topics like clustering, partitioning, cloud and real time ETL.

The last part is my favorite since it covers the advanced stuff like writing Kettle plugins, complex data formats, integrating data from web services, dynamic ETL, embedding Kettle, etc. There are many ways to extend Kettle via defined APIs and Kettle Solutions covers them all.

As you can probably tell I like the book and I use it often. I have the luxury of being able to ask Matt questions when I run into trouble. After writing the book, he now answers "it's in the book" and needless to say, it is. I can honestly say, having this book sitting on your desk is better than having Matt sitting on your desk. Kettle Solutions is also available for Kindle which, much to my surprise, has proven very useful. I use it from my iPhone and Mac via Kindle app and despite some of the Kindle app limitations like cut and paste and a good search, it is always available as a reference. The links are live which is a bonus.

I'm a fifteen year veteran of building BI software, one of the original Pentaho developers and am currently the Pentaho community guy. I work with Matt Casters, I'm not professionally affiliated with Jos, Roland or Wiley and receive no benefit from this book beyond the satisfaction of having Pentaho software be so well represented. I do consider all three of them good personal friends and I provide this review with the risk that it may greatly inflate their heads.

Doug Moran
2 of 2 people found the following review helpful
Already Out of Date 7 Feb. 2013
By Stephanie Dozier - Published on
Format: Paperback Verified Purchase
The book is great the problem is that Pentaho has placed updates out for their product too frequently so now this book is no longer current.
1 of 1 people found the following review helpful
John 17 Jan. 2013
By John W Ballment - Published on
Format: Paperback Verified Purchase
While I haven't read this book end-to-end (and never planned to), it is my main reference for everything to do with PDI.

Everyone who is developing in PDI should have this book sitting beside them.
1 of 1 people found the following review helpful
Hands on 17 Jun. 2011
By VL - Published on
Format: Paperback Verified Purchase
Excellent book, very much hands on, if you are sceptical about using this amazing open source ETL solution (or any sustainable open source for that matter) this book will surely put you at ease...
A must read BI Book ! 21 Dec. 2010
By Vincent Teyssier - Published on
Format: Paperback
Recently, I received my own review copy of a long awaited Pentaho book : Pentaho Kettle Solutions - Building Open Source ETL Solutions with Pentaho Data Integration.

The first book, Pentaho Solutions, was aimed at discovering the basics of BI and Pentaho usage. Now, with this new book, we go deeper into hardcode dataprocessing and datawarehousing using Kettle. But it is not exclusively focused on Kettle : a strong emphasis is placed on data processing basics, technics and theory (Codd vs Kimbal ...). Reading this book will get you to the next upper level on these two topics :

* Data processing and how to build / feed a datawarehouse,
* Kettle development, customization and advanced usage.

This book is a fantastic concentration of knowledge. You will learn from ETL basics, advanced topics, performance management, Kettle development and cloud dataprocessing. Matt, Roland and Jos met a risky challenge : writing a book that do the splits from basic knowledge to high level technics while staying focused on how to use Kettle to solve actual and concrete data problems.

They succeeded.

This book is now sitting on my reference BI shelf, it entered my personal BI Book Hall of Fame.
Were these reviews helpful? Let us know