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

ADOIT vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

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
10th
Average Rating
9.0
Reviews Sentiment
7.7
Number of Reviews
2
Ranking in other categories
No ranking in other categories
erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Business Process Design (9th)
 

Mindshare comparison

As of April 2025, in the Enterprise Architecture Management category, the mindshare of ADOIT is 2.5%, down from 3.5% compared to the previous year. The mindshare of erwin Data Modeler by Quest is 10.9%, up from 9.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

Janne Kemppainen - PeerSpot reviewer
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.
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

"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 helps me to model the architecture at an enterprise level."
"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 product allows us to reuse entities and attributes."
"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 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."
"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."
"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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."
 

Cons

"We need to understand how the data could be segregated."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"There is a lack of local support in the China region."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"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."
"I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."
"The erwin Data Modeler is quite complex to use."
"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."
 

Pricing and Cost Advice

"I use ADOIT's open-source version."
"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."
"The solution is expensive."
"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."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"Likewise, the solution is a little pricey."
"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."
"There are two license options and the pricing is reasonable."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
845,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Energy/Utilities Company
9%
Computer Software Company
8%
University
7%
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with ADOIT?
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.
What is your primary use case for ADOIT?
The solution describes the enterprise architecture for the company, encompassing everything from the business side to the technical aspects.
What advice do you have for others considering ADOIT?
The tool is still being integrated into our enterprise architecture. It serves as a tool for gathering and providing information, but it hasn't yet directly solved a critical business issue for me....
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

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 by Quest and other solutions. Updated: March 2025.
845,406 professionals have used our research since 2012.