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
 

Categories and Ranking

Avolution ABACUS
Ranking in Enterprise Architecture Management
8th
Average Rating
8.0
Number of Reviews
14
Ranking in other categories
No ranking in other categories
erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Number of Reviews
38
Ranking in other categories
Business Process Design (9th)
 

Mindshare comparison

As of November 2024, in the Enterprise Architecture Management category, the mindshare of Avolution ABACUS is 3.9%, down from 4.8% compared to the previous year. The mindshare of erwin Data Modeler by Quest is 10.9%, up from 10.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

BPMexp67 - PeerSpot reviewer
Sep 15, 2019
Powerful and customizable, but the interface needs to be more user-friendly and it needs dashboards
The user interface needs improvement because it is not user-friendly. They need dashboards because I think that it is really important in the market at the moment. Dashboards seem to be the solid bridge between the business and IT departments, and I didn't see anything there. The people that are going to decide to buy the product are the top management, and they are not interested in seeing the everyday operational aspects. Rather, they want to see results, which is why you need dashboards. They have an open door for integration with the model, but that's all. Integration with third-party tools needs to be improved. We did some research on this, and they have open doors with certain tools, but at least in this assessment, it was not clear how to do it. They say that you can do it, but we could not figure out how. So, this is an odd part that I think they can make more clear. I asked whether they have APIs available, or whether we had to create them from scratch, but I didn't get an answer. There is a feature called the versioning of the models, and it is not easy. It is hard because it requires a lot of technical skill to work with a model, process, or another artifact. If they want to expand in the European market then they are going to have to improve their technical support.
JorgeSanz - PeerSpot reviewer
Jun 19, 2024
Streamline data modeling and automate network changes for increased efficiency
We are implementing erwin to streamline data modeling and automate network changes for increased efficiency and comprehensive data development. This option simplifies the need for better data indexing Quest can create conceptual and physical data models to facilitate effective communication…

Quotes from Members

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

Pros

"It's more than just an enterprise architecture tool as it has a lot of nice features, e.g. messaging, simulation, etc."
"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."
"The most valuable feature is that it has a customizable meta-model, which is key."
"Scalable and stable tool for roadmapping and modeling, with a good dashboard, end-to-end impact analysis, and portfolio management."
"There are plenty of features available such as the ability to test applications for issues and a user-friendly dashboard."
"The product is easy to use and well-structured for the integrations we need it to make."
"The technical support is very good. They are responsive and the answers they provide are detailed."
"If you face new challenges or issues then you can dynamically customize according to the business needs."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"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."
"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 is a scalable solution...The technical support team is fine."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"It has centralized storage so that a data model can be shared by different teams."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
 

Cons

"The company needs to update the UML version they are using for the product as it is quite old."
"The reporting could be easier to configure."
"In the future, there could be improvements in integration and enhancements."
"The usability of the tool is an area with shortcomings that need improvement."
"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."
"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."
"While this is one of the most powerful tools on the market it does not integrate well with Microsoft Office or others."
"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."
"I would like the solution to be less rigid in terms of its theory."
"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."
"I would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"The solution's reporting side needs to be improved."
"This is a very complex product."
"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."
 

Pricing and Cost Advice

"There is a subscription for this solution. We are on an annual subscription because you sometimes receive special offers the longer you subscribe."
"The cost of Avolution ABACUS is reasonable, given the features they offer in comparison to other tools."
"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."
"The solution's pricing is not an issue."
"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."
"It is expensive."
"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."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"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."
"There are two license options and the pricing is reasonable."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"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."
"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."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Government
15%
Computer Software Company
8%
Educational Organization
6%
Financial Services Firm
20%
Manufacturing Company
9%
Computer Software Company
9%
Government
9%
 

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?
The tool is quite extensive but 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. ...
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?
The solution's model mark could be better because it crashes sometimes.
 

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: October 2024.
814,649 professionals have used our research since 2012.