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 831,265 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:

Categories and Ranking

erwin Data Intelligence by ...

Ranking in Data Governance

6th

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) (7th), 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) (1st), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (2nd), 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

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

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

"The solution gives us data lineage which means we can see an impact if we make a change. The ability for us to have that in this company is brilliant because we used to have 49 data stewards from some 23 different groups within six major departments. Each one of those was a silo unto itself. The ability to have different glossaries — but all pointed to the same key terms, key concepts, or key attributes — has made life really simple."

"We always know where our data is, and anybody can look that up, whether they're a business person who doesn't know anything about Informatica, or a developer who knows everything about creating data movement jobs in Informatica, but who does not understand the business terminology or the data that is being used in the tool."

"The biggest impact for us is that erwin generates DDL extremely quickly. We're able to pull in metadata, map it to a target, generate DDL to create the tables, and generate SSIS packages. Previously, especially going back 10 to 15 years ago, hundreds of hours had to be spent to manually perform these tasks. This solution completely automates it and gets it 90% done. We can then pass it off to a developer to create the items in SSIS."

"Being able to capture different business metrics and organize them in different catalogs is most valuable. We can organize these metrics into sales-related metrics, customer-related metrics, supply chain-related metrics, etc."

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

"The solution saves time in data discovery and understanding our entire organization's data."

More erwin Data Intelligence by Quest pros

"It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten."

"REST API: Excellent for scripting control and reporting mechanisms"

"The interface is really good."

"The most valuable feature of Informatica Axon is that it is flexible and user-friendly."

"The product is scalable and excellent for enterprise-level organizations."

"The tool's most valuable feature is bulk upload. We upload files in CSV or Excel format."

"We are able to set rules, establish a data quality management platform, and monitor the quality."

"Informatica is user-friendly, stable, and scalable. These three aspects are the most valuable for us. If we can make it work well with the CRM, we can continue or try again this year to complete that part of the project. I am confident that this kind of solution is what we need because we have a third-party resource that works in the development."

More Informatica Intelligent Data Management Cloud (IDMC) pros

Cons

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

"We chose to implement on an Oracle Database because we also had the erwin Data Modeler and Web Portal products in-house, which have been set up on Oracle Databases for many years. Sometimes the Oracle Database installation has caused some hiccups that wouldn't necessarily have been caused if we had used SQL Server."

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

"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 SDK behind this entire product needs improvement. The company really should focus more on this because we were finding some inconsistencies on the LDK level. Everything worked fine from the UI perspective, but when we started doing some deep automation scripts going through multiple API calls inside the tool, then only some pieces of it work or it would not return the exact data it was supposed to do."

"There are a lot of little things like moving between read screens and edit screens. Those little human interface type of programming pieces will need to mature a bit to make it easier to get to where you want to go to put the stuff in."

"Another area where it can improve is by having BB-Graph-type databases where relationship discovery and relationship identification are much easier."

"The fact that I sometimes have to go in and out of different applications, even though it's all part of the whole erwin suite, perhaps means it could be architected a little bit better. I think they do have some ideas for improvements there."

More erwin Data Intelligence by Quest cons

"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."

"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them."

"The only thing that I can imagine that might be improved is how the available transactions verify addresses used. These transactions have a valid end date and must be used within the agreed timeframe."

"The solution still is a bit manual in its functionality. We want t to be more automation-driven."

"Informatica Cloud Data Integration can improve by being more user-friendly. When you're working with the solution a lot of technical knowledge is required. It's not a solution that anyone can use properly, you need knowledge of what's happening at the back end, such as SQL. When you get stuck, you need to look into your logic. For other tools, such as Dell Boomi, anyone can use them."

"Needs to implement the new workflow with simple steps and a quick visualization with a 360 view of the data."

"The UI is extremely complex"

"The tool should provide a unified user interface to manage the data objects."

More Informatica Intelligent Data Management Cloud (IDMC) cons

Pricing and Cost Advice

"erwin is cheaper than other solutions and this should appeal to other buyers. It has a good price tag."

"The price is reasonable and competitive. When you get into forward and reverse-engineering, the cost could go up. However, if you are a large organization, you would probably be able to access different packages. If, however, you don't need forward and reverse-engineering, then the price is relatively cheap."

"The licensing cost is around $7,000 for user. This is an estimation."

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

"The solution is aggressively priced."

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

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

More erwin Data Intelligence by Quest pricing and cost advice

"The product is very expensive"

"The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly."

"A yearly subscription is paid based on the number of people using the solution. Price-wise, it falls under the medium range since it is neither very costly nor too cheap."

"So, there are plans for licensing. There are subscription-based and usage-based licenses. Also, there are licenses for exceptional analytics, etc. In short, there are different models of licensing for every enterprise."

"I rate the licensing cost of Informatica MDM a five out of ten."

"Its pricing model can be improved."

"I rate the product's pricing a five on a scale of one to ten, where one is cheap and ten is expensive."

"Informatica Cloud Data Integration is famously known for its high price. The vendor targets large enterprises, and not medium or small companies. These large companies, and organizations, handle large amounts of data. If you go into any large bank, such as American or Canadian banks, these banks use this solution because it is more reliable, secure, and has more functionality."

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

831,265 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

21%

Financial Services Firm

12%

Government

Insurance Company

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 17% of the time

Alation Data Catalog vs erwin Data Intelligence by Quest

Compared 11% of the time

Collibra Lineage vs erwin Data Intelligence by Quest

Compared 7% of the time

BigID 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