It consists of four distinct applications (tip: follow links for relevant. Kettle is built with the java programming language.
frequently (typically on a daily basis) store data (loading) in the final target destination, which is usually a large, dimensionally modelled database called a data warehouseĪlthough most of these concepts are equally applicable to almost any data importing or exporting processes, ETL is most frequently encountered in datawarehousing environments. move and modify data (transport and transform) while cleansing, denormalizing, aggregating and enriching it in the process. collect data from a variety of sources (extraction). Although there's a growing number of contributers, a lot of the work on Kettle is still being done by Matt himself.īeing an ETL tool, Kettle is an environment that's designed to: Matt's now working for Pentaho as Chief of Data Integration. Kettle was first conceived about four years ago by Matt Casters, who needed a platform-independant ETL tool for his work as a BI Consultant. The product name should actually be spelled as K.E.T.T.L.E, which is a recursive acronym for "Kettle Extraction, Transport, Transformation and Loading Environment". Kettle is a free, open source (LGPL) ETL (Extraction, Transformation and Loading) tool. (In fact, I just noticed that the welcome screen of the latest development release now announces itself as "Pentaho Data Integration - Previously Kettle").Īnyway, back to Kettle. Right now, the Pentaho developers are busy integrating Kettle with the rest of the platform, and probably sooner than later, the services that are now provided by Kettle will be known as 'Pentaho Data Integration'. 
Pentaho also bundles the components and provides the framework to let them work together.
The same goes for Kettle, which was actually acquired by Pentaho. Pentaho actively contributes and strives to improve some of these existing components, for example, JFreeReport. For example, the reporting layer runs JasperReports, BIRT (discussed in one of my earlier blog entries) and JFreeReport, OLAP Services are provided by Mondrian, and one of the core components, the Workflow engine, is the Enhydra Shark Engine. I didn't mention this in my previous blog entry, but most of Pentaho is built on and from existing components rather than developed from scratch. Huh? Kettle!? I thought you said Pentaho?! In case you're interested in Pentaho in general: I just heard that on 21 june, MySQL will be conducting a Web-seminar on BI with Pentaho and MySQL, so you might want to register. In this blog entry, I will focus on some features of the latest addition to the Pentaho: K.E.T.T.L.E, which forms the principal ETL component of the platform. Well, I've only done a little bit of all the checking out I planned to do, but here I'd like to present some of the things that I found out so far.
In my previous blog entry, I wrote about how I'm currently checking out the Pentaho open source Business Intelligence platform.
0 kommentar(er)
