IDERA ER/Studio Valuable Features

VpDataInd01c
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 »
DataArchadd7
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, SAP and others in Architecture Management. Updated: September 2019.
365,820 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 »
DataArchd5df
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 »
DBA8d65
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 »
Reviewer951561
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 »
Reviewer967458
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 »
Larry Wilson
Data Architect at a insurance company with 1,001-5,000 employees
* Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch. * Data lineage tracking: It allows us to identify upstream and downstream systems using data. This allows us to identify downstream impacts of making changes to data in a particular system, before the downstream systems break. * Collaboration features in Team Server: With discussion threads, email notifications, and streams, we can collaborate with team members to make sure that models and glossaries are sufficiently defined to accurately and concisely reflect the meaning, purpose, etc. of our enterprise data. * Change management: We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify. View full review »
Lucas Rodrigo Spadotto
Administrador de Dados at a non-tech company with 5,001-10,000 employees
This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process. View full review »
Database9ac8
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, SAP and others in Architecture Management. Updated: September 2019.
365,820 professionals have used our research since 2012.
Sign Up with Email