Compare IDERA ER/Studio vs. MEGA HOPEX

IDERA ER/Studio is ranked 2nd in Architecture Management with 12 reviews while MEGA HOPEX is ranked 3rd in Architecture Management with 5 reviews. IDERA ER/Studio is rated 8.8, while MEGA HOPEX is rated 7.0. The top reviewer of IDERA ER/Studio writes " Enables us to visually represent what database tables will look like and their relationships". On the other hand, the top reviewer of MEGA HOPEX writes "A straightforward initial setup with helpful technical support". IDERA ER/Studio is most compared with erwin Enterprise Architecture, SAP PowerDesigner and Toad, whereas MEGA HOPEX is most compared with ARIS BPM, Sparx Systems Enterprise Architect and Visio. See our IDERA ER/Studio vs. MEGA HOPEX report.
Cancel
You must select at least 2 products to compare!
IDERA ER/Studio Logo
5,395 views|3,425 comparisons
MEGA HOPEX Logo
8,367 views|4,297 comparisons
Most Helpful Review
Find out what your peers are saying about IDERA ER/Studio vs. MEGA HOPEX and other solutions. Updated: November 2019.
378,570 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
Straightforward setup.The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth.IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool.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.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 architectureThe most valuable features are... those that enable me to represent the database to the development community and the business users.Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful.

Read more »

The most valuable feature of this solution is the reuse of common enterprise components and entities.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.The most valuable feature for this solution is the automatic updating and propagation of changes across the system.You do not need to be a professional of enterprise modeling to contribute to the enrichment and improvement of the enterprise repository.It generates friendly websites and presents specific views of the enterprise (business, functional, applicative, technological, and infrastructure).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 dashboard on the homepage makes for an enhanced view at a glance of the various work functions applicable to the user.

Read more »

Cons
This solution needs more precise documentation.The only thing I had an issue with was licensing, and the support was very good.when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error.I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio.The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare).The screens are a bit outdated. They could use a new look and feel.It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo.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.

Read more »

The tool usability is weak and it also has a high learning curve.They do tend to push people to their professional services, instead of helping the customers with their problems. I understand this is their business. At the same time, however, they need to work on fact sheets or offer some program to help the customers who want to implement it themselves and to make it run properly in their environment.We would like to see integration with other products, such as being able to use our workflow with SharePoint and Microsoft Office.Needs a friendlier import/export to other modeling tools.Standardization is lacking. The Operational Risk Function will be more effective if it at a default level follows established Basel standards for Loss categorization, Risk Assessments, Risk Event categorization, etc.

Read more »

Pricing and Cost Advice
It is priced fairly. It's around the same as erwin and other competitors' costs.Pricing is expensive and on the higher-end.At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product.As an individual user, the renewal is a little costly.Pricing is on point, but do your due diligence - not every developer needs the tool.I feel the product's pricing is a good value.I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money.The process of licensing could be much simpler, from our experience.

Read more »

If you want to use additional features, such as the Risk Management capability, then it is a little too expensive.

Read more »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
378,570 professionals have used our research since 2012.
Ranking
2nd
Views
5,395
Comparisons
3,425
Reviews
12
Average Words per Review
572
Avg. Rating
8.8
3rd
Views
8,367
Comparisons
4,297
Reviews
5
Average Words per Review
393
Avg. Rating
7.0
Top Comparisons
Compared 15% of the time.
Compared 11% of the time.
Compared 28% of the time.
Compared 6% of the time.
Also Known As
ER/Studio
Learn
IDERA
MEGA International
Overview

IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to easily reverse-engineer, analyze, and optimize existing databases from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between business and IT. Business stakeholders can participate in the metadata definition workflow and access information on models and metadata at the right level for their needs.

MEGA’s HOPEX platform helps you to understand the relationships throughout your company’s ecosystem. If you think of your business like a Jenga tower, pulling out the wrong block could collapse your tower. MEGA provides visibility that enables you to make intelligent decisions and strategic investments, respond to market changes, and ensure that strategies are linked to execution. Now you’ll know which blocks to pull, and why.

With MEGA’s software platform, manage enterprise complexity for optimal business performance. Gain a stronger understanding of your organization’s strategy, investments, processes, risks, and IT landscape. We’re proud to have customers who have achieved a 300+% ROI. Together, let’s see how we can do even better for your business.  

Offer
Learn more about IDERA ER/Studio
Learn more about MEGA HOPEX
Sample Customers
Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Well FargoAetna, Fannie Mae, M&T Bank, Glatfelter Insurance Group, Zions Management Services Company, The College Board, Baxter Credit Union, AXA Financial, Missouri Department of Conservation, New York State OTDA, MEG Energy Corp, Walgreens, Procter & Gamble, Biogen Idec, Gilead Sciences, Organic Valley, Trinity Health, Nissan and Ford
Top Industries
REVIEWERS
Government24%
Healthcare Company12%
University12%
Financial Services Firm12%
VISITORS READING REVIEWS
Software R&D Company22%
Financial Services Firm14%
Manufacturing Company13%
Insurance Company9%
REVIEWERS
Financial Services Firm38%
Insurance Company25%
Healthcare Company13%
Aerospace/Defense Firm13%
VISITORS READING REVIEWS
Financial Services Firm20%
Software R&D Company16%
Insurance Company15%
Government12%
Find out what your peers are saying about IDERA ER/Studio vs. MEGA HOPEX and other solutions. Updated: November 2019.
378,570 professionals have used our research since 2012.
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.
Sign Up with Email