Microsoft Purview vs erwin Data Intelligence by Quest comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between erwin Data Intelligence by Quest and Microsoft Purview based on real PeerSpot user reviews.

Find out in this report how the two Data Governance solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Microsoft Purview vs. erwin Data Intelligence by Quest Report (Updated: March 2024).
765,386 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""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.""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.""Overall, DI's data cataloging, data literacy, and automation have helped our decision-makers because when a source wants to change something, we immediately know what the impact is going to be downstream.""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.""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.""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.""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."

More erwin Data Intelligence by Quest Pros →

"It gives you the opportunity to know your data and apply policies around it. If those policies are flouted, you can always track what's happening. You have options such as alerting the person who is committing that action, or you can take automatic action by blocking, for example, an email that is been sent externally. It's very useful.""The most valuable feature is the tracking activity and device onboarding.""The custom classifications are one of the most valuable features.""Has a good interface and is reasonably priced.""You can set up automated dates to alert on internal data.""The e-discovery search is useful.""It's certainly easy to work with all Microsoft data sources like SQL Server, Synapse, and data lakes, but it also has great functionality working with Oracle. And of particular interest to us is the ability to pull data from Excel, CVS files, and other types of flat files.""It is pretty early, but the decision to go with this investment was largely driven by the simplification of our information security technology management stack. That is the primary objective. Once you simplify and you have a connected structure, it allows for faster adoption there. It also gives us additional capabilities as we go on using the technology that we are familiar with, and we do not have to depend on outside parties to come in and tell us how to do certain things."

More Microsoft Purview Pros →

Cons
"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.""The technical support could be improved.""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.""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.""Another area where it can improve is by having BB-Graph-type databases where relationship discovery and relationship identification are much easier.""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.""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."

More erwin Data Intelligence by Quest Cons →

"The product must provide better integrations with OS X and iOS.""It supports only a limited number of tools and technologies that pertain to Microsoft products. If you want to leverage other solutions such as Workday or Oracle Fusion, features will be coming up, but as of now, it is for the Microsoft suite.""Another area for improvement is in managing the business glossary terms. If they could provide the same type of method that we use to configure the scan rule sets, that would be helpful. Currently, there is no option like this, so we have to do it manually. Automatic detection would be great.""The product needs improvement to edit the number of assets. It needs to be more inuitive as well.""The overall cost of deploying this solution could be better. It seems that middle and small-sized organizations are not completely happy with deploying this solution in terms of the cost. It would be good if they concentrate on the cost part.""The current event-based retention management is very poor.""Blueprints and landing zones like we have in Azure would be great to see in Purview. The solution could offer a baseline or blueprint of recommended settings for compliance regulations such as GDPR and ISO, which could be applied with a simple switch in the options.""One area for improvement is the detection of data types. This is really important. It has some of that functionality, but I consider it very limited. Maybe they can add some custom programming or machine learning could be particularly useful for the detection of the nature of the data."

More Microsoft Purview Cons →

Pricing and Cost Advice
  • "The licensing cost is around $7,000 for user. This is an estimation."
  • "There is an additional fee for the server maintenance."
  • "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."
  • "erwin's pricing was cheaper than its competitors."
  • "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."
  • "erwin is cheaper than other solutions and this should appeal to other buyers. It has a good price tag."
  • "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."
  • "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."
  • More erwin Data Intelligence by Quest Pricing and Cost Advice →

  • "The pricing is moderate. It's not too expensive, but it's not the most competitive."
  • "Microsoft Purview is the best option I have encountered when it comes to price. Maybe some of my information is outdated, but Microsoft offered it so that you could use it almost without paying."
  • "There is some competition out there, but the other solutions are quite expensive. They are enterprise tools that are a bit more mature but the license costs $100,000 for some of them. Purview is pay-per-use and a lot of companies are interested in that."
  • "Aside from the complexity of the pricing model, the price itself is realistic. Features like AI components and automatic classification require additional licenses. Still, anyone can start using Purview with a basic E3 license if they're using Microsoft 365 and grow with additional licenses as needed. Overall, we're satisfied with the price."
  • "Its pricing is good in terms of the features that they are providing, but there are many competitors in the market who can easily provide you with similar services at a lesser cost."
  • "The categorization within the licensing could be improved. There are a lot of solutions within Microsoft Purview. If the licensing could be a bit clearer and the solutions could be better categorized according to function and across multiple environments, that would be excellent. The licensing is very confusing."
  • "Price-wise, I think it's very generous and accessible to not just enterprises but small to medium-sized companies as well. I think it's very fair in terms of how they break apart the storage and the actual computing, and that makes it very accessible. So, that is a very big plus for Purview."
  • "Some people find the tier licensing system complicated, but it offers a lot of value for money if we use the features."
  • More Microsoft Purview Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
    765,386 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The data mapping manager is the most valuable feature.
    Top Answer: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… more »
    Top Answer:It is designed to seamlessly connect to various data sources, which is particularly beneficial for our customers who primarily use Microsoft technologies.
    Top Answer:Currently, the licensing differs for the governance side compared to the risk and compliance side. On the governance side, the charges are based on the usage of Purview, including the data map, data… more »
    Top Answer:Data quality has been a highly requested feature among customers. While it was initially scheduled for release in December last year, I anticipate that this feature will be available soon this year. I… more »
    Ranking
    3rd
    out of 57 in Data Governance
    Views
    5,066
    Comparisons
    1,581
    Reviews
    11
    Average Words per Review
    1,311
    Rating
    8.4
    1st
    out of 57 in Data Governance
    Views
    26,764
    Comparisons
    13,202
    Reviews
    45
    Average Words per Review
    1,368
    Rating
    7.6
    Comparisons
    Also Known As
    erwin DG, erwin Data Governance
    MS Azure Purview
    Learn More
    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.

    Microsoft Purview is a unified data governance solution that helps you understand all of your on-premises, multi cloud, and software-as-a-service (SaaS) data and maintain control over its usage. With the Microsoft Purview solution, you can create a detailed, up-to-date map of your data landscape with sensitive data classification, automated data discovery, and end-to-end data lineage. Not only does it enable data curators to easily secure your data, but it also allows data consumers to find valuable, trustworthy data.

    Microsoft Azure Purview is designed with:

    • Data Map: Microsoft Purview Data Map provides the foundation for data discovery and effective data governance. Azure Purview Data Map is a cloud-native PaaS service that captures metadata about enterprise data present in analytics and operation systems on premises and in the cloud.

    • Data Catalog: Microsoft Purview Data Catalog finds trusted data sources by browsing and searching your data assets. The data catalog aligns your assets with business terms and data classification to identify data sources.

    • Data Insights: Microsoft Purview Data Insights gives you an overview of your data estate to help you discover what kinds of data you have and where.

    Microsoft Purview Features

    Microsoft Purview has many valuable key features. Some of the most useful ones include:

    • Automated data discovery, lineage identification, and data classification
    • Insights into the location and movement of sensitive data across your entire data estate
    • Unified map of your data assets and their relationships for more effective data governance
    • Glossary with business and technical search terms to aid data discovery

    Microsoft Purview Benefits

    Some of the benefits of using Microsoft Azure Purview include:

    • Automate and manage metadata from hybrid sources.
    • Classify data using built-in and custom classifiers and Microsoft Information Protection sensitivity labels.
    • Label sensitive data consistently across SQL Server, Azure, Microsoft 365, and Power BI.
    • Easily integrate all your data systems using Apache Atlas APIs.
    • Search for data using technical or business terms.
    • Easily understand data by browsing associated technical, business, semantic, and operational metadata.
    • Quickly identify the sensitivity level of data.
    • Scan your Power BI environment and Azure Synapse Analytics workspaces with a few clicks.
    • Automatically publish all discovered assets and lineage to the Purview Data Map.
    • Connect Microsoft Azure Purview to Azure Data Factory instances to automatically collect data integration lineage.
    • Quickly determine which analytics and reports already exist without reinventing the wheel.

    Reviews from Real Users

    PeerSpot reviewer Kelly B., Solution Specialist at LobsterPot Solutions, says, “We're building a new system from scratch for our clients and wanted to include data governance. Their solution is hosted in Azure and it seemed logical to go with something that fits with that. Purview has a pretty good interface and I'm satisfied with what the solution does and the price it's being sold at. It integrates well with Azure technologies.” She also adds, “The initial setup was very easy, that's part of the appeal.”

    Sample Customers
    Oracle, Infosys, GSK, Toyota Motor Sales, HSBC
    Information Not Available
    Top Industries
    REVIEWERS
    Insurance Company28%
    Computer Software Company22%
    Pharma/Biotech Company22%
    Healthcare Company6%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Financial Services Firm12%
    Government11%
    Insurance Company8%
    REVIEWERS
    Financial Services Firm21%
    Computer Software Company11%
    University11%
    Comms Service Provider7%
    VISITORS READING REVIEWS
    Computer Software Company14%
    Financial Services Firm13%
    Government9%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business5%
    Midsize Enterprise21%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business25%
    Midsize Enterprise12%
    Large Enterprise64%
    REVIEWERS
    Small Business34%
    Midsize Enterprise20%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    Buyer's Guide
    Microsoft Purview vs. erwin Data Intelligence by Quest
    March 2024
    Find out what your peers are saying about Microsoft Purview vs. erwin Data Intelligence by Quest and other solutions. Updated: March 2024.
    765,386 professionals have used our research since 2012.

    erwin Data Intelligence by Quest is ranked 3rd in Data Governance with 18 reviews while Microsoft Purview is ranked 1st in Data Governance with 48 reviews. erwin Data Intelligence by Quest is rated 8.4, while Microsoft Purview is rated 7.6. The top reviewer of erwin Data Intelligence by Quest writes "Enabled us to centralize a tremendous amount of data into a common standard, and uniform reporting has decreased report requests". On the other hand, the top reviewer of Microsoft Purview writes "User friendly with good documentation but needs to cover more non-Microsoft use cases". erwin Data Intelligence by Quest is most compared with Collibra Governance, Alation Data Catalog, Informatica Axon, Collibra Lineage and Microsoft Purview Compliance Manager, whereas Microsoft Purview is most compared with Collibra Governance, Alation Data Catalog, Varonis Platform, Informatica Axon and IBM Data Governance. See our Microsoft Purview vs. erwin Data Intelligence by Quest report.

    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.