We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The solution has a free to use community version."
"The amount of data that it loads and processes is good."
"Pentaho Data Integration is quite simple to learn, and there is a lot of information available online."
"We find it effortless to set up. We really don't have to do anything other than finding the application in the Zapier catalog. And as long as the application has been re-integrated into Zapier, they're able to then just provide the connection details and hook it up."
"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 would like to see improvements made for real-time data processing."
"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."
"System-to-system is fine, but when it comes to system-to-user, where Zapier is helping to communicate to a user, that's a one-way communication. If that user has to perform some action on that notification, the action isn't handled by Zapier. So there's no way to orchestrate that and it's very cumbersome."
"The price of the regular version is not reasonable and it should be lower."
"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."
"It's very straightforward licensing. There's only one cost you have to pay, and if you want a relevant pricing plan, I think you have two or three different models or packages which include the number of notifications or Zaps, as they call it, that you can program."
Pentaho data integration prepares and blends data to create a complete picture of your business that drives actionable insights. The complete data integration platform delivers accurate, "analytics ready" data to end users from any source. With visual tools to eliminate coding and complexity, Pentaho puts big data and all data sources at the fingertips of business and IT users alike.
Zapier is a tool for primarily non-technical users to connect together web apps.
An integration between two apps is called a Zap. A Zap is made up of a Trigger and one or more Actions or Searches.
Whenever the trigger happens in one app, Zapier will automatically perform the actions or searches in another app in order.
Zaps are very lightweight and easy to set up. Zaps do not import or export old data (they only operate on new items created after the Zap is enabled). Zaps are also not kept in sync ("two way syncing") after the Zap is triggered.
Zaps are deceivingly simple if you're used to dealing with complex and difficult integrations. Their simplicity is what enables anyone to create them.
Pentaho Data Integration is ranked 16th in Data Integration Tools with 3 reviews while Zapier is ranked 10th in Cloud Data Integration with 1 review. Pentaho Data Integration is rated 7.6, while Zapier is rated 8.0. The top reviewer of Pentaho Data Integration writes "Free to use, easy to set up, and has a great metadata injection feature". On the other hand, the top reviewer of Zapier writes "Streamlines our system-to-system task automation at the scale we need". Pentaho Data Integration is most compared with Talend Open Studio, SSIS, Informatica PowerCenter, Oracle Data Integrator (ODI) and IBM InfoSphere DataStage, whereas Zapier is most compared with Workato, AWS AppSync, Matillion ETL, Tray.io and Mule Anypoint Platform.
See our list of best Data Integration Tools vendors.
We monitor all Data Integration Tools 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.