We performed a comparison between IDERA ER/Studio 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 reverse engineering is the most important feature."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"We use the solution to create data models which describe our company's data architecture"
"The tool is simple to use."
"We are able to document the data lineage and data flows of our data from one system to another."
"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."
"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."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"Every module sets up the same information in a unique repository."
"The tool is very simple and intuitive to use."
"The most valuable feature of MEGA HOPEX is the publication method for static websites. You can generate the whole database into a static website. Additionally, in the new tabular entry, you don't have to put objects or links, you can go and fill a tab and the MEGA HOPEX will generate an object for you in a simple way."
"The most valuable features of MEGA HOPEX are the seamless VPA module and the good user experience. There are built-in connections that provide integration with other platforms, such as ServiceNow. There is a lot of customization available allowing a lot of freedom. The solution is updated frequently adding new features. For example, the feature GraphQL can be integrated into other solutions, such as ManageEngine for ITSM solutions. You are able to use GraphQL to connect APIs and query the APIs."
"You do not need to be a professional of enterprise modeling to contribute to the enrichment and improvement of the enterprise repository."
"The support experience in Latin America is great."
"We have many use cases for this solution but the feature I have found most valuable is the IT Portfolio Management module."
"This is a complete package with all of the functionality that we need."
"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."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"This solution needs more precise documentation."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"When building the relationships there should be a little more flexibility."
"It would be great if this solution could integrate with other tools such as ITSM (ServiceNow) or CMDB."
"I cannot recall coming across any missing features."
"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."
"The product must improve integration with other tools."
"Needs a friendlier import/export to other modeling tools."
"The tool usability is weak and it also has a high learning curve."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while MEGA HOPEX is ranked 5th in Enterprise Architecture Management with 36 reviews. IDERA ER/Studio is rated 8.4, while MEGA HOPEX is rated 7.8. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of MEGA HOPEX writes "Easy to use and robust with good features". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest, whereas MEGA HOPEX is most compared with Sparx Systems Enterprise Architect, LeanIX, ARIS BPA, Avolution ABACUS and Visio. See our IDERA ER/Studio vs. MEGA HOPEX 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.