We performed a comparison between erwin Data Intelligence by Quest and Microsoft Purview Compliance Manager 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."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."
"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."
"The data mapping manager is the most valuable feature."
"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."
"We use the codeset mapping quite a bit to match value pairs to use within the conversion as well. Those value pair mappings come in quite handy and are utilized quite extensively. They then feed into the automation of the source data extraction, like the source data mapping of the source data extraction, the code development, forward engineering using the ODI connector for the forward automation."
"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."
"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."
"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."
"We move data between clouds and also from on-premises to the cloud. There is no other mechanism to check if this data is moving according to industry standards for such things as security, bandwidth, and SSL encryption mechanism. We would not be able to see these metrics without Microsoft Purview Compliance Manager."
"We have more visibility of data and how it is being shared."
"Purview delivers data protection across multi-cloud and multi-platform environments."
"The data quality assessment requires third-party components and a separate license."
"If we are talking about the business side of the product, maybe the Data Literacy could be made a bit simpler. You have to put your hands on it, so there is room for improvement."
"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."
"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."
"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."
"The solution's Arabic language processing is limited. The results are limited when you use the interface in Arabic."
"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 technical support could be improved."
"One area for improvement is the technical support for Purview. With all the other solutions from Microsoft we get really good technical support, but with Purview we had a compliance error and we couldn't find the solution. Purview would not point us to the correct solution, it just indicated the error. We had to troubleshoot it and find out what led to this error. We contacted technical support but it took them one week to identify the root cause of the error."
"We'd like to see the solution expanded to include firewalls and endpoints."
"We've had issues with data connectors for Teams."
More erwin Data Intelligence by Quest Pricing and Cost Advice →
More Microsoft Purview Compliance Manager Pricing and Cost Advice →
erwin Data Intelligence by Quest is ranked 4th in Data Governance with 18 reviews while Microsoft Purview Compliance Manager is ranked 12th in Data Governance with 3 reviews. erwin Data Intelligence by Quest is rated 8.6, while Microsoft Purview Compliance Manager is rated 9.4. 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 Compliance Manager writes "Really good encryption mechanism prevents man-in-the-middle and other types of attacks". erwin Data Intelligence by Quest is most compared with Microsoft Purview Data Governance, Collibra Governance, Alation Data Catalog, Informatica Axon and SAP Data Hub, whereas Microsoft Purview Compliance Manager is most compared with Microsoft Defender XDR, Microsoft Purview Data Governance, Vanta and OneTrust DataGovernance. See our Microsoft Purview Compliance Manager 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.
