- It has a nice GUI that anyone can learn to use in just a few days with minimal training.
- It has great support for big data technologies; Pentaho 5.3 comes with support for HBase, Pig, Oozie, and Hadoop distribution support.
The rule executor step can be improved. It has one limitation: we cannot give it a dynamic file name in this step.
I've used it for 4.5 years.
We've had no issues with deployment.
We've had no issues with stability.
We've had no issues with scalability.
We used MSBI and we switched to Pentaho Data Integration and it has saved us lot of money and time.
For Pentaho, the initial setup is very straightforward.
We did it in-house.
Because it's open source, there's no issue of pricing or licensing.
Use if for any data warehousing and migration projects. I love this tool and we can use it without spending a penny.
I would say this is the best ETL tool in the market, considering this is open source and ease to use, very nice GUI.