IDERA ER/Studio Reviews, Competitors and Pricing

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

Feb 23, 2014

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.

it_user275646

Senior Consultant with 51-200 employees

Jul 26, 2015

Download

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.

Buyer's Guide

IDERA ER/Studio

January 2025

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: January 2025.

DOWNLOAD NOW

831,265 professionals have used our research since 2012.

it_user738693

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

Sep 18, 2017

Download

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.