We performed a comparison between Pentaho Data Integration and Analytics and Workato 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'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."
"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."
"The solution has a free to use community version."
"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."
"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."
"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."
"It's my understanding that the product can scale."
"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."
"It is very easy to use. It takes complex workloads away, and it provides very smooth integration. It has got a lot of out-of-the-box connectors. It has got a lot of out-of-the-box APIs, which makes it really easy to integrate with applications for different use cases, whether it is in finance, HR, or customer operations. It is by far our favorite integration product."
"Their automation and workflows are very strong, and you can build the workflows very easily and quickly."
"Stability-wise, I rate the solution a ten out of ten."
"It is easier to use than other technical open-source technologies."
"It's easy to understand, makes flows and is efficient."
"The most valuable features are easy integration, quick tab to develop, quick tab to market, and interactive integration platform."
"Workato is low code, intuitive, and easy to use."
"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."
"I could not connect to our Hadoop environment in an easy and flexible way, and it was important to scale our data warehouse."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"The product needs more plugins."
"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."
"I'm still in the very recent stage concerning Pentaho Data Integration, but it can't really handle what I describe as "extreme data processing" i.e. when there is a huge amount of data to process. That is one area where Pentaho is still lacking."
"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."
"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."
"A limitation is that their cloud presence is only in North America and Europe."
"From the deployment point of view, our customers encounter platform downtime where it does not serve the actual request on the systems."
"Workato's Extract, transform, and load (ETL) and extract, load, and transform (ELT) are not very strong and could be improved for very complex transformations."
"The management dashboard in the solution is an area with shortcomings that needs improvement."
"I would like to see the dashboarding and reporting processes improved."
"The only minor drawback would be if there was a UI at the front of it, for apps and for a portal as well, it would make it really easy. It would be really useful if there were more apps capabilities."
"It is tedious to make a tailor-fit function."
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Pentaho Data Integration and Analytics is ranked 15th in Data Integration with 48 reviews while Workato is ranked 8th in Integration Platform as a Service (iPaaS) with 9 reviews. Pentaho Data Integration and Analytics is rated 8.0, while Workato is rated 8.4. 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 Workato writes " Great automation and strong workflows useful for integration". Pentaho Data Integration and Analytics is most compared with SSIS, Azure Data Factory, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue, whereas Workato is most compared with Microsoft Azure Logic Apps, MuleSoft Composer, Azure Data Factory, Oracle Integration Cloud Service and Alteryx Designer. See our Pentaho Data Integration and Analytics vs. Workato report.
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.