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 813,418 peers since 2012

Categories and Ranking

erwin Data Intelligence by ...

Ranking in Data Governance

5th

Average Rating

8.6

Number of Reviews

Ranking in other categories

No ranking in other categories

Informatica Intelligent Dat...

Ranking in Data Governance

2nd

Average Rating

8.0

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 (8th), 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 (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)

Featured Reviews

Roy Pollack

Advisor Application Architect at CPS Energy

Sep 26, 2022

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

Data Intelligence enables us to provide deeper technical insight into our enterprise data warehouse while democratizing the solution and data. For more than 10 years, we had built our data systems without detailed documentation. We finally determined that we needed to improve our data management…

Read full review

Raj Sethupathi

Data Integration Consultant GCP/AWS at Infogrators Inc

Jun 13, 2024

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

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

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

"There is a wide range of widgets that enables the user to find the proper information quickly. The presentation of information is something very valuable."

"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 possibility to write automation scripts is the biggest benefit for us. We have several products with metadata and metadata mapping capabilities. The big difference when we were choosing this product was the ability to run automation scripts against metadata and metadata mappings. Right now, we have a very high level of automation based on these automation scripts, so it's really the core feature for us."

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

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

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

More erwin Data Intelligence by Quest pros

"Axon has something called Overlay, which can be used to extend the technical lineage."

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

"The capability of the tool to scan and capture the metadata from a variety of sources is one of the capabilities that I find most useful. The central repository into which it is going to put that captured metadata is the best."

"The most important features are the mastering of the data and the UI intuitiveness."

"The solution provides increased efficiency while still being user-friendly and easy to operate."

"It is very useful for testing purposes and designing mappings for small projects. If you go for IDQ in the mapping itself, you can see the data. You can then correct it, and test it so easily. It is working fine. It is also stable, scalable, and easy to deploy."

"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."

"We use parts and standardization for most of our testing. We purchase the US Postal Service address database, which is updated periodically. Many useful tools, such as Google Maps, can detect and mark new businesses or changes in business locations. Informatica captures and updates this information. Some periodic maintenance is involved, but setting it up is not overly complicated."

More Informatica Intelligent Data Management Cloud (IDMC) pros

Cons

"The data quality assessment requires third-party components and a separate license."

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

"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 metadata ingestion is very nice because of the ability to automate it. It would be nice to be able to do this ingestion, or set it up, from one place, instead of having to set it up separately for every data asset that is ingested."

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

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

"It's a little bit clunky. I think a lot of these features were bolted on, and they don't necessarily transition smoothly in the interface. I would like to see a little more cohesion."

"Everything about Data Intelligence is complex. Though we've used the tool for five years, we're still only using about 30 to 40 percent of its capabilities. It would be helpful if we could customize and simplify the user interface because there are so many redundant things."

More erwin Data Intelligence by Quest cons

"The current features are a bit complicated, and we need to write big scripts and test."

"Cost-wise, it could be better."

"There is room for improvement in the Data Marketplace aspect."

"We cannot sell the product directly with an additional layer."

"The integration process is not easy."

"The configuration process is pretty lengthy and challenging and could be made easier to understand."

"There's certainly room for improvement. One crucial area is generating detailed reports on file statuses. Presently, this is represented visually, often as graphs or charts. Such reporting could offer comprehensive insights into the areas that demand attention and further scrutiny."

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

More Informatica Intelligent Data Management Cloud (IDMC) cons

Pricing and Cost Advice

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

"You buy a seat license for your portal. We have 100 seats for the portal, then you buy just the development licenses for the people who are going to put the data in."

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

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

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

"Smart Data Connectors have some costs, and then there are user-based licenses. We spend roughly $150,000 per year on the solution. It is a yearly subscription license that basically includes the cost for Smart Data Connectors and user-based licenses. We have around 30 data stewards who maintain definitions, and then we have five IT users who basically maintain the overall solution. It is not a SaaS kind of operation, and there is an infrastructure cost to host this solution, which is our regular AWS hosting cost."

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

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

More erwin Data Intelligence by Quest pricing and cost advice

"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."

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

"It is an expensive solution. I would say it is the most expensive solution in the market."

"It's offers value for money. They're more competitive with respect to pricing and offerings."

"The platform has a premium cost. I rate the pricing as seven out of ten."

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

"We are quite happy with the licensing model."

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

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

813,418 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

13%

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

Collibra Governance vs erwin Data Intelligence by Quest

Compared 19% of the time

Alation Data Catalog vs erwin Data Intelligence by Quest

Compared 13% of the time

Collibra Lineage vs erwin Data Intelligence by Quest

Compared 6% of the time

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

Compared 6% of the time

More erwin Data Intelligence by Quest Competitors

Informatica PowerCenter vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 10% of the time

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

Compared 8% of the time

Reltio Cloud vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 5% of the time

AWS Glue vs Informatica Intelligent Data Management Cloud (IDMC)

Compared 4% of the time

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

Compared 3% 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