Compare Avolution ABACUS vs. erwin Data Modeler (DM)

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Avolution ABACUS vs. erwin Data Modeler (DM) and other solutions. Updated: July 2021.
521,817 professionals have used our research since 2012.
Quotes From Members

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

Pros
"We've brought our portfolio altogether. We have had multiple ways of reporting out what our portfolio is, whether it's in Excel, Word, or in different places. We brought all of our projects together in one place. That has worked out well for us. We've been able to manage the work on Gantt charts and our resources better. The big thing for us on research and development is around managing people's time, on which projects they are working on, and how much effort does it take to launch our projects.""With the lifecycles, it helps us step through our processes easier. We'll take a process and create it in Visio, then we'll go and implemented in Planview. Anytime that we have to do a new process, this is what we use. We just step it through the lifecycles and the configure screens are very easy to use. The fields that you need are easy to use.""Planview has helped connect funding and strategic outcomes with work execution. That is the key use that we have for it. We use it to validate the work that we're doing and the funding that we need. The difference between the previous version and current version for us would be the ICPM and the way it gives us different scenarios. We can go in and build that out.""I like that everyone is able to see the same data. All of our users who aren't just time reporters have read access to all the data that is out there. So, it is one source of truth where everybody can go in and see the exact same data that everybody else sees. It is transparent.""The portfolio management gives you a view of all the projects as well as all the information about the total amount of effort, time, and cost being spent on the projects. It gives the organization how much money and effort should be spent towards projects so they can budget and do better capacity planning in the next fiscal year. It gives them visibility into their resources and if they have capacity.""The biggest impact for using Planview currently would be to understand the true costs of projects. We are trying to get to a point where not only do we take into account technical costs, but what the business cost is. Trying to integrate our business right now into Planview is helping us identify the true cost of the investments that we make so we can try and understand their value.""We have a fairly good picture of time tracking.""The look and feel of it is pretty clean."

More Planview Enterprise One 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.""The most valuable feature is that it has a customizable meta-model, which is key.""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.""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.""There are plenty of features available such as the ability to test applications for issues and a user-friendly dashboard."

More Avolution ABACUS Pros »

"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases.""When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable.""erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when.""The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database.""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.""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 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.""We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."

More erwin Data Modeler (DM) Pros »

Cons
"Recently, we have gotten on a newer version. We're currently on version 15. Some of the things that we've been running into roadblocks on, it looks like the solutions will be coming out in versions 17 or 18. So, we have to upgrade before somethings can get completed.""I would suggest for the request module that they open up the fields and columns so it's like we are doing our work in the work module. You can't do that with today. We also have to make sure that the fields can go both ways with the request and work modules. Including fields in the column sets would be helpful, because today they only use attributes.""We have required more time from our resource managers to spend time in the tool. The adoption has been slower than we would have hoped. So, I would think from a rollout perspective, if Planview could help us with material which gets non-Planview users or previously light Planview users to become more heavy users of the system, then this would help us with the rollout.""There can be improvement on the sense of urgency because a lot of times we've exhausted everything that we can, and now, we're reaching out. So, it isn't a, "Well, have you tried to reboot this?" We've already done everything. Once we put in a ticket, there should be more of a sense of urgency on it.""I would like to see more documentation pieces. Right now, they do have the content repository. I would like to see more out-of-the-box features with document repository capabilities.""I would like to be able to copy and paste from Excel into work and assignments along with roles and hours, as opposed to having to type it out one by one.""There's still a lot of reluctance within the organization. We're not using all of the capabilities that we have today. We're still doing our strategic and capital investment planning on spreadsheets rather than using the capabilities that exist within Enterprise One. I definitely need to leverage the experts here at Planview to help drive a culture change. There's just a lot of reluctance on behalf of people within the company to put data into the tool.""Our version is definitely set up a bit more waterfall world. It would be better if some of the agile features were more in the standard product."

More Planview Enterprise One Cons »

"It is vastly scalable but you can't run it on a Mac or Linux so it has limitations.""The most valuable features are the catalog and the diagram.""If they want to expand in the European market then they are going to have to improve their technical support.""While this is one of the most powerful tools on the market it does not integrate well with Microsoft Office or others.""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.""It doesn't have the simulation capability, which would be helpful in doing some business process analysis and improvements."

More Avolution ABACUS Cons »

"I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata.""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.""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 would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else.""The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms.""Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use.""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.""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."

More erwin Data Modeler (DM) Cons »

Pricing and Cost Advice
"We are on the Flex licenses.""We have unlimited licenses for all of our functionalities. Since we went global, we went with that model.""The cost of other pieces and integrating them in needs improvement.""We have portfolio managers, resource managers, project managers, and time reporting licenses. These are the licenses that we have.""I don't think we have necessarily purchased everything that I would have liked to have seen.""We have several hundred licenses. It costs us several hundred thousand dollars a year.""We overbought our licenses. We looked at our needs three to four years down the road and tried based our contract on that. However, we were over aggressive. We use about a third of the licenses that we have. We're looking to adjust the makeup so we can start utilizing the amount of money that we are spending. Right now, we're overspending, and my organization is not seeing the value in Planview because we are paying so much for licenses that we're not using.""Our licensing costs are probably $150,000 to $180,000 a year with 270 licenses total."

More Planview Enterprise One Pricing and Cost Advice »

"This solution is expensive for some people's budgets and they need to offer a Lite version at a cheaper price""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.""The pricing is quite good compared to the competition and it is part of the reason we chose the product.""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."

More Avolution ABACUS Pricing and Cost Advice »

"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable.""This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost.""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.""The price should be lower in order to be on the same level as its competitors.""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 are no costs in addition to the standard licensing fees."

More erwin Data Modeler (DM) Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
521,817 professionals have used our research since 2012.
Questions from the Community
Top Answer: Enterprise One provides a variety of types of resource assignments for assigning work to people. It's very easy and… more »
Top Answer: It would be nice if all of the licenses were FLEX. They've been fairly stable with their pricing over the years.
Top Answer: The resource area needs improvement. The improvements that have been made recently in the later versions have been good… more »
Top Answer: There are plenty of features available such as the ability to test applications for issues and a user-friendly… more »
Top Answer: There is a subscription for this solution. We are on an annual subscription because you sometimes receive special offers… more »
Top Answer: In the future, there could be improvements in integration and enhancements. A few important enhancements I would like to… more »
Top Answer: The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts… more »
Top Answer: We always had a problem keeping track of all the licenses. All of a sudden you might get a message that your license… more »
Top Answer: We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and… more »
Popular Comparisons
Also Known As
Troux
erwin DM
Learn More
Overview
Planview Enterprise, Planview's performance management platform, combines project and portfolio management software with adaptive best practices. By integrating the business process management of strategies, services, and projects within a single, Web-based solution, Planview empowers organizations to achieve greater levels of control over their ever-changing environment by dynamically managing money, resources, and capacities.
ABACUS is designed to provide the quickest time-to-value of any enterprise architecture tool. Build and maintain rich visual models from existing company data. ABACUS comes with standard industry frameworks as well as advanced analytic tools and best-in-class roadmapping and reporting functionality.

erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

Offer
Learn more about Planview Enterprise One
Learn more about Avolution ABACUS
Learn more about erwin Data Modeler (DM)
Sample Customers
Zurich Insurance Group, Zumbotel Group, Carphone Warehouse
Barclays
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Top Industries
REVIEWERS
Financial Services Firm24%
Insurance Company24%
Pharma/Biotech Company11%
Healthcare Company11%
VISITORS READING REVIEWS
Computer Software Company26%
Comms Service Provider13%
Government9%
Financial Services Firm8%
VISITORS READING REVIEWS
Computer Software Company19%
Comms Service Provider16%
Government12%
Financial Services Firm8%
REVIEWERS
Insurance Company29%
Financial Services Firm24%
Government18%
Logistics Company12%
VISITORS READING REVIEWS
Computer Software Company23%
Financial Services Firm21%
Comms Service Provider10%
Government8%
Company Size
REVIEWERS
Small Business6%
Midsize Enterprise2%
Large Enterprise92%
VISITORS READING REVIEWS
Small Business7%
Midsize Enterprise25%
Large Enterprise68%
REVIEWERS
Small Business20%
Midsize Enterprise30%
Large Enterprise50%
REVIEWERS
Small Business29%
Midsize Enterprise4%
Large Enterprise67%
VISITORS READING REVIEWS
Small Business2%
Midsize Enterprise1%
Large Enterprise96%
Find out what your peers are saying about Avolution ABACUS vs. erwin Data Modeler (DM) and other solutions. Updated: July 2021.
521,817 professionals have used our research since 2012.

Avolution ABACUS is ranked 7th in Architecture Management with 7 reviews while erwin Data Modeler (DM) is ranked 3rd in Architecture Management with 19 reviews. Avolution ABACUS is rated 7.2, while erwin Data Modeler (DM) is rated 8.8. 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 (DM) writes "Allows us to bring in data from dozens of platforms and search holistically across all of them". Avolution ABACUS is most compared with Sparx Systems Enterprise Architect, BiZZdesign HoriZZon, LeanIX, MEGA HOPEX and Alfabet Enterprise Architecture Management, whereas erwin Data Modeler (DM) is most compared with SAP PowerDesigner, Visio, Lucidchart, AWS Well-Architected Tool and Sparx Systems Enterprise Architect. See our Avolution ABACUS vs. erwin Data Modeler (DM) report.

See our list of best Architecture Management vendors.

We monitor all 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.