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

Avolution ABACUS 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

Avolution ABACUS
Ranking in Enterprise Architecture Management
9th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
15
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 (10th)
 

Mindshare comparison

As of July 2025, in the Enterprise Architecture Management category, the mindshare of Avolution ABACUS is 3.6%, down from 4.5% compared to the previous year. The mindshare of erwin Data Modeler by Quest is 10.2%, up from 10.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

JoseCamacho - PeerSpot reviewer
Supports evaluating architecture through corporate objectives
I conducted an evaluation of enterprise architecture at the European Court in Luxembourg, reviewing and analyzing existing implementations to identify potential improvements and providing recommendations I conduct evaluations to identify potential improvements and make recommendations, forming a…
Saswata Mondal - PeerSpot reviewer
The creation of data models is easy and quick, and the fitting model is very intuitive
The ease and quick ability to create the model is valuable. The fitting model is very intuitive. The other cool feature is the reverse engineer feature. If we connect to the database, we can reverse engineer from the database itself of the physical model. That gives us the relationship of the data if not much documentation is available.

Quotes from Members

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

Pros

"You can design using a diagram tool installed on your desktop, a key difference from other vendors."
"The most valuable feature is the traceability, you can trace any object to the other."
"There are a lot of different features, but the business/decision-maker feature, visibility, and dashboards are most valuable."
"The tool's implementation is straightforward as everything is readily available. For instance, setting up a portal is seamless, allowing easy publishing and access to data. However, integrating with other tools like BI, Power BI, or Grafana requires setting up pipelines between them."
"The most valuable feature is that it has a customizable meta-model, which is key."
"The ease of modeling and the ease of showing interconnectivity and relationships is the most valuable. It is fairly simple and out of the box. It is customizable in many ways. It is a pretty good tool."
"It is a very stable solution...The initial setup of Avolution ABACUS is very easy."
"If you face new challenges or issues then you can dynamically customize according to the business needs."
"The product allows us to reuse entities and attributes."
"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."
"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."
"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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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 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."
 

Cons

"While this is one of the most powerful tools on the market it does not integrate well with Microsoft Office or others."
"I use reference models, which are taxonomies, in my EA work. It is a reference model/taxonomy of things with capabilities, sub capabilities, and sub-sub capabilities, so you're working it down. I haven't yet found a simple way to implement that in Abacus. It could be that it is there, but I don't know how to do it."
"It doesn't have the simulation capability, which would be helpful in doing some business process analysis and improvements."
"The tool doesn't have any intelligence built in. We have to design the dashboards ourselves, which is a challenge because we have to depend on the vendor for customizations."
"The usability of the tool is an area with shortcomings that need improvement."
"While Avolution ABACUS is flexible, it can be complex to work with as it requires knowledge of specific configurations to customize the product."
"Avolution ABACUS has the drawback of needing data filtering at the development level, unlike some tools that offer filtering at deployment. Two areas where Avolution ABACUS could be improved are regional support and flexibility in model selection. Sometimes, it's challenging to access support or updates in certain regions, which can slow down progress. Additionally, it would be beneficial if the tool allowed more flexibility in selecting multiple models within a single unit."
"They should take more initiative to implement things that competing products have already come out with."
"The erwin Data Modeler is quite complex to use."
"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."
"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."
"The interface must be improved."
"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."
"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 things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"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."
 

Pricing and Cost Advice

"The solution's pricing is not an issue."
"It is competitive. It is not chump change. I am just using the studio version. I am not using the full enterprise version, which would probably cost me three times more for single-use, but it gives a lot more capability and analysis. It is server-based as well, and it is reasonably priced compared to a lot of the other tools. There are other tools that have other sorts of capabilities, but in order to use them, you'd really have to have like 50 users for the price to become justifiable."
"There is a subscription for this solution. We are on an annual subscription because you sometimes receive special offers the longer you subscribe."
"I'm paying on a yearly basis. I don't know whether it's a highly expensive tool or not. I'm getting a single version of it, and I don't have the enterprise part on it because I don't need the server component, and I don't need a web browser component. My estimate would be that it's a very reasonably priced tool given that you don't need to have licenses with everyone in order to get the information and the decision support capabilities out of the tool. You use the enterprise edition on top of the studio, which is the heart of the tool. I am not aware of any additional costs."
"The cost of Avolution ABACUS is reasonable, given the features they offer in comparison to other tools."
"This solution is expensive for some people's budgets and they need to offer a Lite version at a cheaper price"
"The pricing is quite good compared to the competition and it is part of the reason we chose the product."
"It is expensive."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"The tool is expensive."
"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."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"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."
"Pricing is very high compared to any other product."
"Though the solution is not cheap, it's worth the money."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
861,524 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Government
15%
Computer Software Company
8%
Manufacturing Company
6%
Financial Services Firm
19%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Avolution ABACUS?
The tool's implementation is straightforward as everything is readily available. For instance, setting up a portal is seamless, allowing easy publishing and access to data. However, integrating wit...
What is your experience regarding pricing and costs for Avolution ABACUS?
It's pricey compared to Essential, Deltek, or Essential Cloud. However, its diagramming capabilities and metamodel design make it worth it. But it's not for large user bases. It has modules for app...
What needs improvement with Avolution ABACUS?
While Avolution ABACUS is flexible, it can be complex to work with as it requires knowledge of specific configurations to customize the product. It would be beneficial to have seminars or other met...
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

Barclays
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Find out what your peers are saying about Avolution ABACUS vs. erwin Data Modeler by Quest and other solutions. Updated: July 2025.
861,524 professionals have used our research since 2012.