Informatica Intelligent Data Management Cloud (IDMC) vs erwin Data Intelligence by Quest comparison

Informatica Intelligent Data Management Cloud (IDMC) vs. erwin Data Intelligence by Quest

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

erwin Data Intelligence by ...

Ranking in Data Governance

5th

Average Rating

8.6

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Informatica Intelligent Dat...

Ranking in Data Governance

2nd

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

181

Ranking in other categories

Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (3rd), API Management (7th), Cloud Data Integration (3rd), 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 (4th), Product Information Management (PIM) (1st), Data Observability (2nd)

Featured Reviews

Roy Pollack

Advisor Application Architect at CPS Energy

The solution provides more profound insights into legacy data movements, lineages, and definitions in the short term.

We have loaded over 300,000 attributes and more than 1000 mappings. The performance is slow, depending on the lineage or search. This is supposed to be fixed in the later versions, but we haven't upgraded yet. The integration with various metadata sources, including erwin Data Modeler, isn't smooth in the current version. It took some experimentation to get things working. We hope this is improved in the newer version. The initial version we used felt awkward because Erwin implemented features from other companies into their offering.

Read full review

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

Offers profiling and address standardization but can be complicated

Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.

Read full review

Quotes from Members

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

Pros

"They have just the most marvelous reports called mind maps, where whatever you are focused on sits in the middle. They have this wonderful graphic spiderweb that spreads out from there where you can see this thing mapped to other logical bits or physical bits and who's the steward of it. It's very cool and available to your business teams through a portal."

"Data Intelligence allows us to automate multiple tasks we had previously done manually, such as restructuring the metadata for our purposes, setting up ETL flows, and defining the data tables we create. It also enables us to standardize our approach and our technical processes."

"It is a central place for everybody to start any ETL data pipeline builds. This tool is being heavily used, plus it's heavily integrated with all the ETL data pipeline design and build processes. Nobody can bypass these processes and do something without going through this tool."

"Overall, DI's data cataloging, data literacy, and automation have helped our decision-makers because when a source wants to change something, we immediately know what the impact is going to be downstream."

"Data Intelligence creates a single source of truth for all of our metadata. This solution is better for data warehousing, but the metadata features speed up our development work. It's easy to create and manage mappings because we can export them to Informatica and pick up the work where we left off."

"Data Intelligence has provided more profound insights into legacy data movements, lineages, and definitions in the short term. We have linked three critical layers of data, providing us with an end-to-end lineage at the column level."

"We use the codeset mapping quite a bit to match value pairs to use within the conversion as well. Those value pair mappings come in quite handy and are utilized quite extensively. They then feed into the automation of the source data extraction, like the source data mapping of the source data extraction, the code development, forward engineering using the ODI connector for the forward automation."

"The interface is easy to use. I also like Erwin's automatic data classification and data quality checks."

More erwin Data Intelligence by Quest pros

"Informatica MDM has a defined data model we can customize with user and developer options."

"We've used the solution for quite some time, so in our organization, the product is pretty mature."

"MDM is very stable - it can handle millions of hits daily and still run 24/7."

"A great product enrichment tool."

"It is a very stable solution. I rate its stability a ten out of ten...It is a scalable solution...Informatica Axon's technical support is good."

"The solution has the best feature for parameterization."

"It has flexibility in extending the data model."

"It's got a reputation in the industry as one of the best solutions for master data management. So, it's what we see in the Gartner top right quadrant as the best product in that space."

More Informatica Intelligent Data Management Cloud (IDMC) pros

Cons

"The integration with various metadata sources, including erwin Data Modeler, isn't smooth in the current version. It took some experimentation to get things working. We hope this is improved in the newer version. The initial version we used felt awkward because Erwin implemented features from other companies into their offering."

"If we are talking about the business side of the product, maybe the Data Literacy could be made a bit simpler. You have to put your hands on it, so there is room for improvement."

"Really huge datasets, where the logical names or the lexicons weren't groomed or maintained well, were the only area where it really had room for improvement. A huge data set would cause erwin to crash. If there were half a million or 1 million tables, erwin would hang."

"There was a huge learning curve, and I'd been in software development for most of my career. The application itself, and how it runs menus and screens when you can modify and code, is complex. I have found that kind of cumbersome."

"The versioning can sometimes be confusing because we use the publishing feature for the mapping. Technical analysts sometimes have two versions, and they should know that the public version is the correct one."

"There is room for improvement with the data cataloging capability. Right now, there is a list of a lot of sources that they can catalog, or they can create metadata upon, but if they can add more then that would be a good plus for this tool."

"The solution's Arabic language processing is limited. The results are limited when you use the interface in Arabic."

"One big improvement we would like to see would be the workflow integration of codeset mapping with the erwin source to target mapping. That's a bit clunky for us. The two often seem to be in conflict with one another. Codeset mappings that are used within the source to target mappings are difficult to manage because they get locked."

More erwin Data Intelligence by Quest cons

"It needs to be a little more intuitive but it’s really not bad."

"The product is not too user-friendly to do the configurations."

"The biggest pain point for us is the documentation. Typically, you have to go through knowledge forums and knowledge groups to find out about the syntax issues for interfacing with new products. Typically, you've got to deal with someone who has been through the pain before. Their documents are not really up to date with current innovations happening in the industry. As big as they are, you can't really expect it, but that's our pain point."

"The data discovery isn't that good yet for Salesforce. We have another tool that we use for this. It may be a problem because Salesforce on the cloud."

"Although we are very satisfied with the design of the UI, executing tasks with it can be difficult."

"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."

"From multiple masters that are there in Informatica MDM, we can improve the financials."

"Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data."

More Informatica Intelligent Data Management Cloud (IDMC) cons

Pricing and Cost Advice

"The price is reasonable, and a subscription is required."

"We operate on a yearly subscription and because it is an enterprise license we only have one. It is not dependent on the number of users."

"erwin was at a good price. The federal government wouldn't buy something if the pricing wasn't good."

"The licensing cost was very affordable at the time of purchase. It has since been taken over by erwin, then Quest. The tool has gotten a bit more costly, but they are adding more features very quickly."

"erwin's pricing was cheaper than its competitors."

"There is an additional fee for the server maintenance."

"The whole suite, not just the DI but the modeling software, the harvester, Mapping Manager — everything we have — is about $100,000 a year for our renewals. That works out to each module being something like $8,000 to $10,000."

"The price is too high."

More erwin Data Intelligence by Quest pricing and cost advice

"Informatica MDM's pricing is not cheap but comparable to other vendors."

"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten."

"The product is highly-priced."

"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."

"Informatica is very expensive."

"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."

"The pricing is quite flexible."

"It's a very expensive solution"

More Informatica Intelligent Data Management Cloud (IDMC) pricing and cost advice

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

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

21%

Financial Services Firm

12%

Government

Non Profit

Financial Services Firm

17%

Computer Software Company

12%

Manufacturing Company

10%

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about erwin Data Intelligence by Quest?

The data mapping manager is the most valuable feature.

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

The price is reasonable, and a subscription is required.

What needs improvement with erwin Data Intelligence by Quest?

The data quality assessment requires third-party components and a separate license. I would like to have better integration around the data quality. I would appreciate the inclusion of a non-struct...

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

Microsoft Purview Data Governance vs erwin Data Intelligence by Quest

Comparisons

Compared 37% of the time

Collibra Governance vs erwin Data Intelligence by Quest

Compared 18% of the time

Alation Data Catalog vs erwin Data Intelligence by Quest

Compared 10% of the time

Collibra Lineage vs erwin Data Intelligence by Quest

Compared 7% of the time

AtScale Adaptive Analytics (A3) vs erwin Data Intelligence by Quest

Compared 5% of the time

More erwin Data Intelligence by Quest Competitors

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 8% of the time

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

Compared 7% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

Microsoft Purview Data Governance vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

More Informatica Intelligent Data Management Cloud (IDMC) Competitors

Product Reports

erwin Data Intelligence by Quest

Download erwin Data Intelligence by Quest product report

Informatica Intelligent Data Management Cloud (IDMC)

Download Informatica Intelligent Data Management Cloud (IDMC) product report

Informatica Intelligent Data Management Cloud (IDMC) report

Also Known As

erwin DG, erwin Data Governance

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

Learn More

erwin by Quest

Informatica

Overview

The erwin Data Intelligence Suite (erwin DI) combines data catalog and data literacy capabilities for greater awareness of and access to available data assets, guidance on their use, and guardrails to ensure data policies and best practices are followed. Automatically harvest, transform and feed metadata from a wide array of data sources, operational processes, business applications and data models into a central data catalog. Then make it accessible and understandable within context via role-based views. This complete metadata-driven approach to data governance facilitates greater IT and business collaboration.

Informatica Intelligent Data Management Cloud (IDMC) is a robust platform used by banks, financial institutions, and health sector organizations for data management, governance, and compliance.

IDMC provides comprehensive tools for data discovery, profiling, masking, and transformation. It supports Salesforce integration, real-time data streaming, and scalable data management solutions. Health organizations manage national product catalogs while financial entities focus on data protection and regulatory compliance. Its intuitive interface, flexible features, and robust tools make it valuable across sectors, though enhancements in data integration and human workflow are being sought.

What are the most important features?

Data discovery: Facilitates identifying and understanding data sources.
Data profiling: Analyzes old databases for data quality.
Data and platform masking: Ensures data protection.
Salesforce integration: Seamless connectivity with Salesforce.
Mastering data: Centralizing and standardizing data.
UI intuitiveness: User-friendly interface.
Feature map flexibility: Adapts to user needs.
Business glossary creation: Defines business terms.
Data lineage: Tracks data flow and transformations.
Automation: Streamlines data processes.
Enterprise data cataloging: Organizes extensive data assets.
Scalability: Supports expanding data requirements.
Easy setup: Quick deployment process.
Bulk upload: Efficiently handles large data volumes.
Customizable data management: Tailors data solutions.
Real-time data streaming: Manages live data streams.
Integration with Hadoop and NoSQL: Connects with big data platforms.

What benefits and ROI should be considered?

Regulatory compliance: Ensures adherence to regulations.
Data protection: Safeguards sensitive information.
Enhanced data quality: Improves accuracy and reliability.
Centralized data: Consolidates data for better management.
Process automation: Reduces manual tasks and errors.

Banks and financial institutions use IDMC for data masking, transformation, and compliance, while health sector organizations leverage it for national product catalogs. Industry applications focus on automating business processes, centralizing data, and managing data catalogs to meet regulatory demands and ensure data protection.

Sample Customers

Oracle, Infosys, GSK, Toyota Motor Sales, HSBC

The Travel Company, Carbonite

Informatica Intelligent Data Management Cloud (IDMC) vs. erwin Data Intelligence by Quest