We performed a comparison between erwin Data Modeler by Quest and UNICOM System Architect based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"The data lineage feature is very valuable."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"It has centralized storage so that a data model can be shared by different teams."
"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."
"It is a scalable solution...The technical support team is fine."
"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 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."
"It has good end-to-end metamodel interrelationships."
"It is useful for creating build-outs and architecture views and for publishing reports and stuff like that for different programs."
"There is a lack of local support in the China region."
"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."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"We can only get licenses through partners."
"The solution's reporting side needs to be improved."
"The erwin Data Modeler is quite complex to use."
"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."
"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."
Earn 20 points
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while UNICOM System Architect is ranked 25th in Enterprise Architecture Management. erwin Data Modeler by Quest is rated 8.6, while UNICOM System Architect is rated 6.0. 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". On the other hand, the top reviewer of UNICOM System Architect writes "Useful for creating build-outs and architecture views, but requires a publisher add-on for some detailed reports". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Lucidchart, Visio and Sparx Systems Enterprise Architect, whereas UNICOM System Architect is most compared with Sparx Systems Enterprise Architect. See our UNICOM System Architect vs. erwin Data Modeler by Quest report.
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.