Data modeling.
Database Administrator at a healthcare company with 1,001-5,000 employees
Our developers can now see the relationships
Pros and Cons
- "The reverse engineering is the most important feature."
- "When building the relationships there should be a little more flexibility."
What is our primary use case?
How has it helped my organization?
The developers can see the relationships now.
What is most valuable?
The reverse engineering is the most important feature. The relationships are also important.
What needs improvement?
When building the relationships there should be a little more flexibility.
Buyer's Guide
IDERA ER/Studio
February 2025

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
What do I think about the stability of the solution?
I have not encountered any issues with stability.
What do I think about the scalability of the solution?
I have not encountered any issues with scalability.
How are customer service and support?
Tech support is pretty good. They resolve issues right away, I usually don't have to wait too long.
Which solution did I use previously and why did I switch?
I used a little bit of SQL Server. It has a data modeling tool. I also used some ERwin before that, a couple years ago.
How was the initial setup?
The initial setup was pretty easy.
What's my experience with pricing, setup cost, and licensing?
I feel the product's pricing is a good value.
Which other solutions did I evaluate?
I looked at ERwin.
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.

Infrastructure Expert at a tech services company with 1,001-5,000 employees
It's our primary means of publishing data models, but it needs to use more modern standard dialogs.
Valuable Features
- Flexible and complete compare/merge facility
- Exposure of its automation object model which allows custom programming outside of the product
Improvements to My Organization
It has been our primary means of publishing data models for years. It also houses our product data dictionary, and generates all the DDLs for database modifications.
Room for Improvement
- Easier licensing
- It would be nice if we could use more modern standard dialogs, such as file selection
Use of Solution
I've used it for 10 years.
Deployment Issues
It is not easy to deploy in VDI, but that is a VDI problem.
Customer Service and Technical Support
Good, although they don’t always contact you with a solution to problems if they think it’s your problem.
Initial Setup
Setup was not complex for an ordinary desktop installation. Server installation, however, is a good deal more complex. Their portal solution is more complex still.
Implementation Team
It was done in-house.
Pricing, Setup Cost and Licensing
It is expensive! Licensing requires a subscription to their support site.
Other Solutions Considered
It was selected before I arrived here, but it was evaluated against ErWin. It was the better product at the time.
Other Advice
It is a very robust, industrial strength data modeling product, intended Ideally for very large development projects where a good ROI can be obtained.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
IDERA ER/Studio
February 2025

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
838,713 professionals have used our research since 2012.
Infrastructure Expert at a tech services company with 1,001-5,000 employees
Huge advantage is that it gives you full access to its automation model.
What has proven to be a HUGE advantage of ER/Studio that was not really evaluated at the time we chose it is that it gives you full access to its automation model. This allows it to be controlled through code (VBA) in programs like MS Access. One reason this is helpful is that we work with huge models of around 1500 entities, 1500 tables, and 25,000 attributes and columns. We often find ourselves needing to make mass updates, and this is easily done with code in a tiny fraction of the time needed to do it manually. Another use is we can extract metadata in code and load it directly to an Oracle database (using MS Access) to publish for developers on the other side of the planet.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Consultant with 51-200 employees
You can compare your models against the database, but the repository can be slow with big data sets.
What is most valuable?
- Ease of use
- It looks good enough
- Ability to create HTML reports
- Ability to compare the model against the database
What needs improvement?
- Repository causes continuous problems, as it's slow and sometimes crashes.
- Integration with Active Directory does not function perfectly.
For how long have I used the solution?
I've used it for five years.
What do I think about the scalability of the solution?
If you use repository, it can get slow with big data models.
How are customer service and technical support?
I have received answers to issues within a week from a report.
Which solution did I use previously and why did I switch?
Nope, and I hear that this is the best data modelling tool for data warehouse scenarios.
How was the initial setup?
It's straightforward without the repository.
What about the implementation team?
I did everything, from the installation to using it.
Disclosure: My company has a business relationship with this vendor other than being a customer: We are partners with Embarcadero.
Administrador de Dados at a non-tech company with 5,001-10,000 employees
Enables creation of multiple automations, improving security and centralization
Pros and Cons
- "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."
- "Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
What is most valuable?
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.
How has it helped my organization?
Organization, security, centralization.
What needs improvement?
The product is pricey.
For how long have I used the solution?
About four years.
What do I think about the stability of the solution?
Sometimes our version is a little unstable. But I think this problem occurs because our version is old. We are in the migration process to the current version.
What do I think about the scalability of the solution?
No.
How are customer service and technical support?
Very good. When we need, they respond to us quickly.
Which solution did I use previously and why did I switch?
I didn’t use other solutions in my work, only in tests.
How was the initial setup?
A support member in my company helped with the initial installation.
What's my experience with pricing, setup cost, and licensing?
The product can have a high price.
Which other solutions did I evaluate?
Yes. erwin and ePower.
What other advice do I have?
Talk with other people before purchasing to learn about their experience with the product.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Data Management Specialist at a government with 1,001-5,000 employees
Data Dictionary Bindings is not very intuitive, but there are no stability issues.
What is most valuable?
- Repository > Diagrams
- Security > Security Center
- Tools > Generate Reports
- Entity > Notes
- Attribute > Notes
What needs improvement?
- Diagram Versioning is not very intuitive
- Data Dictionary Bindings is not very intuitive
For how long have I used the solution?
I've used it for three years.
What was my experience with deployment of the solution?
No issues encountered.
What do I think about the stability of the solution?
Not with the current release.
How are customer service and technical support?
Customer Service:
It's good.
Technical Support:It's good.
Which solution did I use previously and why did I switch?
I have personally used many modelling tools. My current company standardized on this one.
What about the implementation team?
We used a vendor team who were good.
What was our ROI?
None the enterprise does not utilize all its capabilities thus, much of the work done is ported to other tools.
What other advice do I have?
If using this tool to support a large team effort, get training for versioning
Disclosure: I am a real user, and this review is based on my own experience and opinions.

Buyer's Guide
Download our free IDERA ER/Studio Report and get advice and tips from experienced pros
sharing their opinions.
Updated: February 2025
Popular Comparisons
Sparx Systems Enterprise Architect
erwin Data Modeler by Quest
SAP PowerDesigner
iServer
BiZZdesign HoriZZon
erwin Evolve by Quest
IBM Rational System Architect
Buyer's Guide
Download our free IDERA ER/Studio Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Can you recommend a graphic illustration tool to model the architecture of IT systems?
- When evaluating Architecture Management, what aspect do you think is the most important to look for?
- Tools to Develop and Manage IT Infrastructure Road-maps
- Sparx system comparing with ARIS and IBM blueworks.
- What EA tool would you advise us to use?
- What are some business benefits associated with enterprise architecture?
- Any experience on newer/low-cost cloud based EA Modelling Tools?
- How to model an enterprise architecture? What tools and templates can I use?
- How to export IBM Rational System Architect data into Alfabet Enterprise Architecture Management (by Software AG)?
- Reading meta-data off local ERwin model.