Thursday, May 10, 2007

Exciting Open Source ETL - Pentaho Data Integration: KETTLE

Pentaho Data Integration delivers powerful Extraction, Transformation and Loading (ETL) capabilities using an innovative, metadata-driven approach. The intuitive, drag-and-drop design of Pentaho Data Integration increases productivity and it’s extensible, standards-based architecture ensures that you will never be forced to adopt proprietary methodologies in your ETL solutions.

What is Kellte, spoon, pan and Kitchen?

Kettle is an acronym for “Kettle E.T.T.L. Environment”. This means it has been designed to help you with
your ETTL needs: the Extraction, Transformation, Transportation and Loading of data.

Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the Kettle tools Pan (transformations) and Kitchen(jobs). Pan is a data transformation engine that is capable of performing a multitude of functions such as reading, manipulating and writing data to and from various data sources. Kitchen is a program that can execute jobs designed by Chef in XML or in a database repository. Usually jobs are scheduled in batch mode to be run automatically at regular intervals.

Pentaho Data Integration 2.5 Now Available!

This exciting new release features ehanced MySQL support, advanced error handling, support for the Apache Virtual File System, and numerous usability improvements.

Project URL : http://www.pentaho.com/index.phpDownload : https://sourceforge.net/project/showfiles.php?group_id=140317&package_id=186321

No comments: