

Informatica IDMC and erwin Data Modeler both offer powerful solutions in the data management domain. Informatica IDMC appears to have the upper hand due to its dynamic integration features and cloud flexibility, making it highly attractive to enterprises looking for comprehensive data management solutions.
Features: Informatica IDMC features a flexible architecture supporting various data management styles, robust integration features, and seamless cloud solutions. Its dynamic matching and merging capabilities and extensive connector options enhance its appeal to enterprises. Erwin Data Modeler provides detailed data models that simplify complex data source interactions. Its strength lies in visual representation and the ability to generate accurate database code, aiding organizations in understanding data relationships.
Room for Improvement: Informatica IDMC users face challenges with its pricing model, performance issues, and a complex setup process, suggesting a need for more automation and better support. erwin Data Modeler users point to its classic interface and occasional UI bugs, recommending updates for a more modern and user-friendly design.
Ease of Deployment and Customer Service: Informatica IDMC offers diverse deployment options, including public and hybrid clouds, facilitating implementation across various environments. Customer service is generally positive, although some users report extended response times and a need for more proactive support. Erwin Data Modeler, predominantly on-premises, is praised for robustness but has a slower pace in adopting newer tech stacks, which can affect deployment flexibility. Its customer service is generally reliable, yet could improve in agility for complex support cases.
Pricing and ROI: Informatica IDMC is perceived as expensive, with a challenging pricing model for smaller enterprises, but those leveraging its full scope report significant benefits. Erwin Data Modeler, while also costly, services a niche market due to its specific functionality. Both solutions offer good ROI in data management, although initial costs may be high for smaller organizations.
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.
It replaces manual charting in Visio with a structured tool, providing significant return on investment.
If the modeling is compromised, then the entire structure will be compromised.
Leadership prefers to utilize third-party tools, such as Snowflake, which has both storage and ELT features.
The stability and performance remain issues.
Compared to Collibra Catalog, where the value is noticeable within six months.
Customer support for erwin Data Modeler is excellent, providing easy access and quick issue resolution via calls.
The quality and speed of their support are excellent; everyone is very helpful, and they can solve problems quickly.
This rating reflects my ability to effectively utilize the tool and get support for licensing issues, installation errors, or corrupted repositories end-to-end.
Due to the tool's maturity limitations, solutions are not always simple and often require workarounds.
Even after going out of service support, they still reached back to me whenever I raised tickets.
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.
I would rate it probably a nine, making it a leader in data modeling.
erwin Data Modeler had a very good standardization infrastructure and supported a controlled multi-user environment with check-ins and check-outs.
Performance can degrade during larger collaborations and requires tuning for optimal performance.
I have used the product over multiple systems and was able to write reports for large data sets without any performance issues.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
There are many options available, and the licensing model is quite good, supporting our needs effectively.
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.
erwin Data Modeler is stable.
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.
There are substantial stability issues with Informatica Cloud Data Quality on the cloud.
I find the stability to be good, with occasional restarts required every two to three months due to glitches.
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.
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.
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.
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.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The current solution requires code-writing and tweaking, while other solutions offer material-level matches.
For a cloud or SaaS standard edition, it typically runs around two hundred to two hundred ninety-nine US dollars per month.
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous.
My experience with erwin Data Modeler's pricing and setup costs shows it to be on the expensive side;
It ranges from a quarter million to a couple of million a year.
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.
Regarding pricing, compared to other tools I have worked with, Informatica offers competitive pricing, which I find not high in terms of starting strategy.
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.
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.
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.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
The connectors serve as the main functionality, making data integration processes more efficient by saving time and effort.
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.
| Product | Mindshare (%) |
|---|---|
| Informatica Intelligent Data Management Cloud (IDMC) | 4.7% |
| erwin Data Modeler | 0.6% |
| Other | 94.7% |
| Company Size | Count |
|---|---|
| Small Business | 19 |
| Midsize Enterprise | 4 |
| Large Enterprise | 63 |
| Company Size | Count |
|---|---|
| Small Business | 51 |
| Midsize Enterprise | 27 |
| Large Enterprise | 155 |
Erwin Data Modeler facilitates visual data modeling, providing logical and physical models to enhance data understanding. It aids in reverse engineering, data lineage, and synchronization, offering robust documentation and integration with major platforms for complex data environments.
Erwin Data Modeler is renowned for its capacity to streamline the design and maintenance of databases, emphasizing logical and physical model creation. This tool is pivotal in generating SQL scripts, facilitating reverse engineering, and ensuring data lineage and integrity across enterprise applications. By supporting model versioning and synchronization across platforms, it strengthens database alignment and further integrates with major data infrastructures, supporting AI-ready data. However, there is room for improvement in its aging interface and collaboration features, particularly regarding handling extensive data models and modern database integration.
What are the key features of Erwin Data Modeler?In industries like finance, healthcare, and retail, Erwin Data Modeler is implemented to streamline data management and support business requirements. It aids in designing databases, maintaining data accuracy, and implementing business-critical applications across various platforms, enhancing data integrity and visualization.
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?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.
We monitor all Data Governance reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.