IDERA ER/Studio Benefits

Database Designer at a manufacturing company with 1,001-5,000 employees
We were using ERwin before we used ER/Studio. I've been doing data modeling for well over 20 years. Converting from one to the other at the time, ER/Studio was more sophisticated, gave us better functionality, and was more reliable. View full review »
Jamie Vasser
IT Specialist at a government with 10,001+ employees
We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution. View full review »
Data Architect at a software R&D company with 1,001-5,000 employees
Before this tool, just managing the changes and publishing the models to the users became very cumbersome. This tool has simplified our day-to-day tasks a lot. View full review »
Find out what your peers are saying about IDERA, erwin, SAP and others in Architecture Management. Updated: September 2019.
366,239 professionals have used our research since 2012.
Mariya Salamatova
Senior Business Intelligence Developer at a wholesaler/distributor with 51-200 employees
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. View full review »
Asst. Director, Data Management & Analytics at a university with 10,001+ employees
When I need a new model, first I determine the sources that should be used, the source database. With a little effort, I create a target table from the source import. The tool then creates the DDL creating the table, the actual physical database. View full review »
DBA at a consultancy with 501-1,000 employees
There are a lot of different ways we use the tool. One of the ways is that we do auditing of what's been billed to production to make sure it matches what we have designed. And it has also improved things in that we have design requirements for the DBA. Because of all the various things we use it for, it has a high value within the organization. View full review »
Database Administrator at a government with 10,001+ employees
We have gone from having no diagrams to 50 submodels that we have been able to share with team members and even with our clients. View full review »
Database Developer at a financial services firm with 1,001-5,000 employees
I always work in big corporations, and what I do is relatively small, it's enhancements. The company that I work for has many products and this is just one of them. The main benefit is that you can do things fast with it and that's very important. It helps reduce the overall time and meet the deadlines. Also, 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. View full review »
Mike Grove
DBA at a manufacturing company with 201-500 employees
When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders. View full review »
Larry Wilson
Data Architect at a insurance company with 1,001-5,000 employees
We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases. We have been able to then modify those models, breaking them down to make them more understandable. Loading these models into the ER/Studio Team Server repository, it allows us to disseminate this information to the entire enterprise. Team Server allows us to further define those models through the use of glossaries and gives us the ability to collaborate as a data governance team to ensure that terms defined provide us a common understanding of our data. We are also able to document the data lineage and data flows of our data from one system to another. View full review »
Database Administrator at a healthcare company with 1,001-5,000 employees
The developers can see the relationships now. View full review »
Find out what your peers are saying about IDERA, erwin, SAP and others in Architecture Management. Updated: September 2019.
366,239 professionals have used our research since 2012.
Sign Up with Email