IDERA ER/Studio Review

Great product. Tedious implementation and maintenance. Ultimately worth it considering other options.

Valuable Features:

Strong graphic and formatting capabilities which can be used to stylize/classify tables of different uses/purposes. Reverse engineering function is useful in examining undocumented legacy databases. Object creation scripting tool has plenty of useful option with the ability to save configuration sets for consistent database builds. Intuitive user interface provides for quick learning curve.

Improvements to My Organization:

Our company designs and builds databases in ER/Studio before other database builds or other development. This provides for identifying potential issues long before any code has been written. Data models are often the basis for functionality discussions between the business, analysts, and developers.

Room for Improvement:

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. The documentation is poor and new installations are tedious, to say nothing of the need for network operations resources to maintain the server apps.

Use of Solution:

Nine years.

Deployment Issues:

Countless licensing and app launching issues. Support was friendly enough, but that we needed them as often as we did was the real problem. We are a small company with four data modellers. No need for complicated licensing and deployment schemes.

Stability Issues:

The app itself is quite stable. On rare occasions, particularly where models grew large and complex over time, a model would go haywire and become corrupt or otherwise exhibit abnormal behavior. Luckily we could revert to the previous version from our source control system.

Previous Solutions:

I've used Power Designer and ER Win in the past. PD was a decent app, if quirky. I'm not a fan of ER Win. It strikes me as a forgotten app that has been kicked around to too many owners over the years without proper investment in refactoring and improvement.

Initial Setup:

Complex in that it requires installation of two server-based apps on the network for licensing and centralized launch/deployment. The server requires download and application of license files generated by Embarcadero and manual definition and maintenance of licensed users. On the deployment side, the app distribution server downloads updated versions of apps and serves them to the Java-based launcher app on client machines. This app (end user Java app) was tedious and often an extremely slow performer. We opted for full local install where possible to avoid interaction with the launcher app. Our company has no need for cloud-based application distribution and launching.

Implementation Team:

Internal network operations team.

Cost and Licensing Advice:

Over nine years, we have spent approximately $3K-$4K per year on each user (we have five data modelers currently).

Other Solutions Considered:

ER Win and two others, although their names escape me as it was nine years ago.

Other Advice:

Great product. Tedious implementation and maintenance. Ultimately worth it considering other options.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
2 visitors found this review helpful
1 Comment
Infrastructure Expert at a tech services company with 1,001-5,000 employeesConsultant

I would like to whole-heartedly agree with issues concerning installation and setup. It has been very difficult to get ER/Studio to work properly with a server license for use in VDI. I work for a very large organization where the many groups we need to deal with are less than quick to get things done. Due to the restrictive nature of VDI, we had to go through a tedious process of changing firewall rules to allow ER/Studio to see the database servers used for reverse-engineering. We finally had to convince the powers that be (against their policy) to allow us to use VPN so that the application could run locally and access the network only as needed. Licensing this product can be a real pain, especially if you have to run a server license with the separate Embarcadero License Server installed. It definitely needs to be easier and simpler. It is a powerful and very functional product, but getting it to work correctly in VDI has been a real chore.

04 May 15

Sign Up with Email