Microsoft Purview Data Lifecycle Management vs erwin Data Modeler comparison

Quest Software and Microsoft are both solutions in the Data Governance category. Additionally, 95% of Quest Software users are willing to recommend the solution, compared to 100% of Microsoft users who would recommend it.

erwin Data Modeler

Read 39 erwin Data Modeler reviews

95% willing to recommend

Microsoft Purview Data Life...

Read 3 Microsoft Purview Data Lifecycle Management reviews

490 Views
348 Comparison Views

100% willing to recommend

erwin Data Modeler

Microsoft Purview Data Life...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between erwin Data Modeler and Microsoft Purview Data Lifecycle Management based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Collibra and others in Data Governance.

To learn more, read our detailed Data Governance Report (Updated: July 2025).

Buyer's Guide

Data Governance

July 2025

Download the complete report

Helped 865,384 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 Modeler

Average Rating

8.6

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (4th), Business Process Design (10th)

Microsoft Purview Data Life...

Average Rating

7.4

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

Data Governance (28th), Microsoft Security Suite (34th)

Featured Reviews

JorgeSanz

Data Governance Senior Advisor at Abu Dhabi National Oil Company

Streamline data modeling and automate network changes for increased efficiency

The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.

Read full review

Al Mcpherson

Data Architect at Octopus

Provides clear visibility into our entire information estate, reduces our time to action, and saves us time

The integration across Azure is straightforward. Microsoft Purview Data Lifecycle Management has been a game-changer for our data governance. We now have clear visibility into our entire information estate, allowing us to pinpoint data location and implement effective classification. Even though real-time compliance isn't a current need, Microsoft Purview Data Lifecycle Management offers that capability for future requirements. Purview Data Lifecycle Management has reduced our time to action – since we previously lacked such a tool, it's effectively cut our response time in half. Purview Data Lifecycle Management has saved us one working day per month.

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

"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."

"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."

"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."

"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."

"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."

"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."

"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."

"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."

More erwin Data Modeler pros

"The automatic data labeling is compelling, and we are investigating its use."

"Purview's built-in functionality provides immediate access to reports, streamlining the entire process."

"The UI is the most valuable feature."

"The system is stable; I haven't encountered any worldwide stability issues unlike other office products."

Cons

"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."

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

"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."

"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."

"As someone who has used it for a long time, I have seen stability vary from version to version."

"This is a very complex product."

"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."

"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."

More erwin Data Modeler cons

"Microsoft Purview Data Lifecycle Management can be challenging to implement due to its complexity and dense documentation, making it difficult to get started."

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

"Microsoft Purview Data Lifecycle Management can be challenging to implement due to its complexity and dense documentation, making it difficult to get started."

"Microsoft's Purview Data Lifecycle Management preview features can be unreliable, hindering their usefulness."

Pricing and Cost Advice

"The price of erwin Data Modeler is very expensive, in particular for this part of the world."

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

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

"Pricing is very high compared to any other product."

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."

"I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."

"erwin Data Modeler by Quest is an expensive solution."

"The tool is expensive."

More erwin Data Modeler pricing and cost advice

"The service operates on a pay-as-you-go basis, charging an extra one cent per field of metadata scanned in our data."

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

865,384 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Manufacturing Company

Government

Computer Software Company

15%

Financial Services Firm

13%

Manufacturing Company

10%

Retailer

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about erwin Data Modeler by Quest?

Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.

See all answers

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?

The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.

See all answers

What needs improvement with erwin Data Modeler by Quest?

As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...

See all answers

What is your experience regarding pricing and costs for Microsoft Purview Data Lifecycle Management?

We opted for Purview Data Lifecycle Management due to its significant cost advantage over competitors. At a 95 percent price reduction, it was a clear winner. The service operates on a pay-as-you-g...

See all answers

What needs improvement with Microsoft Purview Data Lifecycle Management?

One of the requirements is to have data leak policies and data access policies. This is very critical to enforce data governance standards, which relate to data classification, access control, data...

See all answers

What is your primary use case for Microsoft Purview Data Lifecycle Management?

I am a customer and user of the tools. We are a big shop, and both the companies I work for are Microsoft Office 365 customers with over eighty thousand seats. Microsoft Purview Data Lifecycle Mana...

See all answers

Comparisons

SAP PowerDesigner vs erwin Data Modeler

Compared 36% of the time

IDERA ER/Studio vs erwin Data Modeler

Compared 18% of the time

Lucidchart vs erwin Data Modeler

Compared 12% of the time

Visio vs erwin Data Modeler

Compared 6% of the time

Sparx Systems Enterprise Architect vs erwin Data Modeler

Compared 6% of the time

More erwin Data Modeler Competitors

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

Compared 78% of the time

Alation Data Catalog vs Microsoft Purview Data Lifecycle Management

Compared 22% of the time

More Microsoft Purview Data Lifecycle Management Competitors

Product Reports

Buyer's Guide

erwin Data Modeler

August 2025

Download erwin Data Modeler product report

Buyer's Guide

Data Governance

July 2025

Microsoft Purview Data Lifecycle Management report

Download Microsoft Purview Data Lifecycle Management product report

Also Known As

erwin DM

Microsoft Information Governance

Overview

Erwin Data Modeler provides an effective approach to visualizing and managing data models. It assists in creating, reversing, and synchronizing data models with ease, supporting logical and physical transitions while enhancing understanding across teams.

Erwin Data Modeler is a comprehensive tool designed for professional database management. It offers capabilities to organize and enforce standards, automating script generation with robust reverse engineering and DDL output. Users can manage complex data environments, capitalize on integration with data intelligence, and maintain large-scale databases smoothly. Despite its strengths, improvements in multi-language support, database integration, and reporting features are needed. Users benefit from extensive support for conceptual, logical, and physical database modeling, enhancing architectural design and data governance for platforms like SQL Server, Oracle, and Teradata.

What are the key features of Erwin Data Modeler?

Visual Representation: Facilitates clear visualization of data models, aiding comprehension.
Versioning and Editing: Enhance usability with versioning and bulk editing capabilities.
Reverse Engineering: Offers powerful tools for reverse engineering and DDL generation.
Integration: Aligns with data intelligence to streamline database management.
Naming Standards: Enforces consistency with automated script creation.

What benefits should users consider in Erwin Data Modeler reviews?

Collaboration: Promotes team understanding and collaboration through visual tools.
Automation: Reduces manual effort through automated processes and integration.
Scalability: Handles large database management efficiently, crucial for enterprise settings.
Data Governance: Facilitates effective data governance with structured modeling.

Erwin Data Modeler finds application in industries focused on robust data management, implementing it for enterprise data warehouses, business domain models, and operational systems. It supports architectural design and governance, aligning with business applications demanding precise data representation and visualization.

Quest Software

Use Microsoft Information Governance (sometimes abbreviated to MIG) capabilities to govern your data for compliance or regulatory requirements.

To learn more about our solution, ask questions, and share feedback, join our Microsoft Security, Compliance and Identity Community.

Microsoft

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, Informatica, Collibra and others in Data Governance. Updated: July 2025.

DOWNLOAD NOW

865,384 professionals have used our research since 2012.

See our list of best Data Governance vendors.

We monitor all Data Governance reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.