We performed a comparison between Avolution ABACUS and erwin Data Modeler by Quest based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."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 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 is a very stable solution...The initial setup of Avolution ABACUS is very easy."
"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 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 product is easy to use and well-structured for the integrations we need it to make."
"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."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"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."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"The product allows us to reuse entities and attributes."
"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."
"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."
"The reporting could be easier to configure."
"The company needs to update the UML version they are using for the product as it is quite old."
"They should take more initiative to implement things that competing products have already come out with."
"If they want to expand in the European market then they are going to have to improve their technical support."
"Having more control over page size is lacking in this product. Print utilization also needs to be improved."
"In the future, there could be improvements in integration and enhancements."
"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."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."
"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."
"erwin is not as robust as a data warehousing project I've been on in the past."
"I would like the solution to be more user-friendly to deploy."
"I would like the solution to be less rigid in terms of its theory."
"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."
Avolution ABACUS is ranked 8th in Enterprise Architecture Management with 13 reviews while erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews. Avolution ABACUS is rated 8.0, while erwin Data Modeler by Quest is rated 8.6. The top reviewer of Avolution ABACUS writes " An out of the box tool that creates reports on the fly that can help your client make better decisions". On the other hand, the top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". Avolution ABACUS is most compared with Sparx Systems Enterprise Architect, LeanIX, MEGA HOPEX, Visio and iServer, whereas erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and iServer.
See our list of best Enterprise Architecture Management vendors.
We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.