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

Avolution ABACUS vs IDERA ER/Studio 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
Reviews Sentiment
6.8
Number of Reviews
15
Ranking in other categories
No ranking in other categories
IDERA ER/Studio
Ranking in Enterprise Architecture Management
10th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
35
Ranking in other categories
Database Development and Management (15th)
 

Mindshare comparison

As of December 2024, in the Enterprise Architecture Management category, the mindshare of Avolution ABACUS is 4.0%, down from 4.7% compared to the previous year. The mindshare of IDERA ER/Studio is 4.1%, down from 4.4% 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…
Aaron Cutshall - PeerSpot reviewer
Used for data modeling and has a scripting language to write your own scripts
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight out of ten.

Quotes from Members

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

Pros

"If you face new challenges or issues then you can dynamically customize according to the business needs."
"The most valuable feature is the traceability, you can trace any object to the other."
"Avolution ABACUS allows for flexible enterprise architecture analysis."
"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."
"You can design using a diagram tool installed on your desktop, a key difference from other vendors."
"The most valuable feature is that it has a customizable meta-model, which is key."
"The product is easy to use and well-structured for the integrations we need it to make."
"There are plenty of features available such as the ability to test applications for issues and a user-friendly dashboard."
"The tool is simple to use."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
 

Cons

"It doesn't have the simulation capability, which would be helpful in doing some business process analysis and improvements."
"If they want to expand in the European market then they are going to have to improve their technical support."
"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."
"While Avolution ABACUS is flexible, it can be complex to work with as it requires knowledge of specific configurations to customize the product."
"The usability of the tool is an area with shortcomings that need improvement."
"Their local presence in the Middle East could be scaled more, particularly in customer service. It would be good if they'd also have mobile dashboards for executive management out of the box."
"While this is one of the most powerful tools on the market it does not integrate well with Microsoft Office or others."
"The company needs to update the UML version they are using for the product as it is quite old."
"The only thing I had an issue with was licensing, and the support was very good."
"When building the relationships there should be a little more flexibility."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"The solution's reporting could be improved because the report writer is terrible."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
 

Pricing and Cost Advice

"My company makes annual payments toward the licensing costs of the solution. Considering the product's capabilities, its prices are very reasonable."
"The pricing is quite good compared to the competition and it is part of the reason we chose the product."
"It is expensive."
"To get a fairly extensive license for Enterprise Architects from Spark is approximately US $400.00, maybe less, but with Avolution Abacus it was approximately US $2000.00 per year, and that includes maintenance with the Abacus tool."
"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 solution's pricing is not an issue."
"There is a subscription for this solution. We are on an annual subscription because you sometimes receive special offers the longer you subscribe."
"This solution is expensive for some people's budgets and they need to offer a Lite version at a cheaper price"
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"Pricing is on point, but do your due diligence - not every developer needs the tool."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"The product is pricey."
"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
"The process of licensing could be much simpler, from our experience."
"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."
"As an individual user, the renewal is a little costly."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
824,067 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Government
14%
Computer Software Company
8%
Educational Organization
6%
Financial Services Firm
19%
Computer Software Company
10%
Manufacturing 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?
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 needs improvement with IDERA ER/Studio?
Since the solution was originally developed in the eighties and nineties and hasn't changed much since then, it could use an overhaul. The solution is not so strong at creating modeling views and d...
 

Also Known As

No data available
IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
 

Learn More

 

Overview

 

Sample Customers

Barclays
Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
Find out what your peers are saying about Avolution ABACUS vs. IDERA ER/Studio and other solutions. Updated: December 2024.
824,067 professionals have used our research since 2012.