No more typing reviews! Try our Samantha, our new voice AI agent.

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

IDERA ER/Studio enables extensive automation to enhance workflows and processes.
It efficiently documents data lineage and data flows between systems.
The ability to reverse-engineer databases and create models from scratch is highly valued.
Shared repository allows multiple users to work simultaneously on comprehensive enterprise models.
Strong reverse-engineering and DDL generation features are fundamental for database development.

CONS

IDERA ER/Studio can be unstable when used with older versions, leading to issues such as unsuccessful installations and database corruption.
Better documentation and tutorials are needed to help users understand the benefits of upgrades from a business perspective, as the release notes focus heavily on technical enhancements.
The debugging process is cumbersome, and users would benefit from a built-in debugging feature to identify and resolve errors independently.
There are performance issues with repository functions like checking in and out, and reverse-engineering large databases with about 3,000 tables often causes the system to freeze.
IDERA ER/Studio's metadata management is not as effective as Erwin's, particularly in the context of large-scale operations.
 

IDERA ER/Studio Pros review quotes

reviewer2796111 - PeerSpot reviewer
Data Architect at a financial services firm with 10,001+ employees
Jan 12, 2026
IDERA ER_Studio does a lot more and performs model comparison much better than Erwin.
KP
Works at a energy/utilities company with 10,001+ employees
Feb 7, 2025
ER/Studio is excellent for large teams; it scales well to teams of over one hundred plus people.
Aaron Cutshall - PeerSpot reviewer
Enterprise Data Architect & Senior Manager at Health First Inc.
Jun 17, 2024
I like the fact that it has a scripting language that allows you to automate and write your own scripts.
Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,221 professionals have used our research since 2012.
JM
Managing Partner at DXC Technology
Feb 7, 2025
It was a very good tool at the time since it was complete.
Diane Blaum - PeerSpot reviewer
Data Architect at a performing arts with 201-500 employees
May 15, 2024
The most valuable feature of the solution is generating DDL (data definition language).
AntonyRaj - PeerSpot reviewer
Data Modeler at Ascendion
Jan 15, 2025
I set up this tool and found it to be very simple.
Anderson-Moura - PeerSpot reviewer
Assistant Architect at a energy/utilities company with 501-1,000 employees
Oct 19, 2022
The data modeling and reverse engineering features are most important to us.
reviewer1429329 - PeerSpot reviewer
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
Oct 7, 2020
Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface.
DN
Oracle developer at OKsystem a.s.
May 11, 2023
The tool is simple to use.
it_user1477701 - PeerSpot reviewer
Data Architect at a financial services firm with 501-1,000 employees
Jan 10, 2021
It does the job.
 

IDERA ER/Studio Cons review quotes

reviewer2796111 - PeerSpot reviewer
Data Architect at a financial services firm with 10,001+ employees
Jan 12, 2026
I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's.
KP
Works at a energy/utilities company with 10,001+ employees
Feb 7, 2025
ER/Studio lacks a pure cloud option for deployment.
Aaron Cutshall - PeerSpot reviewer
Enterprise Data Architect & Senior Manager at Health First Inc.
Jun 17, 2024
The solution is not so strong at creating modeling views and database views.
Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,221 professionals have used our research since 2012.
JM
Managing Partner at DXC Technology
Feb 7, 2025
There was no specific mention of areas needing improvement.
Diane Blaum - PeerSpot reviewer
Data Architect at a performing arts with 201-500 employees
May 15, 2024
The solution's reporting could be improved because the report writer is terrible.
AntonyRaj - PeerSpot reviewer
Data Modeler at Ascendion
Jan 15, 2025
I cannot evaluate any areas for improvement at this time.
Anderson-Moura - PeerSpot reviewer
Assistant Architect at a energy/utilities company with 501-1,000 employees
Oct 19, 2022
They allow functionalities to be released before the full tests for catching and correcting errors are completed.
reviewer1429329 - PeerSpot reviewer
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
Oct 7, 2020
The model diagram because very clumsy when you save it on the team server and the models are very big.
DN
Oracle developer at OKsystem a.s.
May 11, 2023
It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization
it_user1477701 - PeerSpot reviewer
Data Architect at a financial services firm with 501-1,000 employees
Jan 10, 2021
What needs the most improvement are semantic lineage and usability.