Try our new research platform with insights from 80,000+ expert users

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerExchange vs Zapier comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
7.1
Informatica IDMC enhances data quality, efficiency, and analytics, offering secure integration and reduced cloud migration costs for businesses.
Sentiment score
7.9
Informatica PowerExchange enables smarter decisions, streamlines data pipelines, and saves costs, showing ROI within weeks for digital transformation.
Sentiment score
6.1
Users experience benefits from Zapier's automation and cost savings, though calculating specific ROI can be challenging.
We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
In a scenario where employing three resources for three months might cost approximately $18,000 to $20,000, Zapier provides substantial cost savings.
 

Customer Service

Sentiment score
6.9
Informatica's customer service is praised for quick, knowledgeable support, though response times can vary with customization and membership levels.
Sentiment score
7.1
Informatica PowerExchange support is seen as knowledgeable but receives mixed reviews due to varying response times and availability.
Sentiment score
7.0
Mixed experiences with Zapier support: praised for responsiveness and knowledge, yet some note delays and lack of chat.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
The response time is pretty good because we have someone in-house, who is an expert from Informatica, in our team who can help us with any sort of queries usually.
If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
Their technical support is good; they respond promptly and are very helpful.
This can help if you need assistance, as you can communicate with the community and support system, and most issues are already resolved by AI.
Sometimes, in my early days, when I was stuck with something, they helped me solve these issues, and even helped me solve some of my automations.
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC delivers scalable, flexible data management across cloud and on-premise environments, accommodating diverse enterprise needs efficiently.
Sentiment score
7.0
Informatica PowerExchange offers robust scalability for diverse sources and transformations, suitable for medium to large data environments.
Sentiment score
7.4
Zapier is ideal for small businesses prioritizing simple tasks, though costs and stability may concern larger organizations.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.
Zapier is suitable for small or simpler automation but not for complex ones.
Scaling it gets quite expensive, and while I cannot evaluate it purely from a technology perspective, compared to Workato, I would give Zapier a seven for scalability.
 

Stability Issues

Sentiment score
7.7
Informatica Cloud is highly rated for stability, despite occasional issues; support effectively resolves any reported bugs.
Sentiment score
7.7
Informatica PowerExchange is praised for stability despite some issues with resource load, visibility, and log maintenance in newer versions.
Sentiment score
6.7
Users find Zapier reliable, with minor issues often linked to third-party tools, and rate stability highly for varied needs.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
In my current company, we had significant challenges with Zapier regarding maintenance, as Zaps were often broken, not necessarily due to Zapier, but due to changes in the input variables.
 

Room For Improvement

Informatica IDMC requires improvements in integration, user interface, performance, support consistency, connectivity, automation, data tagging, and pricing.
Informatica PowerExchange needs better integration, user-friendliness, real-time processing, cloud features, and affordability while addressing performance and support challenges.
Zapier users face issues with Google Sheets, insufficient integrations, complex workflows, high costs, and limited customization and support.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
The error message options in the dashboard should be improved. It should be user-friendly so that beginners or non-technical users can figure out the problems and solutions on their own.
You can build similar or dependent automations in one Zap, which helps with understanding the process without switching between different records.
I would appreciate if there would be a feature where we can use actions right after loops. Currently, you cannot use any other action after the loop. Everything needs to be within the loop.
 

Setup Cost

Informatica IDMC, a costly solution for large enterprises, offers extensive features and flexibility, justifying its premium pricing.
Informatica PowerExchange pricing depends on capacity, with variable costs based on usage, but offers moderate cost-efficiency.
Enterprise buyers find Zapier cost-effective for its integrations, despite some viewing it as pricier than alternatives.
It ranges from a quarter million to a couple of million a year.
The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing is in accordance with market standards and even lower in some cases.
The pricing of Zapier is slightly higher compared to other market automation tools such as Pabbly, Make.com, and N8N, which have good features but are priced lower than Zapier.
 

Valuable Features

Informatica IDMC excels in data management with strong integration, AI-driven analytics, and a flexible user interface.
Informatica PowerExchange is lauded for versatile data integration, real-time capabilities, scalability, and support for diverse data sources and formats.
Zapier offers over 20,000 integrations, automating workflows without coding, enhancing productivity with user-friendly, drag-and-drop functionality.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
They have approximately 7,000 connections.
Even a person with no technical knowledge can use Zapier to create automations.
The automation capabilities are impressive.
 

Featured Reviews

SaurabhGaonshindhe - PeerSpot reviewer
Modular structure and AI features stream new reporting processes
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach. My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, for products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point.
Mohammad Faizan Ahmad - PeerSpot reviewer
Helpful in handling areas like complex data sources and data processing but needs improved support services
The major challenge with the tool stems from the fact that if you are implementing it in the cloud, then it has to be within the framework. Another challenge is the large volume of data. Informatica PowerExchange is a product through which we enable connectivity, so it is not an application product or a stand-alone tool, but Informatica's core systems or IICS uses it to connect to multiple systems. The major challenge associated with the tool is on the infrastructure side. The tool's features could be something faster with more connectors. A number of connectors can help connect to a wide variety of applications. The tool should focus on reducing the resilient time, like, if any network disconnectivity happens, then auto-reconnection and the retry method should be more robust so that manual intervention is not required. We communicate with the tool's support team as we need to raise our issues with them. I have already worked with Informatica and have a total experience of around eight to nine years; the one problem with the tool is its support team since they take a lot of time to address a particular issue. If one time you schedule a call and explain the situation to them about the issue, the support team will raise tickets and take notes. They will ask you to share the logs or screenshots of the errors, and you will get no resolution. The support team will randomly give you some documents and expect you to go through them, and if you get back to them with questions, a new person will be allocated, and you will have to start explaining everything again. I would not say it is a pleasant experience.
Sachin Shrtivastava - PeerSpot reviewer
Automation of simple tasks improves with user-friendly interface but needs enhancement in handling complex scenarios
In my opinion, what could be improved in Zapier is its UI, which operates as a one-line system. Compared to Make.com and other tools that have a drag-and-drop system, this is lacking. If the scenario or automation is complex, it becomes difficult to create and deploy because of various routes. For example, with 20 routes, it becomes really difficult to create them due to certain limits, and the UI is not conducive for viewing all the routes.
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
868,654 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
10%
Manufacturing Company
10%
Insurance Company
7%
Financial Services Firm
27%
Computer Software Company
8%
Government
7%
Insurance Company
7%
Financial Services Firm
9%
Computer Software Company
9%
University
8%
Retailer
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business42
Midsize Enterprise24
Large Enterprise134
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise3
Large Enterprise12
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise10
Large Enterprise7
 

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transfor...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead r...
What is your experience regarding pricing and costs for Informatica PowerExchange?
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed, enabling re-utilization ...
What needs improvement with Informatica PowerExchange?
It would be helpful to have more metadata provided, which is useful for engaging more users in data exchange. The add...
What do you like most about Zapier?
The product's most valuable feature is automation.
What is your experience regarding pricing and costs for Zapier?
The pricing is in accordance with market standards and even lower in some cases. The license setup cost is reasonable.
What needs improvement with Zapier?
In my opinion, what could be improved in Zapier is its UI, which operates as a one-line system. Compared to Make.com ...
 

Also Known As

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
PowerExchange, Connectors
No data available
 

Overview

 

Sample Customers

The Travel Company, Carbonite
ACH Food, BNSF Railway Company, Illinois State University
BuzzFeed, Groupon, Spotify, Columbia University, FOX
Find out what your peers are saying about Amazon Web Services (AWS), Informatica, Salesforce and others in Cloud Data Integration. Updated: September 2025.
868,654 professionals have used our research since 2012.