Compare IDERA ER/Studio vs. erwin Enterprise Architecture

erwin Enterprise Architecture is ranked 7th in Architecture Management with 5 reviews while IDERA ER/Studio is ranked 3rd in Architecture Management with 12 reviews. erwin Enterprise Architecture is rated 7.6, while IDERA ER/Studio is rated 8.8. The top reviewer of erwin Enterprise Architecture writes "We can model and diagram-out system interfaces as a geographically distributed team, but integration with other solutions is not easy". On the other hand, the top reviewer of IDERA ER/Studio writes " Enables us to visually represent what database tables will look like and their relationships". erwin Enterprise Architecture is most compared with SAP PowerDesigner, IDERA ER/Studio and Sparx Systems Enterprise Architect, whereas IDERA ER/Studio is most compared with erwin Enterprise Architecture, SAP PowerDesigner and Toad. See our IDERA ER/Studio vs. erwin Enterprise Architecture report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about IDERA ER/Studio vs. erwin Enterprise Architecture and other solutions. Updated: January 2020.
397,983 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
The feature that stands out for me is the ease of configuring objects and the screens to show them. It's really easy to add a new type of object in this reference. Creating a new type of object, using it, and evolving it a little bit in terms of what we can document about it are the main features that made us decide to use this provider.I can send images in the PDF form, along with the relationships and the associations that are a very important part of what we do. It can show what is affected and what is impacted by a certain change in one area of the system architecture or enterprise architecture. I can very quickly draw those issues and topics to the fore.The ability to share and collaborate on the solution is its most valuable feature.The initial setup was really straightforward and the deployment was done within one day.Forward and reverse engineering were valuable features.

Read more »

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 »

Cons
They have improved the search engine a little bit but it can always be improved more. The more data you put inside it, the more you want to use it.The solution's integration capabilities with other tools in our system has not been all that well done. We have people who use ARIS, who use System Architect and, of course, Visio. erwin has very limited ways to import and export from those kinds of tools. It's not a very easy thing to do.The solution needs to focus on allowing for more integrations.I would like to see an improvement in the output of the solution.Business process modelling could be improved.

Read more »

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 »

Pricing and Cost Advice
Yearly, our cost is €100,000.The cost is something like $15,000, per license. But I haven't looked at those numbers in three years. It was over $100,000 to initially set everything up and get it all configured.

Read more »

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 »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
397,983 professionals have used our research since 2012.
Ranking
7th
Views
5,545
Comparisons
4,276
Reviews
3
Average Words per Review
183
Avg. Rating
7.0
3rd
Views
5,408
Comparisons
3,332
Reviews
12
Average Words per Review
576
Avg. Rating
8.8
Top Comparisons
Compared 16% of the time.
Compared 10% of the time.
Also Known As
erwin EAER/Studio
Learn
erwin, Inc.
Video Not Available
IDERA
Overview

erwin is used by more than 50,000 professionals in 60+ countries to get big results from their enterprise data initiatives. erwin is the #1 choice in virtually every industry, from government and healthcare to retail and finance.

erwin Modeling provides a collaborative environment to manage enterprise data through an intuitive, graphical interface. With a centralized view of key data definitions, you can leverage information as a strategic asset and more efficiently manage your data resources to save time and money.

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.

Offer
Learn more about erwin Enterprise Architecture
Learn more about IDERA ER/Studio
Sample Customers
AT&T, Bank of America, Chevron, Duke University, ESPN, Fidelity, GE, JP Morgan Chase, KPMG, McGraw Hill, NASA, Pfizer, Royal Bank of Scotland, Teradata, Union Pacific, Vodafone, Wells Fargo.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
Top Industries
VISITORS READING REVIEWS
Software R&D Company30%
Insurance Company10%
Financial Services Firm8%
Comms Service Provider7%
REVIEWERS
Government24%
Manufacturing Company12%
Healthcare Company12%
University12%
VISITORS READING REVIEWS
Software R&D Company30%
Manufacturing Company13%
Financial Services Firm10%
Insurance Company6%
Find out what your peers are saying about IDERA ER/Studio vs. erwin Enterprise Architecture and other solutions. Updated: January 2020.
397,983 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.