Try our new research platform with insights from 80,000+ expert users

Alation Data Catalog vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Alation Data Catalog
Average Rating
7.6
Reviews Sentiment
6.9
Number of Reviews
12
Ranking in other categories
Data Governance (7th), Metadata Management (2nd)
erwin Data Modeler
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (4th), Business Process Design (10th)
 

Featured Reviews

Brahma Lam - PeerSpot reviewer
Has metadata cataloging features but needs changes in domain model
The tool's metadata cataloging is the most valuable feature.  The tool's domain model needs to be changed.  Alation Data Catalog is stable.  The solution is scalable.  Alation Data Catalog's deployment is easy. I rate it a nine out of ten. Deployment takes only two to three hours to complete.…
JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We had some of our data science engineers, who had built out some cloud-based data and data products for users. They were spending a lot of their time, up to 30 to 35% of their time, answering questions about the data and helping people understand how to use it. Once they were able to document that information within Alation, they were only focusing on around 5% of the high-value questions that really couldn't be solved through the catalog itself. It freed them up to be more productive, it made their end-users more productive, and it made the adoption rate of their data products rise more quickly because people were able to get to using them."
"Alation Data Catalog provides a nice interface for connecting to the database, querying the data, and working on it."
"The most valuable features of Alation Data Catalog are the simplicity in onboarding data sources, the security in securing the data sources, and the way the various users of Alation Data Catalog communicate with each other through a messenger."
"Given the relatively low level of maturity, Alation's most relevant feature at the moment is a user interface that's easy to navigate, which helps us find and understand the data. So while Alation has a lot more functionality, our pain point right now is being able to easily find, understand, and trust the information to use it."
"The solution's most valuable feature is the ALLIE AI feature."
"The platform's most valuable features are workflow automation, automated business metadata tagging, technical metadata tagging, and data integration with data quality tools or platforms."
"We can customize templates based on our use cases."
"The most valuable feature is cloud integration."
"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"One of the best aspects of the tool is its reverse engineering capability."
 

Cons

"Although the solution performs far better in terms of data cataloging, its data governance capabilities need improvement."
"Data observability within Alation would be incredibly helpful for addressing these challenges"
"Alation Data Catalog is not user-friendly for business users. Its user experience is comparable to a Wikipedia page, lacking good visualization."
"We have had issues setting up the connectors and getting Alation's support team to resolve issues."
"The product's data governance features need improvement."
"Alation Data Catalog needs to develop a lot in terms of data governance and would be improved with a built-in interactive data quality solution."
"I know that this has been on their roadmap and they're working on it, but as a whole, there's an untapped reservoir of capabilities within their article features that could be used and built upon."
"Alation Data Catalog doesn't support end-to-end lineage. By that, I mean the ability to trace the movement of data from when it first comes into our organization to where it's consumed."
"erwin is not as robust as a data warehousing project I've been on in the past."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"The erwin Data Modeler is quite complex to use."
"The interface must be improved."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"The solution's reporting side needs to be improved."
 

Pricing and Cost Advice

"A three-year agreement is better than a one-year rolling 12-month agreement from a price point of view. I'd recommend looking at a three-year deal because you can't stand up a catalog and produce value in 12 months."
"The platform is moderately expensive compared to the other competitors in the market."
"The solution is a little expensive."
"I don't have all the details on the pricing side, but the solution was more expensive than originally expected."
"Likewise, the solution is a little pricey."
"Though the solution is not cheap, it's worth the money."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"I don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"erwin Data Modeler by Quest is an expensive solution."
"Pricing is very high compared to any other product."
"There are two license options and the pricing is reasonable."
report
Use our free recommendation engine to learn which Data Governance solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
10%
Manufacturing Company
8%
Government
7%
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Alation Data Catalog?
The platform's most valuable features are workflow automation, automated business metadata tagging, technical metadata tagging, and data integration with data quality tools or platforms.
What is your experience regarding pricing and costs for Alation Data Catalog?
The price difference between Alation Data Catalog and Collibra was not significant. Collibra is a little bit expensive than Alation, but I presented the benefits of having that platform, so that li...
What needs improvement with Alation Data Catalog?
Alation Data Catalog is not user-friendly for business users. Its user experience is comparable to a Wikipedia page, lacking good visualization. In a fast-paced world, we need to grasp information ...
What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
 

Also Known As

Alation
erwin DM
 

Overview

 

Sample Customers

Salesforce, Snowflake, Citrix, eBay, TripAdvisor, Albertsons, Nasdaq, Pfizer, LinkedIn, Finnair.
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Find out what your peers are saying about Microsoft, Informatica, Collibra and others in Data Governance. Updated: July 2025.
865,384 professionals have used our research since 2012.