No more typing reviews! Try our Samantha, our new voice AI agent.
erwin Data Intelligence Logo

erwin Data Intelligence pros and cons

4.2 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

erwin Data Intelligence provides automation for tasks like metadata restructuring and ETL flow setup, leading to significant time and cost savings.
erwin Data Intelligence serves as a centralized repository, creating a single source of truth for business rules and data lineage, improving organizational alignment.
Data classification, data quality checks, and governance are enhanced, allowing for better decision-making and access control.
The ability to create automation scripts enhances productivity by enabling high-level automation, particularly in metadata mapping.
Data lineage visibility helps illustrate the impact of changes across various departments, simplifying governance and management.

CONS

Data quality assessment in erwin Data Intelligence requires additional layers and often needs third-party components and separate licenses.
Arabic language processing is limited, resulting in restricted outcomes when the interface is used in Arabic.
There is a significant learning curve, even for experienced software developers, due to the complex architecture and operation of erwin Data Intelligence.
The integration with various metadata sources, including erwin Data Modeler, is not smooth and took considerable effort to get working properly.
Huge datasets can cause erwin Data Intelligence to crash or hang, highlighting performance issues with very large data environments.
 

erwin Data Intelligence Pros review quotes

Jog Raj - PeerSpot reviewer
Senior Consultant at a computer software company with 11-50 employees
Dec 5, 2025
The main benefits end users receive from erwin Data Intelligence include saving time and money while streamlining processes.
MR
Data Unit Manger at a manufacturing company with 1,001-5,000 employees
Feb 12, 2026
The main benefits erwin Data Intelligence provides to me include better decision-making, saving money and time by applying governance policies and procedures on the actual technical data, ensuring decisions are based on KPIs that are governed from source to end, and providing functionality for data classification to prevent unauthorized access through integration with the infrastructure team using DLP methodology.
it_user1578072 - PeerSpot reviewer
Senior Director at a retailer with 10,001+ employees
May 16, 2021
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.
Learn what your peers think about erwin Data Intelligence. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,164 professionals have used our research since 2012.
reviewer2253402 - PeerSpot reviewer
Delivery Director at a computer software company with 1,001-5,000 employees
Aug 9, 2023
The data mapping manager is the most valuable feature.
reviewer2230059 - PeerSpot reviewer
Project Coordinator at a computer software company with 201-500 employees
Jul 7, 2023
Mind map... is a really good feature because it is very helpful in seeing which column's tables are related. Also, you can flag them with "sensitive data" and other indicators. You can also customize your own features for the mind map. That was another very robust feature.
TZ
Analyst at Roche
May 29, 2023
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.
reviewer1935849 - PeerSpot reviewer
Architect at a insurance company with 10,001+ employees
Aug 10, 2022
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.
reviewer2056512 - PeerSpot reviewer
Works at a insurance company with 5,001-10,000 employees
Dec 18, 2022
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.
Roy Pollack - PeerSpot reviewer
Advisor Application Architect at CPS Energy
Sep 26, 2022
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.
reviewer2197947 - PeerSpot reviewer
Senior Solution Architect at a pharma/biotech company with 10,001+ employees
May 29, 2023
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.
 

erwin Data Intelligence Cons review quotes

Jog Raj - PeerSpot reviewer
Senior Consultant at a computer software company with 11-50 employees
Dec 5, 2025
I find that the time taken to realize value from erwin Data Intelligence can be quite long.
MR
Data Unit Manger at a manufacturing company with 1,001-5,000 employees
Feb 12, 2026
In my opinion, the analytics part of erwin Data Intelligence is not satisfactory.
it_user1578072 - PeerSpot reviewer
Senior Director at a retailer with 10,001+ employees
May 16, 2021
There may be some opportunities for improvement in terms of the user interface to make it a little bit more intuitive. They have made some good progress. Originally, when we started, we were on version 9 or 10. Over the last couple of releases, I've seen some improvements that they have made, but there might be a few other additional areas in UI where they can make some enhancements.
Learn what your peers think about erwin Data Intelligence. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,164 professionals have used our research since 2012.
reviewer2253402 - PeerSpot reviewer
Delivery Director at a computer software company with 1,001-5,000 employees
Aug 9, 2023
The data quality assessment requires third-party components and a separate license.
reviewer2230059 - PeerSpot reviewer
Project Coordinator at a computer software company with 201-500 employees
Jul 7, 2023
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.
TZ
Analyst at Roche
May 29, 2023
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.
reviewer1935849 - PeerSpot reviewer
Architect at a insurance company with 10,001+ employees
Aug 10, 2022
We still need another layer of data quality assessments on the source to see if it is sending us the wrong data or if there are some issues with the source data. For those things, we need a rule-based data quality assessment or scoring where we can assess tools or other technology stacks. We need to be able to leverage where the business comes in, defining some business rules and have the ability to execute those rules, then score the data quality of all those attributes. Data quality is definitely not what we are leveraging from this tool, as of today.
reviewer2056512 - PeerSpot reviewer
Works at a insurance company with 5,001-10,000 employees
Dec 18, 2022
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.
Roy Pollack - PeerSpot reviewer
Advisor Application Architect at CPS Energy
Sep 26, 2022
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.
reviewer2197947 - PeerSpot reviewer
Senior Solution Architect at a pharma/biotech company with 10,001+ employees
May 29, 2023
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.