How To Export CSV to MySQL using Pentaho

There are so may ways to populate your CSV file into MySQL table. Today I will share how to do this task easily with Pentaho.

Previously I upload the csv file containing malaysia postcode here hence I will use this file as my sample for this tutorial.

1. Create new transformation (I’m assuming that you know how to open up this application)

2. Drag CSV file input to Transformation area

(more…)

Posted in SQL/ETL | 3 Comments »