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

Atlan 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

Atlan
Average Rating
8.6
Reviews Sentiment
7.1
Number of Reviews
6
Ranking in other categories
Data Governance (9th)
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

Leon Pereira - PeerSpot reviewer
Enhanced data management with intuitive data lineage and metadata visualization
Certain UI changes could make Atlan more user-friendly. While they have an Excel add-in for interaction with Atlan, it's in its early stages and could be improved. Additionally, data observability capabilities could be enhanced to provide more alerts on stale or outdated data via communication tools like Microsoft Teams, Slack, or email.
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

"As a senior analytics engineer, Atlan's ability to show end-to-end data lineage is the most important feature for me."
"Overall, I rate Atlan as a ten out of ten."
"The AI part is integrated for enriching metadata engagement, making it a comprehensive tool."
"The best feature of Atlan is its integration with communication platforms like Microsoft Teams and Slack, so business users don't have to go into a data catalog to see metadata about data assets."
"Overall, I rate Atlan a nine out of ten."
"Atlan is helpful for identifying datasets and discovering PI data, such as the classification levels of datasets (gold, silver, bronze)."
"Atlas is quite intuitive."
"The best feature of Atlan is its integration with communication platforms like Microsoft Teams and Slack, so business users don't have to go into a data catalog to see metadata about data assets."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"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."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"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."
"The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
 

Cons

"Certain UI changes could make Atlan more user-friendly."
"There are some improvements. There is a feature called Playbooks, which basically allows me to automate certain activities that would otherwise be manual. It's a very interesting feature, but there is room to improve it because, depending on the task you automate, the playbooks seem to have a hard time handling the task. So, it could be improved there. Even though it's a great feature, it can evolve further."
"One area that could be improved is the capability to find duplicates of datasets."
"One of the main areas for improvement is its governance capabilities. Atlan supports only basic out-of-the-box workflows, and it becomes challenging to customize features like how data owners should approve access to data assets."
"The product could be improved by offering scheduled email reports for managed assets."
"One of the main areas for improvement is its governance capabilities."
"One area that could be improved is the capability to find duplicates of datasets."
"The challenge is in the lineage, where it requires improvement. Atlas needs to capture areas where organizations use less known applications."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"One of the best aspects of the tool is its reverse engineering capability."
"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."
"I still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
"The erwin Data Modeler is quite complex to use."
 

Pricing and Cost Advice

"We pay per-user license. It's a different classification model than with other solutions, where they usually charge you for resources. So, that was a better model for us. And because of this difference in models or classification, it was cheaper for us to go with Atlan."
"erwin Data Modeler by Quest is an expensive solution."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"There are no costs in addition to the standard licensing fees."
"The solution is expensive."
"Though the solution is not cheap, it's worth the money."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"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."
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
Manufacturing Company
16%
Financial Services Firm
12%
Computer Software Company
9%
Insurance Company
8%
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Atlan?
They also offer automated lineage embedded in the connectors, allowing us to track where the data is coming from and where it's going. We find it very efficient in cataloging data sources. Additi...
What is your experience regarding pricing and costs for Atlan?
Atlas is competitively priced compared to other data governance platforms like Collibra and Informatica. The only major drawback is its lack of an integrated data quality module.
What needs improvement with Atlan?
The challenge is in the lineage, where it requires improvement. Atlas needs to capture areas where organizations use less known applications.
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

No data available
erwin DM
 

Overview

 

Sample Customers

Information Not Available
 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.