Pentaho an etl tool for bussiness
What do you like best about the product?
Pentaho is one of the best etl tool to extract ,transform and load the data among various sources ,it just requires connections of the database and transfers data very fast .it also executes sql and generates reports into excel or any other required source.it has all basic components like execute sql,table input,excel input ,excel output,txt output,hdfs output.
What do you dislike about the product?
Pentaho job runs fast but modifying a job is time consuming ,it is usually so slow.better if it fast like any other application and also required some tutorials from pentaho side.
What problems is the product solving and how is that benefiting you?
It usually best to transfer huge data from one source to another like oracle to hue.It is best to generate reports into excel using sql queries.