We performed a comparison between Informatica PowerCenter and Zapier based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The product's initial setup phase is very easy."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"I found the map links, work links, and workflows valuable. They are important features."
"The setup is straightforward."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Zapier is user friendly and makes it easy to integrate different tools. It has a drag and drop functionality which makes it easy to connect environments."
"Zapier’s most valuable feature is its ability to interconnect applications or devices."
"With the previous CRM we were using – the Google Ads landing pages we had – we were collecting leads manually. That process was not efficient and took a sales team a lot of time to insert these leads manually. Currently, the process is smooth and we use Zapier to collect the leads for us."
"The ability to connect web applications to trigger actions in another app after having enriched, formatted, delayed, grouped, and filtered is really valuable for many businesses."
"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."
"Zapier luckily has a wide range of integrations, I would say."
"The solution is a SaaS and does not require a complex setup."
"The most valuable feature of Zapier is it saves me time doing repetitive tasks."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The reputation of Informatica is that it is expensive."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The solution does not scale."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"At the moment, they allow a limited number of apps. I look forward to getting more apps for each package."
"Some apps are not available yet. For instance, a connection with Joomla! would be great. In general, all the most-used apps are available, but I bumped into Joomla! with a client."
"The user interface for Zapier could be improved. It also takes some time to sync the data between different environments."
"It is not worth the money if you have a little bit of a technical mind...Zapier is not able to set up different modules. When automation doesn't work, it's not that easy to find why it didn't work."
"The pricing of the solution is quite expensive."
"Zapier needs to improve in the same way most RPA solutions should, such as Robocorp, Make, or UiPath. They are not good at helping you find the connections that you need for the problem that you have. For example, if need something on Instagram. I'm going to have to do research for hours to be able to find the components or the app, which is going to do what I need it to do. It makes it difficult to use the system when you don't know what to use."
"Zapier could be a little faster, but that might not be possible. I would encourage Zapier to make more API endpoints for each application"
"It could support various languages along with Python."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Zapier is ranked 10th in Cloud Data Integration with 40 reviews. Informatica PowerCenter is rated 8.0, while Zapier is rated 8.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Zapier writes "A tool for automation purposes requiring an easy initial setup while offering a very helpful technical support team ". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Zapier is most compared with AWS Glue, Alteryx Designer, Tray.io, MuleSoft Composer and Coefficient. See our Informatica PowerCenter vs. Zapier report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.