We performed a comparison between erwin Data Intelligence by Quest and Microsoft Purview Data Governance 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."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."
"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."
"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 biggest benefit with erwin DI is that I have a single source of truth that I can send anybody to. If anybody doesn't know the answer we can go back to it. Just having a central location of business rules is good."
"The data management is, obviously, key in understanding where the data is and what the data is. And the governance can be done at multiple levels. You have the governance of the code sets versus the governance of the business terms and the definitions of those business terms. You have the governance of the business data models and how those business data models are driving the physical implementation of the actual databases. And, of course, you have the governance of the mapping to make sure that source-to-target mapping is done and is being shared across the company."
"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."
"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."
"The data mapping manager is the most valuable feature."
"The documentation is very exhaustive. Anyone can go ahead and try different use cases."
"My favorite features are eDiscovery and insider risk management, because these are the major threats to an organization that can't be easily traced."
"We can prevent, block, or audit however we like."
"The availability of pre-designed policies tailored to specific geolocations and customer requirements is a valuable feature."
"It is designed to seamlessly connect to various data sources, which is particularly beneficial for our customers who primarily use Microsoft technologies."
"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."
"From my experience and customer feedback, one of the most valuable features of Microsoft Purview is ease of use, especially for content hosted within Microsoft 365 and Azure. I also like that the pricing model for the solution is reasonable."
"Microsoft Purview's most valuable feature is its ability to identify content across a number of prescribed regulatory frameworks, including Microsoft, GDPR, PII, and UCC Financial."
"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 is room for improvement with the data cataloging capability. Right now, there is a list of a lot of sources that they can catalog, or they can create metadata upon, but if they can add more then that would be a good plus for this tool."
"The fact that I sometimes have to go in and out of different applications, even though it's all part of the whole erwin suite, perhaps means it could be architected a little bit better. I think they do have some ideas for improvements there."
"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."
"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."
"One big improvement we would like to see would be the workflow integration of codeset mapping with the erwin source to target mapping. That's a bit clunky for us. The two often seem to be in conflict with one another. Codeset mappings that are used within the source to target mappings are difficult to manage because they get locked."
"The technical support could be improved."
"Data quality has been a highly requested feature among customers."
"Enhancing the tool's capability to connect to multiple sources would be valuable."
"We have had some issues automating our document management with Power Apps. I haven't been super-disappointed with anything except for Power Apps, which kinda drives me nuts. I think it's because I am a coder who can do things properly, and I keep trying to do things there, but it's not working out the way. The security team is pretty quick. I'm kind of a thorn in their side. I always try to get around stuff. They haven't come to me for anything saying, "Hey, I can't find this information." They're pretty good. Maybe, there's a lack of documentation, but that doesn't seem to be an issue for our team."
"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."
"There are some non-Microsoft file formats that are not supported."
"The Microsoft Purview data connector platform, which supports ingestion from non-Microsoft data sources, can be somewhat complex."
"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."
"Running eDiscovery once a day takes quite a long time because it has to fetch your data. I also want the eDiscovery results to be improved. At the same time, I would like to get a centralized page where I could see records management applied to my Office 365 tenant visualized instead of waiting for a custom script to run through the complete tenant."
More erwin Data Intelligence by Quest Pricing and Cost Advice →
More Microsoft Purview Data Governance Pricing and Cost Advice →
erwin Data Intelligence by Quest is ranked 4th in Data Governance with 18 reviews while Microsoft Purview Data Governance is ranked 1st in Data Governance with 48 reviews. erwin Data Intelligence by Quest is rated 8.6, while Microsoft Purview Data Governance 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 Data Governance 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 AtScale Adaptive Analytics (A3), whereas Microsoft Purview Data Governance is most compared with Collibra Governance, Alation Data Catalog, Varonis Platform, Informatica Axon and IBM Data Governance. See our Microsoft Purview Data Governance 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.