We performed a comparison between erwin Data Intelligence by Quest and SAS Data Management based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Collibra, Informatica and others in Data Governance."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."
"erwin has tremendous capabilities to map right from the business technologies to the endpoint, such as physical entities and physical attributes, from a lineage standpoint."
"They have just the most marvelous reports called mind maps, where whatever you are focused on sits in the middle. They have this wonderful graphic spiderweb that spreads out from there where you can see this thing mapped to other logical bits or physical bits and who's the steward of it. It's very cool and available to your business teams through a portal."
"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 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."
"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 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."
"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."
"In terms of which features I have found most valuable, I would say the importing and exporting features. Additionally, the data sorting, categorizing and summarizing features, especially how it can summarize based on categories. These are the key features."
"The product offers very good flexibility."
"I am impressed with the tool's ability to customize."
"This is an established product with powerful data analysis and varied options for user entry points."
"Its robustness is valuable. It is a full-fledged suite. We have a data warehouse model, and there are also a lot of data quality management tools. The repository and all other tools are there. So, it is a full package in terms of reporting tools."
"The technical support is excellent."
"The tool is reliable, quick, and powerful."
"If you compare it to SQL, the memory and development times are very quick."
"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."
"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."
"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."
"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."
"The data quality assessment requires third-party components and a separate license."
"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."
"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."
"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."
"One problem is accessing the data using a solution other than SAS. The SAS data, which we create in the SAS, cannot be accessed by other tools. We can't open those data in other applications. So we need to have that application in place."
"Very little needs to improve but perhaps a nicer graphic interface and remaining competetive in the growing field of data analytics."
"The solution is quite expensive and hard to install/configure."
"I would like the tool to include the ability to automate the modifications of the integrations."
"We implemented it a while ago, and we are trying to improve the data delivery performance. We are looking into how to get faster and automated reporting. We would need better designs and workflows."
"With SAS Data Management, you have to purchase an external driver, configure all of the tables for all of the data that you will extract from Salesforce. It's not a straightforward process."
"The pricing of the solution needs to be improved. They need to work to make it more affordable."
"The solution could use better documentation."
More erwin Data Intelligence by Quest Pricing and Cost Advice →
erwin Data Intelligence by Quest is ranked 4th in Data Governance with 18 reviews while SAS Data Management is ranked 27th in Data Governance with 15 reviews. erwin Data Intelligence by Quest is rated 8.6, while SAS Data Management is rated 8.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 SAS Data Management writes "A scalable solution with customer support that is responsive and diligent". erwin Data Intelligence by Quest is most compared with Microsoft Purview, Collibra Governance, Alation Data Catalog, Informatica Axon and Varonis Platform, whereas SAS Data Management is most compared with Informatica PowerCenter, Tungsten RPA, Microsoft Purview, IBM InfoSphere DataStage and Palantir Foundry.
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.