Title: An introduction to a free and open source ETL tool
Summary: Many database environments requires some type o data transformation. To help the transformation of data from an source to a destination we can you ETL (Extract Transform Load) tools that are designed specifically for this task. In this video we are going to see how to use a free and open source ETL tool called Kettle on Linux, which is part of the Pentaho Data Integration strategy. The video show an introduction of the Kettle user interface and explain how to create an simple transformation. In this transformation a simple text file is read and the data is moved to a table in a MySQL database.
Technologies: ETL, Kettle, Spoon
Examples built: How to use the Kettle tool to import data from a text file to a table in a MySQL database.
Keywords: Kettle, ETL, Linux, MySQL.