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

UNICOM System Architect vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
38
Ranking in other categories
Business Process Design (9th)
UNICOM System Architect
Ranking in Enterprise Architecture Management
26th
Average Rating
6.0
Number of Reviews
2
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.0%, up from 10.0% compared to the previous year. The mindshare of UNICOM System Architect is 0.6%, down from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
reviewer1261290 - PeerSpot reviewer
Useful for creating build-outs and architecture views, but requires a publisher add-on for some detailed reports
I don't use the tool or know a lot. It is going to have some shortcomings. When it comes down to publishing, we just found out this week that they actually have a publisher add-on. So, what we were trying to publish was not giving a detailed report about the architecture, views, etc. I just wish they had sent these to UNICOM and contacted them about add-on features for the publishing part of the tool.

Quotes from Members

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

Pros

"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."
"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."
"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."
"We can create mappings in erwin and possibly data dictionaries."
"The data lineage feature is very valuable."
"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."
"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."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"It is useful for creating build-outs and architecture views and for publishing reports and stuff like that for different programs."
"It has good end-to-end metamodel interrelationships."
 

Cons

"The interface must be improved."
"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."
"The solution's model mark could be better because it crashes sometimes."
"erwin is not as robust as a data warehousing project I've been on in the past."
"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."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"I don't use the tool or know a lot. It is going to have some shortcomings. When it comes down to publishing, we just found out this week that they actually have a publisher add-on. So, what we were trying to publish was not giving a detailed report about the architecture, views, etc. I just wish they had sent these to UNICOM and contacted them about add-on features for the publishing part of the tool."
"They need to add reports that show the enterprise architecture perspectives, and the dashboards should be comfortable for the senior enterprise architects so that they can view the complete landscape."
 

Pricing and Cost Advice

"The price should be lower in order to be on the same level as its competitors."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"There are no costs in addition to the standard licensing fees."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"erwin Data Modeler by Quest is an expensive solution."
"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."
"Though the solution is not cheap, it's worth the money."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"I don't remember the price. It is a different cost for just buying it, and then you have a maintenance cost, which you need to renew every year."
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
19%
Manufacturing Company
9%
Government
9%
Computer Software Company
8%
Government
19%
Financial Services Firm
15%
Computer Software Company
14%
University
12%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

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.
Ask a question
Earn 20 points
 

Also Known As

erwin DM
No data available
 

Learn More

Video not available
 

Overview

Information not available
 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Apple, Facebook, Google, HSBC, PayPal
Find out what your peers are saying about UNICOM System Architect vs. erwin Data Modeler by Quest and other solutions. Updated: December 2024.
824,067 professionals have used our research since 2012.