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 February 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 11.2%, 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."
"Quest can create conceptual and physical data models to facilitate effective communication between business and IT. It can also integrate expertise from various engineering and database systems within your organization to enhance data management and administration."
"The fitting model is very intuitive."
"One of the best aspects of the tool is its reverse engineering capability."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
"The modeling portion of the tool is the most valuable. There are some notes, naming standards, and other functions that we use as well. There's a whole boatload of functionality in this thing and we use maybe 10% of it. It seems to be pretty common that not all the functionality is fully utilized. But it's just got gobs and gobs of stuff that you can implement if you so choose to."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"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."
"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."
 

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."
"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."
"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."
"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."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"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."
"erwin is not as robust as a data warehousing project I've been on in the past."
"It is not a very stable solution. I rate the stability five out of ten."
"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
 

Pricing and Cost Advice

"I use ADOIT's open-source version."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"Though the solution is not cheap, it's worth the money."
"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."
"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 is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."
"I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
"The solution is expensive."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
838,713 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Energy/Utilities Company
10%
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: January 2025.
838,713 professionals have used our research since 2012.