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

Informatica Intelligent Data Management Cloud (IDMC) vs erwin Data Modeler 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
9.1
erwin Data Modeler enhances efficiency, accuracy, and customization in data management, boosting productivity and reducing manual effort.
Sentiment score
7.1
Organizations benefit from improved data quality, time savings, and ROI with Informatica Cloud, enhancing processes and security.
It replaces manual charting in Visio with a structured tool, providing significant return on investment.
 

Customer Service

Sentiment score
9.0
Erwin Data Modeler's support is praised for responsiveness and expertise, despite occasional response time and communication issues.
Sentiment score
6.9
Informatica's customer service is effective, praised for responsiveness but criticized for occasional delays and inconsistency.
Quest is committed to keeping the product robust.
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.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
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.
 

Scalability Issues

Sentiment score
7.1
Erwin Data Modeler is scalable, supports multiple users and platforms, but may slow with massive models; excels in enterprise architectures.
Sentiment score
7.3
Informatica IDMC is highly scalable and adaptable, though optimal design and documentation are crucial for large-scale operations.
I would rate it probably a nine, making it a leader in data modeling.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
 

Stability Issues

Sentiment score
5.8
Erwin Data Modeler is stable and mature, with occasional performance issues, but users value its consistent improvements.
Sentiment score
7.7
Informatica Intelligent Data Management Cloud is generally stable, with newer versions being more reliable and support enhancing consistency.
New versions often introduce enhanced features but may cause model crashes due to memory exhaustion.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
 

Room For Improvement

Erwin Data Modeler needs improvements in usability, multi-language support, integration, automation, and compatibility with evolving big-data platforms.
IDMC requires UI improvements, better system connectivity, performance enhancements, cost reduction, AI features, and improved support and observability.
I also want to see integration with other Informatica products, such as IICS, to leverage the metadata from EDC.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.
 

Setup Cost

Erwin Data Modeler is seen as costly due to its features and flexibility, challenging affordability in lower-budget regions.
Informatica IDMC's pricing is seen as high, with nuanced licensing, leading to user concerns compared to competitors.
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.
 

Valuable Features

erwin Data Modeler simplifies database management with features like visual modeling, DDL generation, version control, and collaborative capabilities.
Informatica IDMC is a robust cloud platform offering seamless data integration, real-time streaming, and comprehensive data management features.
Transitioning from a logical to a physical environment with just a switch is key.
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.
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.
 

Categories and Ranking

erwin Data Modeler
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (4th), Business Process Design (10th)
Informatica Intelligent Dat...
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Integration (4th), Data Quality (1st), Business Process Management (BPM) (9th), Business-to-Business Middleware (5th), API Management (7th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
Saikat Ghosh - PeerSpot reviewer
Match and merge functionality is still the best but cloud version needs more functionality
There are various areas for improvement in IDMC. Enhancements on basic data management functionality and the UI front, such as multiple templates and improved grid views, would be beneficial. Bulk data management features could be improved from the UI perspective to get to the level of the on prem versions of Informatica MDM. The tool needs to mature but missing small but important features, like restricted dynamic attributes functionality, data inheritance rules in master hierachies, identifiers not being passed in jobs is a drawback.
report
Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
865,484 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Financial Services Firm
16%
Computer Software Company
11%
Manufacturing Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
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, 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
 

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 Microsoft, Informatica, Collibra and others in Data Governance. Updated: July 2025.
865,484 professionals have used our research since 2012.