ER/Studio Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users admire the intuitive user interface of ER/Studio, which enhances the overall modeling and collaboration experience. (3 mentions)

Users appreciate the intuitive user interface of ER/Studio, making model creation easy and efficient. (2 mentions)

Users appreciate the powerful features of ER/Studio, enhancing database design and collaboration seamlessly. (2 mentions)

Users value the ease of collaboration in ER/Studio, appreciating its streamlining of complex database design processes. (1 mentions)

Users commend the excellent customer support for ER/Studio, enhancing their experience and troubleshooting efficiency. (1 mentions)

Users find the dashboard overwhelming for beginners, which can hinder their initial experience with ER/Studio. (1 mentions)

Users find the overwhelming dashboard of ER/Studio challenging, especially for those new to the software. (1 mentions)

Users note the limited database support as it remains client/server based, missing cloud-based integration options. (1 mentions)

Users find the outdated design of ER/Studio limiting, as it clings to client/server architecture in a cloud-focused world. (1 mentions)

Users find the dashboard overwhelming, especially for those who are new to the software and its features. (1 mentions)

5 Pros or Advantages of ER/Studio

1. User Interface

Users admire the intuitive user interface of ER/Studio, which enhances the overall modeling and collaboration experience.

See 3 mentions

See Related User Reviews

U

Verified User

Mid-Market (51-1000 emp.)

4.0/5

"Comprehensive Modeling Features, But Lags Behind in Cloud Adoption"

What do you like about ER/Studio?

It is possible to create conceptual, logical, and physical models, and to generate DDLs for a wide range of platforms. The tool also supports reverse

A

Verified User

Small-Business (50 or fewer emp.)

4.5/5

"Love the ER for data modelling"

What do you like about ER/Studio?

I love ER/Studio for its ability to handle complex database designs and make collaboration easier. It streamlines the whole process, from modeling to

2. Ease of Use

Users appreciate the intuitive user interface of ER/Studio, making model creation easy and efficient.

See 2 mentions

See Related User Reviews

U

Verified User

Mid-Market (51-1000 emp.)

4.0/5

"Comprehensive Modeling Features, But Lags Behind in Cloud Adoption"

What do you like about ER/Studio?

It is possible to create conceptual, logical, and physical models, and to generate DDLs for a wide range of platforms. The tool also supports reverse

HG

Harsh G.

Mid-Market (51-1000 emp.)

5.0/5

"Detailed Review of ER Studio"

What do you like about ER/Studio?

Few good things I liked - Easy integration with various database. Very User friendly interface. Easy to create database schemas. Provides extensive fe

3. Features

Users appreciate the powerful features of ER/Studio, enhancing database design and collaboration seamlessly.

See 2 mentions

See Related User Reviews

A

Verified User

Small-Business (50 or fewer emp.)

4.5/5

"Love the ER for data modelling"

What do you like about ER/Studio?

I love ER/Studio for its ability to handle complex database designs and make collaboration easier. It streamlines the whole process, from modeling to

HG

Harsh G.

Mid-Market (51-1000 emp.)

5.0/5

"Detailed Review of ER Studio"

What do you like about ER/Studio?

Few good things I liked - Easy integration with various database. Very User friendly interface. Easy to create database schemas. Provides extensive fe

4. Collaboration

Users value the ease of collaboration in ER/Studio, appreciating its streamlining of complex database design processes.

See 1 mentions

See Related User Reviews

A

Verified User

Small-Business (50 or fewer emp.)

4.5/5

"Love the ER for data modelling"

What do you like about ER/Studio?

I love ER/Studio for its ability to handle complex database designs and make collaboration easier. It streamlines the whole process, from modeling to

5. Customer Support

Users commend the excellent customer support for ER/Studio, enhancing their experience and troubleshooting efficiency.

Users find the dashboard overwhelming, especially for those who are new to the software and its features.

See 1 mentions

See Related User Reviews

A

Verified User

Small-Business (50 or fewer emp.)

4.5/5

"Love the ER for data modelling"

What do you dislike about ER/Studio?

A little overwhelming dashboard for beginners.

G2 reviews are authentic and verified.

Here's how.

CH

Verified User in Hospital & Health Care

Mid-Market (51-1000 emp.)

8/1/2021

"Great tool"

4.5/5

What do you like best about ER/Studio?

Having logical & physical diagram ability Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

Too many options buttons on the tool makes it clumsy Review collected by and hosted on G2.com.

UB

Verified User in Banking

Enterprise (> 1000 emp.)

4/4/2019

"ER/Studio Data Architect Professional - Bugs and Bugs ... Low Quality Support, Outdated, Expensive"

2.5/5

What do you like best about ER/Studio?

Easy to learn and use, wide database support. Has a robust data model version control. Client interface is very customizable. Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

A lot of bugs, specifically with databases like Informix and Apache HIVE. Based on a 3 years of experience technical support representatives are not very professional, even with the vendor's Platinum support subscription. Overall, the tool is failing to stay current and up to date with the latest technology trends and features. Data lineage feature of the tool is very cumbersome to use and does not have automated data lineage harvesting (or reverse-engineering of the data lineage). No API support to extract the metadata or to import new data models. No automated functionality to auto catalog new data models or data model objects. Data model printing does not support PDF format. Data model printing and sharing is difficult overall. Bugs with data types. Review collected by and hosted on G2.com.

Recommendations to others considering ER/Studio:

Tool is easy to use. Promises to support a lot of databases, however make sure it adequately supports the databases you are looking to use it with

Tool does not have an API. Tool does not allow automatically harvest data lineage. Tool's data lineage capability is cumbersome and difficult to use. Tool does not have an automated way to import new database entities. Data model metadata extraction is not automatic, difficult and requires a lot of custom SQL and VB development. Review collected by and hosted on G2.com.

What problems is ER/Studio solving and how is that benefiting you?

Data modeling, data lineage and data governance. Review collected by and hosted on G2.com.

EV

Eugene V.

Analytics Team Lead

Hospital & Health Care

Enterprise (> 1000 emp.)

1/18/2018

"great software for data modeling"

5/5

What do you like best about ER/Studio?

it is a great piece of software for creating data models for complex solutions Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

it take awhile to get started and if your not familiar with data modeling Review collected by and hosted on G2.com.

BS

Bert S.

Chief technology Officer

Enterprise (> 1000 emp.)

4/16/2015

Business partner of the seller or seller's competitor, not included in G2 scores.

"ER Studio is best of breed data modeling tool"

5/5

What do you like best about ER/Studio?

ER Studio is not only a comprehensive and robust data modeling tool - but it is designed and developed by a team that clearly understands data modeling needs and industry trends. A long time ago CA's ERwin was the tool of choice, but these days ER Studio provides as much or more functionality with a much clearer vision or product strategy. It also generates some of the best DDL from a data modeling tool - often requiring zero changes or modifications before executing. Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

there are a few too many "editions" - it ought to all just be one inclusive offering Review collected by and hosted on G2.com.

Recommendations to others considering ER/Studio:

When evaluating data modeling tools make sure not to only evaluate the diagramming aspects of the tool as the picture is only the tip of the iceberg. Good data models contain lots of metadata that's behind the picture and which results in higher quality database designs. Most freeware or shareware tools do a decent picture, but lack the metadata. So it's worth paying for a quality tool. Review collected by and hosted on G2.com.

What problems is ER/Studio solving and how is that benefiting you?

capturing and recording true business requirements and transforming them into a cohesive database design that is both effective and efficient. Review collected by and hosted on G2.com.