Pentaho’s data integration solution facilitates data pre-processing: row calculation, filtering, sorting, basic string operations.
Based on these, the data can be organized, validated, and prepared for processing.
With Pentaho Data Integration (aka PDI or Kettle) software, you get a complete, full-featured ETL solution. The ETL application (Extraction-Transformation-Loading) offers an intuitive, graphical, drag-and-drop, measurable, standards-based architecture. It’s very easy to use, you don’t need any code, you can do all the activities with a graphical application where all you have to do is decide what you you want to know.