We performed a comparison between erwin Data Modeler by Quest and MEGA HOPEX 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 product lets us import different types of models from various databases."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"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 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."
"It supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"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 initial setup was straightforward. With configuration, customizing or prepping the data and deployment, it took about one year to set up. We only needed two people to deploy and maintain the solution: one business architect and someone who specializes in customization and operations."
"MEGA offers a more integrated GRC platform to facilitate enhanced coordination between the functions of Risk, Compliance, and Internal Audit on a single platform solution - HOPEX."
"The solution is scalable. If a company needs to expand it, it's completely possible to do so."
"The solution itself was easy to use."
"Customer support is fantastic. They are very helpful whenever we get on the line with the support team."
"The most valuable feature is that the software controls everything from a single management window."
"We use the portfolio management feature heavily."
"It generates friendly websites and presents specific views of the enterprise (business, functional, applicative, technological, and infrastructure)."
"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 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."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"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."
"This is a very complex product."
"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."
"There is a lack of local support in the China region."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"It takes a long time to learn how to use HOPEX. It's hard to work with it because the user interface is bad. For example, if you want to build a complex system diagram, you need a lot of knowledge to do this correctly and make it readable. In MEGA, you need to create a report and it takes a long time to publish it. The publishing is offline. With RDoC, everything is online."
"The interface must be improved."
"The tool usability is weak and it also has a high learning curve."
"The solution lacks additional models compared to other tools."
"Scalability can be a problem sometimes."
"In my experience, I've encountered difficulties with consuming custom packages in MEGA HOPEX, which leads to redundant work when deploying them to production. This is an area where improvement is needed. While version six offers better UI and UX, resolving this issue should be a priority. I believe it's important to fully explore MEGA HOPEX's capabilities before suggesting new ones."
"I would like to see more regular updates released."
"The product must improve integration with other tools."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while MEGA HOPEX is ranked 5th in Enterprise Architecture Management with 36 reviews. erwin Data Modeler by Quest is rated 8.6, while MEGA HOPEX is rated 7.8. 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 MEGA HOPEX writes "Easy to use and robust with good features". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and erwin Evolve by Quest, whereas MEGA HOPEX is most compared with Sparx Systems Enterprise Architect, LeanIX, ARIS BPA, Visio and Camunda. See our MEGA HOPEX vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors and best Business Process Design 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.