We performed a comparison between CloverETL and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."No dependence on native language and ease of use."
"Connectivity to various data sources: The ability to extract data from different data sources gives greater flexibility."
"Key features include wealth of pre-defined components; all components are customizable; descriptive logging, especially for error messages."
"Server features for scheduler: It is very easy to schedule jobs and monitor them. The interface is easy to use."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"It's very simple compared to other products out there."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."
"The abstraction is quite good."
"The solution has a free to use community version."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"Its documentation could be improved."
"Resource management: We typically run out of heap space, and even the allocation of high heap space does not seem to be enough."
"Needs: easier automated failure recovery; more, and more intuitive auto-generated/filled-in code for components; easier/more automated sync between CloverETL Designer and CloverETL Server."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"If you develop it on MacBook, it'll be quite a hassle."
"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."
"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."
"I would like to see more improvements with AS400 DB2."
"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Earn 20 points
CloverETL is ranked 61st in Data Integration while Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews. CloverETL is rated 7.0, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of CloverETL writes "Provides wealth of pre-defined, customizable components, and descriptive logging for errors". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". CloverETL is most compared with SSIS, Talend Open Studio and iWay Universal Adapter Framework, whereas Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. See our CloverETL vs. Pentaho Data Integration and Analytics report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.