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

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

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

erwin Data Catalog by Quest
Ranking in Metadata Management
11th
Average Rating
7.6
Reviews Sentiment
5.3
Number of Reviews
2
Ranking in other categories
No ranking in other categories
Informatica Intelligent Dat...
Ranking in Metadata Management
1st
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
181
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (7th), Business-to-Business Middleware (3rd), 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), Test Data Management Services (4th), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Featured Reviews

Andres-Martinez - PeerSpot reviewer
Helps with metadata management, saves time, and allows us to do impact analysis on any changes
There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names. There were some issues when drawing the data models. If you have more than 500 or 600 tables, it takes a long time to display those in the right position on the screen. That can also be improved. They need some caching and some parallel pipelines working on the backend in order to divide it into sections.
Raj Sethupathi - PeerSpot reviewer
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.

Quotes from Members

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

Pros

"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"The data catalog feature is pretty good."
"MDM is very stable - it can handle millions of hits daily and still run 24/7."
"The solution has multiple valuable features for metadata collection"
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
"The advanced features like task flow and conditional integration are particularly useful."
"The most valuable features of the solution are pushdown, optimization, and partitioning, which can be used for frequent data loading, especially when we have a huge data volume in our company."
"The most valuable feature of Informatica Axon has been the data marketplace."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"Some of Axon's valuable features include creating your business glossaries, importing DQ rules, and creating change management."
 

Cons

"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"Informatica Axon needs to improve its interface."
"Some functionalities can be a challenge in the cloud."
"User/group administration could use improvement."
"Cost-wise, it could be better."
"The configuration process is pretty lengthy and challenging and could be made easier to understand."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"We haven't had many technical issues. We don't use all of the components of the tool that are more complex and error-prone."
"Exploring the possibility of incorporating AI capabilities that can suggest additional rules would significantly streamline our data analysis process following data profiling."
 

Pricing and Cost Advice

"Erwin Data Catalog is very expensive."
"I am not very familiar with its pricing. I know it is not cheap, but it is also not super expensive. It depends on the company size. For a company making $1 million, it is very expensive. For a company making 10 million and above, it might be okay."
"The solution is very expensive."
"It's an expensive solution."
"Cost-wise, I think it is on the higher side, and that is why we are looking for some better options. Licensing costs are huge compared to other players in the market and for my company."
"Pricing is determined by the number of licensed users as well as the number of Core CPUs."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"It's a very expensive solution"
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
"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."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Government
13%
Computer Software Company
10%
Manufacturing Company
10%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
10%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
What is your experience regarding pricing and costs for erwin Data Catalog?
Erwin Data Catalog is very expensive. I would rate it a two out of five for affordability.
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

No data available
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

Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, Daktronics
The Travel Company, Carbonite
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. erwin Data Catalog by Quest and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.