No more typing reviews! Try our Samantha, our new voice AI agent.

ADOIT vs erwin Data Modeler comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 1, 2026

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

ADOIT
Ranking in Enterprise Architecture Management
18th
Average Rating
9.0
Reviews Sentiment
7.7
Number of Reviews
2
Ranking in other categories
No ranking in other categories
erwin Data Modeler
Ranking in Enterprise Architecture Management
1st
Average Rating
8.4
Reviews Sentiment
6.0
Number of Reviews
54
Ranking in other categories
Business Process Design (7th), Data Governance (10th)
 

Mindshare comparison

As of September 2026, in the Enterprise Architecture Management category, the mindshare of ADOIT is 2.1%, down from 2.5% compared to the previous year. The mindshare of erwin Data Modeler is 8.4%, down from 8.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler8.4%
ADOIT2.1%
Other89.5%
Enterprise Architecture Management
 

Featured Reviews

Janne Kemppainen - PeerSpot reviewer
Lead Information Manager at a tech consulting company with 201-500 employees
Helps to track the life cycle of products and services, and understand their costs
The tool allows us to track the life cycle of products and resources. When the metadata is set up correctly, we can see where things are in their life cycle and how they fit into our processes. It helps us understand which core processes are active and whether any underlying elements need renewal. We can also keep tabs on the costs. The most beneficial feature has been reporting. Being able to track the life cycle of products and services and understand their costs has been crucial. However, I've also been exploring other features that allow us to evaluate tools from both the business and technical sides. The tool was easy to get started with. Some of the reporting features have been particularly useful for our company management. I've built reports showing the costs of running the company and the processes running beneath them. Additionally, I've used it for lifecycle management from a technical perspective. I discovered a feature I haven't tried yet: exporting data to HTML. This allows for neatly gathered reports in one place where you can search through them via HTML and find what you need.
Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.

Quotes from Members

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

Pros

"This particular product would be really helpful to model the architecture at an enterprise level."
"The tool allows us to track the life cycle of products and resources. When the metadata is set up correctly, we can see where things are in their life cycle and how they fit into our processes. It helps us understand which core processes are active and whether any underlying elements need renewal. We can also keep tabs on the costs."
"It is the only meaningful way to do any data modeling."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"My favorite feature of erwin Data Modeler is that we can export and import tables directly from the databases, and it is easy to map from table to table and column to column."
"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases."
"Overall, erwin DM's support for Snowflake is very good."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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 code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
 

Cons

"The tool's data lineage could be enhanced. It would be great to see the data flow and understand where it's going within the system."
"Specifically, we need to understand how the data could be segregated."
"I would like to see improved reporting and, potentially, dashboards built on top of that."
"We find erwin DM less valuable creating initial drafts and reverse-engineering databases and there are still a lot of extensions to the scripting language that are not included with the erwin product."
"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."
"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."
"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."
"The solution's reporting side needs to be improved."
"The solution's model mark could be better because it crashes sometimes."
"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."
 

Pricing and Cost Advice

"I use ADOIT's open-source version."
"Likewise, the solution is a little pricey."
"An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."
"The solution is expensive."
"There are no costs in addition to the standard licensing fees."
"The price should be lower in order to be on the same level as its competitors."
"Pricing is very high compared to any other product."
"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."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
913,683 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
23%
Outsourcing Company
7%
Comms Service Provider
7%
Manufacturing Company
7%
Financial Services Firm
14%
Outsourcing Company
9%
Marketing Services Firm
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business17
Midsize Enterprise4
Large Enterprise43
 

Questions from the Community

Ask a question
Earn 20 points
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous. The setup is okay, but there is room for improvement.
What needs improvement with erwin Data Modeler by Quest?
Regarding improvements, the first thing I would mention is that every release has some issues, some of which are related to current functionalities, which means they often seem not very well tested...
What is your primary use case for erwin Data Modeler by Quest?
My main use case for erwin Data Modeler is to implement a single data architecture design department so everyone is using erwin Data Modeler for their data models to be a transactional application ...
 

Comparisons

 

Also Known As

No data available
erwin DM
 

Overview

 

Sample Customers

Trusted by small to large enterprises worldwide: Volksbank Vienna, Austrian Ministry of Finance, Hilti
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Find out what your peers are saying about ADOIT vs. erwin Data Modeler and other solutions. Updated: September 2026.
913,683 professionals have used our research since 2012.