IDERA ER/Studio Valuable Features

Database Designer at a manufacturing company with 1,001-5,000 employees
The ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used. The Repository, as well. We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the Repository enables us to share the models, and keep track of what everybody is working on. View full review »
Jamie Vasser
IT Specialist at a government with 10,001+ employees
The most valuable feature is data modeling, primarily, because it's something that has been lacking in our systems development for 20 years. There was no accountability for data structure. View full review »
Data Architect at a software R&D company with 1,001-5,000 employees
* Easy to model. * Has a user-friendly interface. * I like the team portal because, once we upload, the entire team can see the model. View full review »
Find out what your peers are saying about IDERA, erwin, Inc., SAP and others in Architecture Management. Updated: April 2020.
407,242 professionals have used our research since 2012.
Mariya Salamatova
Senior Business Intelligence Developer at a wholesaler/distributor with 51-200 employees
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. View full review »
Asst. Director, Data Management & Analytics at a university with 10,001+ employees
The engineering portion, developing new models, dimensional models, not relational models. For the data we're hosting, dimensional modeling is more useful. View full review »
DBA at a consultancy with 501-1,000 employees
The most valuable features are the various features for different databases, but mainly those that enable me to represent the database to the development community and the business users. View full review »
Database Administrator at a government with 10,001+ employees
The modeling part of the tool. We use the solution to create data models which describe our company's data architecture. It is a mix of design upfront when we get changes. We also use the data models after we've implemented changes. It does help in regards to redundancy with standardization across models. View full review »
Database Developer at a financial services firm with 1,001-5,000 employees
The data modeling module is important to me because I am a database developer and designer. I also take part in designing applications and that always starts with data modeling. It's very fast, reliable, up-to-date, so easy to use, smooth. The solution is also easy to explain to others and the graphics are good. Finally, the menu choices are also important. There are a lot of them and they are good. View full review »
Mike Grove
DBA at a manufacturing company with 201-500 employees
One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded. View full review »
Database Administrator at a healthcare company with 1,001-5,000 employees
The reverse engineering is the most important feature. The relationships are also important. View full review »
Find out what your peers are saying about IDERA, erwin, Inc., SAP and others in Architecture Management. Updated: April 2020.
407,242 professionals have used our research since 2012.