MA

Mayank A.

Senior Analyst

Enterprise (> 1000 emp.)

7/23/2021

"ER studio for physical data modelling"

4.5/5

What do you like best about ER/Studio?

Easy to use and handy. I did use it for physical data modeling. UI is good. Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

More features need to add to make it more interactive. Review collected by and hosted on G2.com.

CL

Verified User in Logistics and Supply Chain

Mid-Market (51-1000 emp.)

7/29/2021

"ER/Studio for managing data models"

4.5/5

What do you like best about ER/Studio?

It is a great tool for developing, managing and maintaining data models in terms of logical and physical levels. Also helpful for drawings for conceptual levels. Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

metadata design could be improved.

designing Relationships are a bit complicated. Review collected by and hosted on G2.com.

CI

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

8/19/2021

"Old User"

3.5/5

What do you like best about ER/Studio?

Convenient database schema modeling tool. Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

There are no significant dislikes of the product right now. Review collected by and hosted on G2.com.

AA

Verified User in Airlines/Aviation

Mid-Market (51-1000 emp.)

8/1/2021

"Top Tool For ER Diagram"

3/5

What do you like best about ER/Studio?

Easy of usabiy it provides . Review collected by and hosted on G2.com.

What do you dislike about ER/Studio?

Sometimes unable to find exact solutions for issue we face Review collected by and hosted on G2.com.

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.