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."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."
"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."
"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 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."
"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 data mapping manager is the most valuable feature."
"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."
"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."
"One of the best features is the classification rules, especially the scan rule sets. They are really useful, especially when we need to understand the current data the company has to ensure that all the problematic data can be put under someone's responsibility."
"The time to onboard is pretty short."
"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 most valuable feature is the tracking activity and device onboarding."
"I really like the entire system for auto-labeling content. It's a very refined system. I use the Keyword Query Language to define refined string-based metadata, and then I can really go deep into the specific data with the specific properties labeled in such and such a way."
"The availability of pre-designed policies tailored to specific geolocations and customer requirements is a valuable feature."
"The cataloging tool is definitely the most valuable... It tells you about all the data you have in your tables, which helps people understand our data. We now know what data we have."
"It is very easy to learn the interface, and it is very user-friendly."
"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 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."
"It's a little bit clunky. I think a lot of these features were bolted on, and they don't necessarily transition smoothly in the interface. I would like to see a little more cohesion."
"We chose to implement on an Oracle Database because we also had the erwin Data Modeler and Web Portal products in-house, which have been set up on Oracle Databases for many years. Sometimes the Oracle Database installation has caused some hiccups that wouldn't necessarily have been caused if we had used SQL Server."
"The technical support could be improved."
"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."
"The solution's Arabic language processing is limited. The results are limited when you use the interface in Arabic."
"There are some non-Microsoft file formats that are not supported."
"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."
"Setting up Purview in a production tenant proved challenging due to a lack of clear documentation on permission requirements."
"Some of the menu headings may not be easy to understand for some people."
"Data quality has been a highly requested feature among customers."
"Non-Microsoft use cases are not very high. It's limited for now."
"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."
"Enhancing the tool's capability to connect to multiple sources would be valuable."
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 51 reviews. erwin Data Intelligence by Quest is rated 8.6, while Microsoft Purview Data Governance is rated 7.8. 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.