IDERA ER/Studio Valuable Features
KP
reviewer3261598
Business Solutions Specialist at a energy/utilities company with 10,001+ employees
ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people. It has strong versioning support and can even integrate with third-party versioning tools like GitHub. It has a rich set of integration options with various products in the market. The tool also supports both logical and physical data modeling, and it has out-of-the-box support for data vault methodologies. ER/Studio allows the enforcement of naming conventions, which is beneficial for maintaining standards within the organization.
View full review »JM
Jean-Luc Mercier
Managing Partner at DXC Technology
It was a very good tool at the time since it was complete. When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions. It allowed for quick and easy development. Additionally, there is a tool called WinDev, which is similar to the one I discussed.
View full review »The complexities allowed in the models and the expressiveness are the most valuable features of the solution. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts.
View full review »Buyer's Guide
IDERA ER/Studio
July 2025

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: July 2025.
861,803 professionals have used our research since 2012.
This is a good tool to use. I find it to be very useful.
View full review »The most valuable feature of the solution is generating DDL (data definition language). The solution's data modeling is good because it visualizes and structures business data rather than just building it. IDERA ER/Studio is like a blueprint for the developers and good documentation for the enterprise.
View full review »The data modeling and reverse engineering features are most important to us.
View full review »The feature that we like best is the model publishing.
The web interface allows everybody to view models that are stored on the team server.
View full review »It does the job. However, it doesn't work as well as other solutions.
View full review »The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer.
View full review »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 »MS
Mariya Salamatova
Senior Business Intelligence Developer at a construction company with 501-1,000 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 »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 »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 »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 »MG
Mike Grove
DBA at a consumer goods 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 »The reverse engineering is the most important feature. The relationships are also important.
View full review »JV
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 »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 »- Easy to model.
- Has a user-friendly interface.
- I like the team portal because, once we upload, the entire team can see the model.
LW
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.
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 »The ability to define a set of domain definitions and group them in folders is a valuable feature. There is also a Macro (VB script) feature that allows you to automate many features that can save a lot of time.
View full review »Being able to to perform reverse engineering is valuable to us.
View full review »There are only a handful of ERD features that I’ve needed over the years that ER/Studio DA didn’t support. It’s flexible, intuitive for the newbie and yet supports the complexity required of a seasoned database designer, and offers a clean sophisticated presentation.
View full review »- Centralised Repository where all the models are stored
- TeamServer (Portal) which gives access to the models (read only) through a web browser
- Entity Llinking Ability across data models
- Reuse of objects within workspace on multiple diagrams
Reverse engineering existing databases. I use the reverse engineering features to map existing databases to understand their structure and make improvements.
View full review »- Flexible and complete compare/merge facility
- Exposure of its automation object model which allows custom programming outside of the product
- Running macros on logical and physical models
- Compare and Merge
- Repository > Diagrams
- Security > Security Center
- Tools > Generate Reports
- Entity > Notes
- Attribute > Notes
- Reverse engineering physical database
- Compare and Merge utility
- Ease of use
- It looks good enough
- Ability to create HTML reports
- Ability to compare the model against the database
Reverse and Forward Engineering are very important. The former provides a facility to generate the overall design from an existing database. The latter allows the user to 'round-trip' changes from the model to a database so as you make changes these result in actual physical changes to the database structure.
View full review »
Strong graphic and formatting capabilities which can be used to stylize/classify tables of different uses/purposes. Reverse engineering function is useful in examining undocumented legacy databases. Object creation scripting tool has plenty of useful option with the ability to save configuration sets for consistent database builds. Intuitive user interface provides for quick learning curve.
View full review »
Buyer's Guide
IDERA ER/Studio
July 2025

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: July 2025.
861,803 professionals have used our research since 2012.