What is most valuable?
- Pentaho Kettle has a very intuitive and easy to use graphical user interface (GUI)
- It is possible to understand how to develop an ETL solution even when using it for the first time
- The Community Edition is free and very efficient
- They have versions for Windows, Linux and Mac
- Large selection of options.
How has it helped my organization?
We have developed some complex ETL processes for some clients and they are very satisfied with the results.
What needs improvement?
They could improve the logging generator. Sometimes the error description is so generic that it is not possible to detect the problem.
For how long have I used the solution?
We've used it for three years.
What was my experience with deployment of the solution?
There were no issues with the deployment.
What do I think about the stability of the solution?
There were no issues with the stability.
What do I think about the scalability of the solution?
There have been no issues scaling it.
How are customer service and technical support?
I use the Community Edition without support or customer service. I recommend the Pentaho Community Forums for technical issues.
Which solution did I use previously and why did I switch?
I have used Informatica PowerCenter, which is an excellent solution. However, it´s not so easy to use as Pentaho kettle.
How was the initial setup?
The initial setup is straightforward. All you need to do is to download it, unzip the file into a folder and execute the Spoon.bat (for Windows) or Spoon.sh (for Linux) to start the graphical user interface (GUI).
What about the implementation team?
In-house. The implementation is very simple. Data developers will not encounter difficulties to implement ETL solutions.
What's my experience with pricing, setup cost, and licensing?
The community edition is free. If you need a full BI solution, I would recommend the enterprise edition.
What other advice do I have?
Pentaho Kettle is an excellent solution to implement ETL process.