No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Purview Data Lifecycle Management vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 1, 2026

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 Modeler
Ranking in Data Governance
10th
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
51
Ranking in other categories
Enterprise Architecture Management (1st), Business Process Design (7th)
Microsoft Purview Data Life...
Ranking in Data Governance
26th
Average Rating
8.2
Reviews Sentiment
5.2
Number of Reviews
4
Ranking in other categories
Email Archiving (9th), Document Management Software (6th), Microsoft Security Suite (27th)
 

Mindshare comparison

As of August 2026, in the Data Governance category, the mindshare of erwin Data Modeler is 0.5%. The mindshare of Microsoft Purview Data Lifecycle Management is 1.2%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Governance Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler0.5%
Microsoft Purview Data Lifecycle Management1.2%
Other98.3%
Data Governance
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
ST
Ict Systems Manager at Lltnpa
Automated retention has transformed compliance workflows and now simplifies audit responses
The deep native integration with Microsoft 365 is what ultimately made me decide on Microsoft Purview Data Lifecycle Management over Enterprise Vault and OpenText Content Manager. Auto-apply retention labels using machine learning is the specific integration with Microsoft 365 that made it the deciding factor for me over Enterprise Vault or OpenText. Manually labeling content at our data volumes is not realistic. The automated classification based on sensitive information types and trainable classifiers is what makes the program actually scale. That feature gets used constantly. We went from inconsistent ad-hoc retention practices to a consistent, automated, documented program across the whole organization with Microsoft Purview Data Lifecycle Management. That shift from a compliance audit perspective is enormous.

Quotes from Members

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

Pros

"Sometimes you have an initial idea for a data model and when you try to design it in Erwin you realize that you were wrong in how you approached it."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"It is an invaluable tool for us; it has been part of our data governance process in regards to database design for at least 15 years."
"I have used most of the modeling tools available, but I found that erwin Data Modeler is the most suitable data modeling tool in our current industry."
"It improved the way we were able to manage our models."
"erwin Data Modeler's ability to generate database code from a model for a wide array of data sources saves time in development, as utilizing the solution allows me to accomplish tasks in minutes compared to the extended time required for manual processes."
"The process of creating visual representations of data structures using erwin Data Modeler allows you to see everything you are doing, and you have visuals to see what you are going to do and what has been done so far."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"We went from inconsistent ad-hoc retention practices to a consistent, automated, documented program across the whole organization with Microsoft Purview Data Lifecycle Management."
"The system is stable; I haven't encountered any worldwide stability issues unlike other office products."
"The UI is the most valuable feature."
"The impact of Microsoft Purview Data Lifecycle Management on my unified data catalog has improved a lot; the improvements I see are in the lineage, the discovery, and the labeling."
 

Cons

"There is a lack of local support in the China region."
"The one drawback is if you have an extremely large complex model, the compare process can take quite a bit of time, more than four hours."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"While I do not have knowledge about pricing for erwin Data Modeler, I think it could improve by having a feature that allows the publishing of models, similar to how Power BI allows for dashboard publishing for different users within an organization, not just data modelers."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
"What I did not like was that sometimes while I was creating relations, I was not getting errors. The errors only appeared when I tried to upload the model into a new database, which took a lot of time because I was creating a model, reproducing XML, and then trying to add the XML in the database."
"Sometimes when I want to open the attribute editor, it stops working and the whole application freezes."
"I think labeling could use a lot more AI assistance. AI implementation into labeling would be beneficial."
"The initial setup took longer than we expected. Microsoft Purview Data Lifecycle Management is not a turn-it-on-and-go product."
"Microsoft's Purview Data Lifecycle Management preview features can be unreliable, hindering their usefulness."
"The time it takes to scan is one issue; when we raise high-volume issues and tickets related to scanning failures, it relates to permission errors, which are technical challenges."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"erwin Data Modeler by Quest is an expensive solution."
"The tool is expensive."
"An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"The service operates on a pay-as-you-go basis, charging an extra one cent per field of metadata scanned in our data."
report
Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
909,725 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Marketing Services Firm
7%
Manufacturing Company
6%
Government
6%
Computer Software Company
12%
Government
11%
Financial Services Firm
9%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise42
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
I have no idea about the setup cost because I did not buy the license.
What needs improvement with erwin Data Modeler by Quest?
The UI in erwin Data Modeler can be improved significantly because when any new person opens the tool, all the toolbars are kept open with many tools in view, making it appear chunky. If possible, ...
What is your primary use case for erwin Data Modeler by Quest?
I primarly use erwin Data Modeler for modeling purposes. Once we have the business requirement, we create the models in erwin Data Modeler, and then we perform forward engineering to get the query ...
What needs improvement with Microsoft Purview Data Lifecycle Management?
Better coverage outside Microsoft 365 is a feature I wish Microsoft Purview Data Lifecycle Management had that it does not offer today. If I could change one thing about Microsoft Purview Data Life...
What is your primary use case for Microsoft Purview Data Lifecycle Management?
Automating retention and deletion across our Microsoft 365 environment is my main use case for Microsoft Purview Data Lifecycle Management. At Microsoft scale, Exchange, SharePoint, OneDrive, and T...
What advice do you have for others considering Microsoft Purview Data Lifecycle Management?
Microsoft Purview Data Lifecycle Management implementation is very much a team-wide effort. The policies apply organization-wide across all Microsoft 365 users. The management side, configuring pol...
 

Also Known As

erwin DM
Microsoft Information Governance, Microsoft Purview Records Management
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Information Not Available
Find out what your peers are saying about Microsoft Purview Data Lifecycle Management vs. erwin Data Modeler and other solutions. Updated: August 2026.
909,725 professionals have used our research since 2012.