Kettle's Regex Sample

Kettle (Pentaho Data Integration) is a very popular open source ETL tool. Built on Java platform, it can run in multiple OS such as Windows, Linux, Mac, and other Unix based platform.

Regular expression is a powerful construct to manipulate any text and is supported in Java language. With the capability of Regex evaluation step and Java scripting in Kettle, I give a simple example on how to read an "unstructured" log file and make it tabular using the steps.

Get the sample transformation file from this wiki page.

Mondrian: MySQL Sakila's cube

Sakilla is a movie rental sample database provided by MySQL. This database is very suitable to demonstrate the use of Pentaho's tools in various way.

For this purpose I'll create a series of article showing the use of this database with Mondrian and Kettle. To begin with, here I will show how to get this sample database, creating a very basic cube definition and how to query it - all without altering the underlying data.

See our complete wiki article here.

Halogen Wiki Page

Halogen is an olap client viewer based primarily on OLAP4J and Google Web Tookit (GWT).

Halogen has several features :

• The ability to connect to Mondrian's cube
• Visually add dimension and measures from a chosen cube
• Execute MDX query
  
• Graphical Chart
  

To assist anyone who want to have a try on this application, we have created a non official wiki for Halogen. You can visit the site by clicking on the image below or on this link.

PDI Sample Screencast

Kettle / Pentaho Data Integration is now one of the most used open source ETL tool in the market.

With increasing inquiries on this product, I make this screencast that shows how to design and execute a very simple Kettle task to migrate one or two tables from SQL Server to MySQL (annotations are in Indonesian).

Have you had any further question or inquiry on this product, you can contact me directly at feris@phi-integration.com.
ke