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

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

December 2025

Download the complete report

Helped 881,082 peers since 2012

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

4.8

erwin Data Modeler improves productivity and efficiency with enhanced data management, governance, and automation, offering significant time savings.

Sentiment score

7.1

Informatica's cloud platform enhances data management efficiency, cost savings, and data security, requiring effective change management for optimal results.

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.

For more quotes and insights, download the erwin Data Modeler report

Data Architect at a energy/utilities company with 10,001+ employees

If the modeling is compromised, then the entire structure will be compromised.

reviewer2795649

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

The stability and performance remain issues.

reviewer946383

consultant at a energy/utilities company with 5,001-10,000 employees

Compared to Collibra Catalog, where the value is noticeable within six months.

reviewer2696502

Data and Analytics Manager at a insurance company with 10,001+ employees

Customer Service

Sentiment score

6.0

Erwin Data Modeler support is helpful and proactive, with minor delays; ratings are generally between seven to nine.

Sentiment score

6.9

Informatica's customer service is generally rated positively for quick, knowledgeable support, though some report occasional delays and inconsistencies.

The quality and speed of their support are excellent; everyone is very helpful, and they can solve problems quickly.

Yang Jiao

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.

Quest is committed to keeping the product robust.

For more quotes and insights, download the erwin Data Modeler report

Data Architect at a energy/utilities company with 10,001+ employees

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

Scalability Issues

Sentiment score

6.5

Erwin Data Modeler is scalable, supporting multiple platforms, handling complex architectures, and suitable for cloud and on-premise use.

Sentiment score

7.3

Informatica Intelligent Data Management Cloud is praised for scalability and flexibility in handling large datasets, despite pricing concerns.

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.

Monisha Sharma

Data Metrics Engineer at a financial services firm with 10,001+ employees

Performance can degrade during larger collaborations and requires tuning for optimal performance.

For more quotes and insights, download the erwin Data Modeler report

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

Stability Issues

Sentiment score

6.0

erwin Data Modeler is stable and reliable, but performance and memory issues can occur with large models and older versions.

Sentiment score

7.7

Users generally find IDMC stable, with occasional challenges after updates, especially in older versions or specific integrations.

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.

Khadarvalli Phatan

Data Modeler at Capgemini

New versions often introduce enhanced features but may cause model crashes due to memory exhaustion.

For more quotes and insights, download the erwin Data Modeler report

Data Architect at a energy/utilities company with 10,001+ employees

Sometimes when I want to open the attribute editor, it stops working and the whole application freezes.

Yang Jiao

Senior Data Scientist at a consultancy 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.

reviewer946383

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

IT Manager - Data Quality and Migration at a manufacturing company with 10,001+ employees

Room For Improvement

Erwin Data Modeler users seek improvements in user interface, big data support, API documentation, and broader database compatibility.

Informatica IDMC needs UI improvements, better connectivity, streamlined configuration, cheaper pricing, and enhanced support with AI integration.

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.

Alton Thibodeaux

Data Warehouse Architect at a healthcare company with 10,001+ employees

There are many features, and I would expect good documentation detailing each feature, including when and how to use it, to be very useful because data modeling is not very popular in the data area and there aren't many educational videos regarding erwin Data Modeler.

Yang Jiao

Senior Data Scientist at a consultancy with 10,001+ employees

Erwin Data Modeler could improve in areas such as the interface, as there are features like copy and paste, creating duplicates, and the visualization elements and toolbars which feel quite old.

Khadarvalli Phatan

Data Modeler at Capgemini

For more quotes and insights, download the erwin Data Modeler report

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

If the development interface could be optimized to have fewer modules, it would be greatly beneficial.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Data Integration Architect at Endeavour Foundation

Setup Cost

Erwin Data Modeler provides flexible licensing but can be costly compared to open-source alternatives, with moderate maintenance fees.

Informatica IDMC provides a robust but expensive pricing model with complex licensing and potential negotiation discounts for enterprises.

For a cloud or SaaS standard edition, it typically runs around two hundred to two hundred ninety-nine US dollars per month.

For more quotes and insights, download the erwin Data Modeler report

Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.

It is more targeted toward an enterprise level since organizations looking to store business information and relationship values may consider the pricing.

Khadarvalli Phatan

Data Modeler at Capgemini

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

Valuable Features

Erwin Data Modeler enhances database management with visualization, version control, automation, and adaptability, fostering efficient collaboration and governance.

Informatica IDMC offers seamless data integration, AI-enhanced features, and efficient governance, enhancing user experience and operational efficiency.

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.

Asish Sahu

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.

Monisha Sharma

Data Metrics Engineer at a financial services firm with 10,001+ employees

One of the best aspects of the tool is its reverse engineering capability.

For more quotes and insights, download the erwin Data Modeler report

Data Architect at a energy/utilities company with 10,001+ employees

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.

For more quotes and insights, download the Informatica Intelligent Data Management Cloud (IDMC) report

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.

reviewer2696502

Data and Analytics Manager at a insurance company with 10,001+ employees

Categories and Ranking

erwin Data Modeler

Ranking in Data Governance

15th

Average Rating

8.6

Reviews Sentiment

5.9

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (2nd), Business Process Design (8th)

Informatica Intelligent Dat...

Ranking in Data Governance

3rd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

214

Ranking in other categories

Data Integration (2nd), Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), API Management (6th), Cloud Data Integration (3rd), Test Data Management (3rd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (1st), Metadata Management (1st), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (1st), AI Data Analysis (1st)

Mindshare comparison

As of January 2026, in the Data Governance category, the mindshare of erwin Data Modeler is 0.3%. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 5.3%, down from 8.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Data Governance Market Share Distribution
Product	Market Share (%)
Informatica Intelligent Data Management Cloud (IDMC)	5.3%
erwin Data Modeler	0.3%
Other	94.4%

Data Governance

Featured Reviews

Data modeling has transformed regulatory reporting and collaboration across cloud environments

Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.

In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.

Read full review

Handles large data volumes effectively and offers competitive pricing

Sr. Consultant cum Assistant Manager & Offshore Lead at Deloitte

There is a lot of improvement required, as we still face some cache issues most of the time, which is a challenge that we expect to see resolved in the future. Additionally, there is some limitation when we are working with a tool, especially regarding In and Out parameters, and I feel that this aspect should be improved going ahead. We face issues with the API side, as Cloud Application Integration cannot handle large volumes; according to the API page, there is a limitation of 500 records or 500 MB. The AI integrated into the Informatica Intelligent Cloud Services solution is called Application Integration, where we still face challenges when dealing with huge volumes, as previously explained.

Read full review

See which vendors are best for you

Use our free recommendation engine to learn which Data Governance solutions are best for your needs.

See recommendations

881,082 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Government

Manufacturing Company

Performing Arts

Financial Services Firm

14%

Manufacturing Company

11%

Computer Software Company

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	15
Midsize Enterprise	3
Large Enterprise	34

By reviewers
Company Size	Count
Small Business	51
Midsize Enterprise	27
Large Enterprise	153

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?

Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations l...

What needs improvement with erwin Data Modeler by Quest?

I write code and I write code accessing erwin Data Modeler's API, the Application Programming Interface, so that I can use Excel to update erwin Data Modeler and then get those updates and put them...

What is your primary use case for erwin Data Modeler by Quest?

I work for CVS with a pretty big database as a data modeler on the PBMs, the Caremark PBM side, which is the Pharmacy Benefits Manager. There's a retail side too for all the stores, but our data wa...

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 ...

SAP PowerDesigner vs erwin Data Modeler

Comparisons

Compared 41% of the time

IDERA ER/Studio vs erwin Data Modeler

Compared 11% of the time

Lucidchart vs erwin Data Modeler

Compared 7% of the time

Visio vs erwin Data Modeler

Compared 5% of the time

Sparx Systems Enterprise Architect vs erwin Data Modeler

Compared 4% of the time

More erwin Data Modeler Competitors

Collibra Platform vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

Qlik Talend Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 3% of the time

Azure Data Factory vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

Semarchy xDM vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 2% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Product Reports

Download erwin Data Modeler product report

erwin Data Modeler

January 2026

Informatica Intelligent Data Management Cloud (IDMC)

January 2026

Informatica Intelligent Data Management Cloud (IDMC) report

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Also Known As

erwin DM

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking

Overview

Erwin Data Modeler provides an effective approach to visualizing and managing data models. It assists in creating, reversing, and synchronizing data models with ease, supporting logical and physical transitions while enhancing understanding across teams.

Erwin Data Modeler is a comprehensive tool designed for professional database management. It offers capabilities to organize and enforce standards, automating script generation with robust reverse engineering and DDL output. Users can manage complex data environments, capitalize on integration with data intelligence, and maintain large-scale databases smoothly. Despite its strengths, improvements in multi-language support, database integration, and reporting features are needed. Users benefit from extensive support for conceptual, logical, and physical database modeling, enhancing architectural design and data governance for platforms like SQL Server, Oracle, and Teradata.

What are the key features of Erwin Data Modeler?

Visual Representation: Facilitates clear visualization of data models, aiding comprehension.
Versioning and Editing: Enhance usability with versioning and bulk editing capabilities.
Reverse Engineering: Offers powerful tools for reverse engineering and DDL generation.
Integration: Aligns with data intelligence to streamline database management.
Naming Standards: Enforces consistency with automated script creation.

What benefits should users consider in Erwin Data Modeler reviews?

Collaboration: Promotes team understanding and collaboration through visual tools.
Automation: Reduces manual effort through automated processes and integration.
Scalability: Handles large database management efficiently, crucial for enterprise settings.
Data Governance: Facilitates effective data governance with structured modeling.

Erwin Data Modeler finds application in industries focused on robust data management, implementing it for enterprise data warehouses, business domain models, and operational systems. It supports architectural design and governance, aligning with business applications demanding precise data representation and visualization.

Quest Software

Informatica Intelligent Data Management Cloud (IDMC) offers seamless integration of master data management, data quality, and data integration with a cloud-native architecture supporting multiple data management styles, optimizing data governance through metadata management.

IDMC enhances data synchronization and mapping tasks, utilizing a broad range of connectors to interact efficiently with data sources. Its precise address validation via AddressDoctor and intuitive navigation bolster user empowerment, delivering agility, scalability, and security in data governance. Despite its strengths, areas like ease of use, SAP integration, and reporting could benefit from enhancements. Connectivity issues and workflow complexities are noted, needing improvements in performance, support, and licensing cost. Users demand expanded ETL capabilities, real-time processing, and broader data source support to address growing data needs.

What are the key features of IDMC?

Integration Capabilities: Ensures seamless connectivity between on-premise and cloud environments.
Master Data Management: Centralizes and streamlines data processes for enhanced quality.
Data Quality: Employs tools for cleansing and standardizing data accuracy.
Address Validation: Features AddressDoctor for precise address verification.
Real-Time Processing: Supports real-time data handling for critical operations.
Connectivity Options: Offers a wide array of connectors for easy data source interaction.

What benefits and ROI should users consider?

Scalability: Cloud-native design boosts system agility, adapting to data volume changes.
Security: Enhances data protection with robust encryption and compliance measures.
Efficiency: Automates processes to reduce manual effort and errors.
Flexibility: Supports diverse data management styles, offering adaptability to business changes.
Governance: Empowers effective data governance through comprehensive metadata management.

In industries such as banking, healthcare, and telecom, IDMC is implemented for data integration, cloud migration, and enhancing data quality. Its capabilities are crucial for metadata management, lineage tracking, and real-time processing, ensuring high data quality and streamlined operations.

Informatica

Sample Customers

Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples

The Travel Company, Carbonite