Try our new research platform with insights from 80,000+ expert users

IDERA ER/Studio pros and cons

Vendor: IDERA

4.2 out of 5

39 reviews
88% willing to recommend

Pros & Cons summary

IDERA ER/Studio enhances automation for workflows, documents data lineage efficiently, and allows reverse-engineering and model creation. It supports collaborative enterprise modeling with a shared repository, but performance issues like system freezing with large databases exist. Instability with older versions and inadequate documentation hinder its use. Users face cumbersome debugging and metadata management struggles compared to Erwin. Better tutorials for business upgrades are needed to address these technical challenges.

Buyer's Guide

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

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

Director at a tech services company with 51-200 employees

Mar 20, 2014

Intuitive user interface provides for quick learning curve.

Read full review

Senior Consultant with 501-1,000 employees

Jul 22, 2015

I think it's the best due to pricing and good overall support.

Read full review

Senior Consultant with 51-200 employees

Jul 26, 2015

Ease of use It looks good enough Ability to create HTML reports Ability to compare the model against the database

Read full review

IDERA ER/Studio

Free Report: IDERA ER/Studio Reviews and More

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.

884,873 professionals have used our research since 2012.

Senior SQL Server Developer at a tech vendor with 201-500 employees

Jul 26, 2015

With both onshore and offshore development teams working 18x5 days, it is an easy way to control check-in's while also maintaining schema views.

Read full review

Database Architect at a healthcare company with 1,001-5,000 employees

May 4, 2016

It's a great tool for modeling and I'm generally very happy with its features.

Read full review

Data Management Specialist at a government with 1,001-5,000 employees

Aug 4, 2015

Customer Service: It's good.

Read full review

Principal Data Architect at a tech company with 201-500 employees

Aug 23, 2015

I am able to create (and publish) logical data models, apply naming standards using macro, generate the physical models and DDL.

Read full review

Infrastructure Expert at a tech services company with 1,001-5,000 employees

Aug 26, 2015

It is a very robust, industrial strength data modeling product, intended ideally for very large development projects where a good ROI can be obtained.

Read full review

Administrador de Dados at a non-tech company with 5,001-10,000 employees

Sep 18, 2017

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.

Read full review

LW

Data Architect at a insurance company with 1,001-5,000 employees

Jan 25, 2018

We are able to document the data lineage and data flows of our data from one system to another.

Read full review

Show 10 more reviews (out of 24)

IDERA ER/Studio Cons review quotes

Director at a tech services company with 51-200 employees

Mar 20, 2014

The deployment and licensing facets of this product are beyond maddening, requiring even small organizations such as ours to install and maintain two server apps to handle real-time license enforcement and centralized (Tool Cloud) product launching.

Read full review

Senior Consultant with 501-1,000 employees

Jul 22, 2015

The print facility is a little lacking.

Read full review

Senior Consultant with 51-200 employees

Jul 26, 2015

The repository causes continuous problems, as it's slow and sometimes crashes.

Read full review

IDERA ER/Studio

Free Report: IDERA ER/Studio Reviews and More

Learn what your peers think about IDERA ER/Studio. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.

884,873 professionals have used our research since 2012.

Senior SQL Server Developer at a tech vendor with 201-500 employees

Jul 26, 2015

This version does not properly generate SQL Server computed columns; future versions do this.

Read full review

Database Architect at a healthcare company with 1,001-5,000 employees

May 4, 2016

Installation of the product itself is straight forward although the licensing process is awkward and confusing at best.

Read full review

Data Management Specialist at a government with 1,001-5,000 employees

Aug 4, 2015

Diagram versioning is not very intuitive Data Dictionary Bindings is not very intuitive

Read full review

Principal Data Architect at a tech company with 201-500 employees

Aug 23, 2015

Product registration always seemed difficult and time consuming.

Read full review

Infrastructure Expert at a tech services company with 1,001-5,000 employees

Aug 26, 2015

It is expensive! Licensing requires a subscription to their support site.

Read full review

Administrador de Dados at a non-tech company with 5,001-10,000 employees

Sep 18, 2017

Sometimes our version is a little unstable. But I think this problem occurs because our version is old.

Read full review

LW

Data Architect at a insurance company with 1,001-5,000 employees

Jan 25, 2018

I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be.

Read full review

Show 10 more reviews (out of 24)

Product Categories

Product Categories

Enterprise Architecture Management

Database Development and Management

Popular Comparisons

Popular Comparisons

Sparx Systems Enterprise Architect vs IDERA ER/Studio

LeanIX vs IDERA ER/Studio

erwin Data Modeler vs IDERA ER/Studio

SAP PowerDesigner vs IDERA ER/Studio

BiZZdesign HoriZZon vs IDERA ER/Studio

iServer vs IDERA ER/Studio

Foglight for Databases vs IDERA ER/Studio

erwin Evolve vs IDERA ER/Studio

PTC Windchill vs IDERA ER/Studio

Oracle Coherence vs IDERA ER/Studio

SolarWinds Database Performance Analyzer vs IDERA ER/Studio

Redgate SQL Toolbelt Essentials vs IDERA ER/Studio

Toad Data Modeler vs IDERA ER/Studio

IBM Rational System Architect vs IDERA ER/Studio

Aqua Data Studio vs IDERA ER/Studio

See all alternatives

Product Categories

Product Categories

Enterprise Architecture Management

Database Development and Management

Popular Comparisons

Popular Comparisons

Sparx Systems Enterprise Architect vs IDERA ER/Studio

LeanIX vs IDERA ER/Studio

erwin Data Modeler vs IDERA ER/Studio

SAP PowerDesigner vs IDERA ER/Studio

BiZZdesign HoriZZon vs IDERA ER/Studio

iServer vs IDERA ER/Studio

Foglight for Databases vs IDERA ER/Studio

erwin Evolve vs IDERA ER/Studio

PTC Windchill vs IDERA ER/Studio

Oracle Coherence vs IDERA ER/Studio

SolarWinds Database Performance Analyzer vs IDERA ER/Studio

Redgate SQL Toolbelt Essentials vs IDERA ER/Studio

Toad Data Modeler vs IDERA ER/Studio

IBM Rational System Architect vs IDERA ER/Studio

Aqua Data Studio vs IDERA ER/Studio

See all alternatives

Related questions

44

Can you recommend a graphic illustration tool to model the architecture of IT systems?

35

When evaluating Architecture Management, what aspect do you think is the most important to look for?

38

Tools to Develop and Manage IT Infrastructure Road-maps

38

Sparx system comparing with ARIS and IBM blueworks.

165

What EA tool would you advise us to use?

30

What are some business benefits associated with enterprise architecture?

32

Any experience on newer/low-cost cloud based EA Modelling Tools?

161

How to model an enterprise architecture? What tools and templates can I use?

21

How to export IBM Rational System Architect data into Alfabet Enterprise Architecture Management (by Software AG)?

17

Reading meta-data off local ERwin model.