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."One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"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."
"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."
"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."
"We're using the PDI and the repository function, and they give us the ability to easily generate reporting and output, and to access data. We also like the ability to schedule."
"It has improved our data integration capabilities."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"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."
"The solution's customer service is good."
"WSO2's analytics capability is good, considering the ELC support they provide."
"The solution's technical support is very knowledgeable."
"It's a very complete product. It allows us to network security and add more layers of security to the system."
"Currently, I find the configuration part quite valuable, where you can easily configure things."
"The productivity is the most valuable feature. It is very easy to write remediations."
"The customer service executives are very responsive."
"The solution has two main parts: integration and transformation. It's very user-friendly and easy to understand for everyone."
"I would like to see improvement when it comes to integrating structured data with text data or anything that is unstructured. Sometimes we get all kinds of different files that we need to integrate into the warehouse."
"In terms of the flexibility to deploy in any environment, such as on-premise or in the cloud, we can do the cloud deployment only through virtual machines. We might also be able to work on different environments through Docker or Kubernetes, but we don't have an Azure app or an AWS app for easy deployment to the cloud. We can only do it through virtual machines, which is a problem, but we can manage it. We also work with Databricks because it works with Spark. We can work with clustered servers, and we can easily do the deployment in the cloud. With a right-click, we can deploy Databricks through the app on AWS or Azure cloud."
"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."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."
"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."
"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."
"I would like to see more improvements with AS400 DB2."
"They should introduce better pricing for small companies."
"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."
"I would like to see better documentation for the open-source version."
"In my opinion, the administration model and interface, of Carbon, are lacking in terms of its features and user experience."
"The customization can be a bit difficult."
"WSO2 libraries are not mature enough. For example, if you want to integrate with Kafka using its Kafka library, it often has many bugs."
"The product's price is an area of concern where improvements are required."
"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."
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, IBM Integration Bus, Oracle Service 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.