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 that it has a customizable meta-model, which is key."
"It's more than just an enterprise architecture tool as it has a lot of nice features, e.g. messaging, simulation, etc."
"There are plenty of features available such as the ability to test applications for issues and a user-friendly dashboard."
"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 technical support is very good. They are responsive and the answers they provide are detailed."
"The product is easy to use and well-structured for the integrations we need it to make."
"It is a very stable solution...The initial setup of Avolution ABACUS is very easy."
"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."
"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 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."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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 principal feature that I liked is that the solution has a very graphic interface."
"The data lineage feature is very valuable."
"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 the catalog and the diagram."
"The company needs to update the UML version they are using for the product as it is quite old."
"While this is one of the most powerful tools on the market it does not integrate well with Microsoft Office or others."
"It doesn't have the simulation capability, which would be helpful in doing some business process analysis and improvements."
"In the future, there could be improvements in integration and enhancements."
"If they want to expand in the European market then they are going to have to improve their technical support."
"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."
"They should take more initiative to implement things that competing products have already come out with."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"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."
"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."
"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."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"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."
"This is a very complex product."
"It is not a very stable solution. I rate the stability five out of ten."
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.