We performed a comparison between Pentaho Data Integration and Analytics and WSO2 Enterprise Integrator 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."We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."
"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."
"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."
"Lumada has allowed us to interact with our employees more effectively and compensate them properly. One of the cool things is that we use it to generate commissions for our salespeople and bonuses for our warehouse people. It allows us to get information out to them in a timely fashion. We can also see where they're at and how they're doing."
"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."
"The abstraction is quite good."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"The productivity is the most valuable feature. It is very easy to write remediations."
"It's a consolidated product. It works and it does its job pretty well."
"The solution's technical support is very knowledgeable."
"The solution's customer service is good."
"The stability is excellent."
"WSO2's analytics capability is good, considering the ELC support they provide."
"Currently, I find the configuration part quite valuable, where you can easily configure things."
"The installation process is easy."
"I would like to see improvements made for real-time data processing."
"One thing that I don't like, just a little, is the backward compatibility."
"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."
"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."
"I have been facing some difficulties when working with large datasets. It seems that when there is a large amount of data, I experience memory errors."
"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."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."
"There are a lot of security settings that when you apply you have to re-apply again every time you modify a setting. It is something that really needs to be enhanced."
"The setup can be difficult for those not familiar with the solution."
"The administration side is complex and could use significant improvements to enhance the solution's functionality."
"In my opinion, the administration model and interface, of Carbon, are lacking in terms of its features and user experience."
"The integration capabilities need to be improved."
"The micro integrator should be improved. There is room for enhancement considering alternative integration components."
"One of the reasons that we are looking for a replacement is their way of defining integration. The language of the XML structures that I use to describe the integrations are not that standard, and it's not easy to find people who are familiar with this approach."
"If I have to buy software, then it becomes expensive for me."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews while WSO2 Enterprise Integrator is ranked 19th in Data Integration with 18 reviews. Pentaho Data Integration and Analytics is rated 8.0, while WSO2 Enterprise Integrator is rated 7.6. The top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". On the other hand, the top reviewer of WSO2 Enterprise Integrator writes "Consolidated, reliable, and has responsive technical support". Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue, whereas WSO2 Enterprise Integrator is most compared with Red Hat Fuse, Oracle Service Bus, IBM Integration Bus, webMethods Integration Server and Mule ESB. See our Pentaho Data Integration and Analytics vs. WSO2 Enterprise Integrator 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.