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

"It helps me 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."
"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."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"It has centralized storage so that a data model can be shared by different teams."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
 

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."
"We need to understand how the data could be segregated."
"There is a lack of local support in the China region."
"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 reverse engineering in Oracle Databases needs improvement, as there are issues."
"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them."
"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."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
 

Pricing and Cost Advice

"I use ADOIT's open-source version."
"The solution is expensive."
"The price should be lower in order to be on the same level as its competitors."
"The tool is expensive."
"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."
"Pricing is very high compared to any other product."
"Though the solution is not cheap, it's worth the money."
"There are two license options and the pricing is reasonable."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
842,767 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.
842,767 professionals have used our research since 2012.