Most Helpful Review
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
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 architecture
The 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.
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.
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.
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.
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.
If you want to use additional features, such as the Risk Management capability, then it is a little too expensive.
out of 28 in Architecture Management
Average Words per Review
out of 28 in Architecture Management
Average Words per Review
Compared 48% of the time.
Compared 15% of the time.
Compared 11% of the time.
Compared 28% of the time.
Compared 17% of the time.
Compared 6% of the time.
Also Known As
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.
Learn more about IDERA ER/Studio
Learn more about MEGA HOPEX
|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 Fargo||Aetna, 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|
Financial Services Firm12%
Software R&D Company22%
Financial Services Firm14%
Financial Services Firm38%
Financial Services Firm20%
Software R&D Company16%