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

Informatica Intelligent Data Management Cloud (IDMC) vs erwin Data Modeler comparison

Why PeerSpot?
 

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:
 

ROI

Sentiment score
5.0
erwin Data Modeler enhances productivity and consistency, saves costs, and supports complex designs through automation and improved collaboration.
Sentiment score
6.5
Informatica Cloud enhances data management ROI through analytics and efficiency, but benefits vary with adoption and tool preference.
If three engineers save ten hours each per month using erwin Data Modeler versus manual modeling, that equals three hundred sixty hours saved per year.
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
It replaces manual charting in Visio with a structured tool, providing significant return on investment.
Data Architect at a energy/utilities company with 10,001+ employees
If the modeling is compromised, then the entire structure will be compromised.
Senior Data Architect at a computer software company with 1,001-5,000 employees
Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
The stability and performance remain issues.
consultant at a energy/utilities company with 5,001-10,000 employees
Compared to Collibra Catalog, where the value is noticeable within six months.
Data and Analytics Manager at a insurance company with 10,001+ employees
 

Customer Service

Sentiment score
5.6
Erwin Data Modeler's customer service is responsive and efficient, though complex issues may need additional follow-ups.
Sentiment score
6.8
Informatica IDMC offers strong customer service, with variability in response times and support quality based on issue priority.
Customer support for erwin Data Modeler is excellent, providing easy access and quick issue resolution via calls.
Senior Data Modeler at a tech vendor with 1,001-5,000 employees
The quality and speed of their support are excellent; everyone is very helpful, and they can solve problems quickly.
Senior Data Scientist at a consultancy with 10,001+ employees
This rating reflects my ability to effectively utilize the tool and get support for licensing issues, installation errors, or corrupted repositories end-to-end.
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
Consulting Principal & Founder at Digital Data Consultancy
Even after going out of service support, they still reached back to me whenever I raised tickets.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
We expect more responsive assistance because they have the expertise since Informatica is their tool, but I don't see enough expertise on the Informatica support side.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
 

Scalability Issues

Sentiment score
6.4
Erwin Data Modeler excels in scalability and multi-user capabilities, efficiently managing complex schemas with continuous improvements for diverse tasks.
Sentiment score
7.3
Informatica IDMC is highly scalable and adaptable, catering to enterprise-level tasks with flexible cloud-based architecture.
I would rate it probably a nine, making it a leader in data modeling.
Data Architect at a energy/utilities company with 10,001+ employees
erwin Data Modeler had a very good standardization infrastructure and supported a controlled multi-user environment with check-ins and check-outs.
Data Metrics Engineer at a financial services firm with 10,001+ employees
Performance can degrade during larger collaborations and requires tuning for optimal performance.
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
Consulting Principal & Founder at Digital Data Consultancy
There are many options available, and the licensing model is quite good, supporting our needs effectively.
Data Integration Architect at Endeavour Foundation
 

Stability Issues

Sentiment score
7.0
Erwin Data Modeler is stable and effective, though memory issues and lack of auto-save can cause work loss.
Sentiment score
7.6
Informatica Intelligent Data Management Cloud is generally stable, with minor issues, praised for scalability and reliability, rated highly.
This lack of an auto-save methodology can be improved so that if a system crash occurs, work can be saved and rework can be avoided.
Data Modeler at Capgemini
erwin Data Modeler is stable.
Expert Solutions Architect(AI\ML & Cloud Engineering) at TEKsystems (ex Aston Carter)
New versions often introduce enhanced features but may cause model crashes due to memory exhaustion.
Data Architect at a energy/utilities company with 10,001+ employees
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
Consulting Principal & Founder at Digital Data Consultancy
There are substantial stability issues with Informatica Cloud Data Quality on the cloud.
consultant at a energy/utilities company with 5,001-10,000 employees
I find the stability to be good, with occasional restarts required every two to three months due to glitches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
 

Room For Improvement

Erwin Data Modeler needs a modern UI, cloud integration, improved performance, NoSQL support, and better documentation to enhance usability.
IDMC faces integration, pricing, customization, and usability challenges, needing improvements in performance, support, AI, and functionalities.
The previous version of erwin Data Modeler used to crash unaccountably, but this one hasn't ever crashed on me, so it's been a lot more stable than the previous version that we had.
Data Warehouse Architect at a healthcare company with 10,001+ employees
There is room for improvement in its AI capabilities, such as automatically suggesting normalization or identifying primary, foreign, or surrogate keys to make modeling more efficient.
Data Specialist at TCS
I rate it a 9 out of 10 because I'm not entirely satisfied with the UI; it could benefit from a cleanup and feature consolidation to improve navigation and reduce confusion.
Senior Data Modeler at a tech vendor with 1,001-5,000 employees
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.
Contractor at Sanlam
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
Consulting Principal & Founder at Digital Data Consultancy
The current solution requires code-writing and tweaking, while other solutions offer material-level matches.
IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees
 

Setup Cost

erwin Data Modeler is costly, targeting enterprises, and offers robust features that many users find worth the investment.
Informatica IDMC is a costly, feature-rich solution for large enterprises, with pricing concerns partly mitigated by negotiable discounts.
For a cloud or SaaS standard edition, it typically runs around two hundred to two hundred ninety-nine US dollars per month.
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous.
Contract Data Architect at a financial services firm with 10,001+ employees
My experience with erwin Data Modeler's pricing and setup costs shows it to be on the expensive side;
Senior Data Modeler at a tech vendor with 1,001-5,000 employees
It ranges from a quarter million to a couple of million a year.
Consulting Principal & Founder at Digital Data Consultancy
Informatica Intelligent Cloud Services is affordable for my specific use cases, with the pricing being rated three or four on a scale where one is very cheap.
Data Integration Architect at Endeavour Foundation
Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.
Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte
 

Valuable Features

Erwin Data Modeler excels in visualizing complex data, supporting collaboration and integration, and simplifying data management across diverse environments.
Informatica IDMC is praised for seamless data integration, quality management, flexibility, and robust AI-driven data features.
One of the key aspects of data governance is defining the data dictionary and clearly identifying which data is accessible by whom and what is not accessible, particularly regarding PII-related data.
SPM at Infosys
The way the data is organized and you have a visual of that organization helps a great deal in terms of trying to remember what you did and trying to retrieve the information.
Data Metrics Engineer at a financial services firm with 10,001+ employees
Migrating DDLs using erwin Data Modeler is easy because I just connect to the database and generate the data model from what is already implemented, making the process straightforward.
Data Modeler at FNB Mozambique
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
Consulting Principal & Founder at Digital Data Consultancy
The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.
Data Integration Architect at Endeavour Foundation
We could run data quality rules as part of Service Bus, which ensured the integrity of customer information before it was entered into our database.
Data and Analytics Manager at a insurance company with 10,001+ employees
 

Categories and Ranking

erwin Data Modeler
Ranking in Data Governance
11th
Average Rating
8.2
Reviews Sentiment
5.8
Number of Reviews
70
Ranking in other categories
Enterprise Architecture Management (1st), Business Process Design (4th)
Informatica Intelligent Dat...
Ranking in Data Governance
3rd
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) (9th), Business-to-Business Middleware (4th), API Management (18th), Cloud Data Integration (4th), Test Data Management (4th), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (5th), Test Data Management Services (5th), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (3rd)
 

Mindshare comparison

As of November 2026, in the Data Governance category, the mindshare of erwin Data Modeler is 0.6%, up from 0.0% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.7%, down from 7.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Governance Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)4.7%
erwin Data Modeler0.6%
Other94.7%
Data Governance
 

Featured Reviews

JV
Expert Solutions Architect(AI\ML & Cloud Engineering) at TEKsystems (ex Aston Carter)
Data models have unified hybrid environments and now support faster, trusted analytics delivery
erwin Data Modeler can be improved in a few ways. Maybe it could integrate with some AI features that give an inference of what I could build for some use cases using the relationships that I am establishing, which might be helpful. Having some upfront reporting integration from a one- to-many or many-to-many relationship problem standpoint would also be helpful. The reason I give it a nine is the AI capability that I think should be there. I think the accuracy and reliability of the output of erwin Data Modeler’s AI capabilities is maybe a six. erwin Data Modeler is effective in managing data across different environments, such as traditional, NoSQL, big data, and cloud platforms, in the following way. I know it works well for traditional platforms. For non-traditional platforms such as Databricks, I do not think it is there yet.
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.
report
Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
922,349 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Outsourcing Company
9%
Manufacturing Company
8%
Marketing Services Firm
6%
Financial Services Firm
11%
Manufacturing Company
11%
Outsourcing Company
9%
Construction Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business19
Midsize Enterprise4
Large Enterprise63
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
My experience with erwin Data Modeler's pricing, setup cost, and licensing has been good so far. While I would not call it a concern, the pricing tends to be on the higher end compared to compe...
What needs improvement with erwin Data Modeler by Quest?
One feature that I wish erwin Data Modeler could improve is how user experience becomes much more intuitive, particularly when navigating large models or reviewing changes over time. Easier model e...
What is your primary use case for erwin Data Modeler by Quest?
My main use case for erwin Data Modeler involves using AI agents to assist with implementing these models within the Adobe Experience Platform. That is my primary experience. erwin Data Modeler ser...
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 ...
 

Also Known As

erwin DM
ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
The Travel Company, Carbonite
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. erwin Data Modeler and other solutions. Updated: November 2026.
922,349 professionals have used our research since 2012.