Most Helpful Review
Enables us to present data and objects visually, in diagrams, and to make them available via the web
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
One of the most valuable features is the website that sits on top of the database. There's a database of objects and how they are related, and you can make views and diagrams and visual elements out of that information on the website. The website is the part that is called Evolve and we use the Evolve Designer and publish the website out to our employees. They can click around and navigate and search, etc.
The most valuable features for us are impact analysis, where I can easily visualize the impact of change.
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.
What they need to do is to consolidate more of their products. For example, I was just looking and I couldn't figure out what erwin DT is. It's on the website but it would help if they could put information together and make it more clear as to what products they have and how they work with other things.
I feel that the UML drawing capability needs to be improved.
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.
Pricing and Cost Advice
I estimate that we pay between $40,000 and $50,000 a year for the solution, not including the upfront costs to buy things the first time.
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.
out of 30 in Architecture Management
Average Words per Review
out of 30 in Architecture Management
Average Words per Review
Compared 100% of the time.
Compared 47% of the time.
Compared 16% of the time.
Compared 10% of the time.
Also Known As
As the name suggests, erwin EA Agile takes a different approach to enterprise architecture (EA). The collaborative, cloud-based platform is an easy-to-use and cost-effective path for launching an EA program quickly. Built-in support for such industry frameworks as TOGAF and ArchiMate enables you to model the enterprise, capture the IT blueprint, and provide meaningful insights to stakeholders to more quickly and easily manage complexity and change.
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.
Learn more about erwin EA Agile
Learn more about IDERA ER/Studio
|Plymouth University, Springer Nature||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|
No Data Available
Software R&D Company12%
Software R&D Company30%
Financial Services Firm10%