No more typing reviews! Try our Samantha, our new voice AI agent.

Informatica Intelligent Data Management Cloud (IDMC) vs Merge comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 15, 2026

Review summaries and opinions

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

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Integration Platform as a Service (iPaaS)
2nd
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
215
Ranking in other categories
Data Integration (1st), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (1st), API Management (6th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (2nd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (1st)
Merge
Ranking in Integration Platform as a Service (iPaaS)
17th
Average Rating
8.0
Reviews Sentiment
2.2
Number of Reviews
2
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2026, in the Integration Platform as a Service (iPaaS) category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 5.3%, up from 4.9% compared to the previous year. The mindshare of Merge is 1.2%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Integration Platform as a Service (iPaaS) Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)5.3%
Merge1.2%
Other93.5%
Integration Platform as a Service (iPaaS)
 

Featured Reviews

RC
Contractor at Sanlam
Cloud data catalog has streamlined lineage and quality while leaving more automation to improve
I have not explored IDMC's automation capabilities driven by AI and metadata too much at the moment, but it is on the cards. We are basically creating the foundation, as the whole migration has taken place recently and it is still early days. I think Informatica Intelligent Data Management Cloud (IDMC) is evolving, and as the vendors move forward, they pick up new concepts from each other. I have seen that products leapfrog each other, and from my experience over the years, the big players tend to copy features or add enhancements based on industry trends. I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team. It is difficult to say what additional features I would prefer to see in the next release of IDMC. I would appreciate more automation on the lineage front, with more AI to seamlessly join independent sources and create seamless lineage between different technologies, such as from file into database A into a different database and landing up in a reporting system such as Cognos, Qlik, Qlik Sense, QlikView, or Power BI.
SA
Principal Data Engineer at a financial services firm with 10,001+ employees
Merge has streamlined change data capture and supports cost‑effective ELT hiring flexibility
Regarding optimization, I have observed that on the Snowflake side, with Merge being used on a table that has micro partitions and has been well maintained, the statement execution will be very fast. This helps in both cost savings and performance-wise optimization. It would be beneficial if there is a common public community so that people who may not be aware of this will become more aware. Additionally, when we do joins within the Merge statement, there is always a chance of getting duplicates. Snowflake added a feature called QUALIFY that allows us to filter based on ranking and eliminate duplicate records. If such a feature were available in regular Merge statements within any database, that would be helpful. This would eliminate the need to rebuild another subquery inside the Merge statement.

Quotes from Members

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

Pros

"It's probably one of the leading lights in ETL."
"The MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."
"I rate the solution's scalability a ten out of ten."
"The reusability factors are nice. The Cloud Data Quality is much better. A major flaw in the previous version was integration with the catalog, which is now seamless."
"There isn't any human touch involved. It's just an automated business process to build different applications and talking to various APIs using the client's ecosystems. We then build new functionalities out of it."
"The feature I found most valuable in Informatica Intelligent Cloud Services is the mapping; you just drag and it maps the data, so mapping is very easy and it's no code."
"The most valuable features of Informatica MDM are it is cloud-enabled and has all the elements that are supposed to have in terms of MDM as a solution. All the features that are there. It is very well-integrated with any of the SAP and non-SAP applications. It is quite user-friendly. The user experience that you receive in Informatica MDM is quite good."
"The valuable features include ease of use and quick response time with Informatica Intelligent Cloud Services; the performance and response time are notably faster."
"One significant advantage is the ability to go with open source and not depend on proprietary ETL tools, which saves licensing costs and allows me to hire broadly for common SQL and data warehousing skills instead of niche tool expertise."
"Merge has positively impacted my organization by being extremely useful and allowing me to review multiple files at increased speed."
 

Cons

"The downside of this solution is that the UI is terrible and not user-friendly."
"We would like to have accessibility to the repository."
"The setup is complex."
"The tools required to migrate existing mappings and server rules through cloud data quality are not available."
"Mainly, MDM requires improvement when you need to migrate your version to a later one -- because it is very difficult and takes a lot of time to convert the processes you have already developed and implemented on a previous version, and can cause a need to rework the processes."
"Pre-sales technical support is much better than post-sales technical support."
"I would like to see support for more data sources."
"They have too many diversified products. If you don't know Informatica, it's very confusing and feels very idiotic."
"Merge could be improved in terms of scriptability, as I recall it was not as strong as Beyond Compare in this regard."
"Additionally, when we do joins within the Merge statement, there is always a chance of getting duplicates."
 

Pricing and Cost Advice

"The price is high, but the competitors are even higher, like Collibra."
"I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price."
"The solution is expensive."
"In terms of the licensing for Informatica Intelligent Cloud Services, we had the option of paying based on the number of users and paying based on the volume of data, and we went with the data volume licensing option. Informatica Intelligent Cloud Services isn't as expensive as CIG. The pricing for it is okay, so I'm rating it a four out of five in terms of pricing. We did use the email verification and address validation services which weren't part of the contract, so we had to pay additional fees for those services."
"It's a costly solution"
"Cost-wise, I think it is on the higher side, and that is why we are looking for some better options. Licensing costs are huge compared to other players in the market and for my company."
"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."
"It is an expensive solution. I would say it is the most expensive solution in the market."
Information not available
report
Use our free recommendation engine to learn which Integration Platform as a Service (iPaaS) solutions are best for your needs.
902,988 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Manufacturing Company
11%
Construction Company
7%
Computer Software Company
6%
Consumer Goods Company
20%
Financial Services Firm
16%
Construction Company
8%
Comms Service Provider
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
No data available
 

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 transformations, allowing users to apply transformations either in code by using Power Q...
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 real data governance strategy. Additionally, PowerCenter is able to manage huge...
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 reduction by integrating data on any cloud in various ways Effective integration ...
What needs improvement with Merge?
Merge could be improved in terms of scriptability, as I recall it was not as strong as Beyond Compare in this regard.
What is your primary use case for Merge?
My main use case for Merge is in adding infrastructure in GitHub. A specific example of how I use Merge for adding is that we are creating infrastructure resources by Terraform. After that, we clon...
What advice do you have for others considering Merge?
My advice to others looking into using Merge is that if someone is considering Merge, then they should use this tool because it is very helpful. It will save time and effort in uploading a task and...
 

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
No data available
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Information Not Available
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Merge and other solutions. Updated: June 2026.
902,988 professionals have used our research since 2012.