IDERA ER/Studio Review

Although it allows for many different options for what can be displayed on the model, it would be nice if they allowed entity objects (attributes, indexes, keys...) as well as the textual definition.


What is most valuable?

The ability to define a set of domain definitions and group them in folders is a valuable feature. There is also a Macro (VB script) feature that allows you to automate many features that can save a lot of time.

What needs improvement?

Although the tool allows for many different options as far as the what can be displayed on the model, it would be nice if they allowed for entity objects (attributes, indexes, keys, etc.) as well as the textual definition of the object. The current design only allows one or the other. I like to have a little verbiage on each entity included in the model that describes it purpose, this is allowed in the tool but you can't show both the entity structure and the text at the same time without creating a separate text object and placing the text in it.

For how long have I used the solution?

I've been personally using this product for 9 Years.

What was my experience with deployment of the solution?

Deployment can be complicated with their licensing model. I typically have to call tech support to get the correct files and licensing all straightened out.

What do I think about the scalability of the solution?

The repository which is used to store the models can slow down when multiple models are added. This has improved with later releases but it is still slow at times.

How are customer service and technical support?

Customer Service:

Customer service is very good but they're a west coast company and we're on the east coast and I have to wait until later in the morning before I can talk to a support person.

Technical Support:

Technical support is typically very good.

Which solution did I use previously and why did I switch?

I had prior experience with Sybase's Power Designer tool at a former employer. When I came to this company they had other Embarcadero tools and were interested in using a single vendor for SQL Server development.

How was the initial setup?

Installation of the product itself is straight forward although the licensing process is awkward and confusing at best. If you have a workstation license that's not to bad, but we have a WS and 2 different concurrent licenses, which requires a license server set up and getting all the proper installations products requires (me anyway) to contact the support to get the correct files and the correct licensing information.

If you have a repository setup that increases the process even more.

What about the implementation team?

I'm the administrator for our ER/Studio setup for our IT department, we have 5 or so actual users of the tool.

What's my experience with pricing, setup cost, and licensing?

Fairly expensive tool and licensing setup is cumbersome.

Which other solutions did I evaluate?

Sybase Power Designer

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
1 Comment
author avatarDatabase Architect at a healthcare company with 1,001-5,000 employees
Vendor

I just updated this review, the title was missing a key point and I noticed a few misspellings and type-o's.
It reads a bit better now.

Guest