IDERA ER/Studio Review

Database schemas help us understand the logic, the business processes, behind the scenes

What is our primary use case?

We use it to develop our data warehouse, it's the core server.

How has it helped my organization?

It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time.

What is most valuable?

The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes.

What needs improvement?

They is a lot of room of improvement. I have emailed and have asked for things but nothing has been done. For example, when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error.

Another situation is that I need, and I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine, because I have 20 or 30 tables. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio. 

Those are the two main problems that I encounter today.

For how long have I used the solution?

One to three years.

What do I think about the stability of the solution?

I have not encountered any issues with the stability of the product.

What do I think about the scalability of the solution?

As I mentioned, I cannot upload the 3,000-table database. It cannot work with that.

How is customer service and technical support?

Overall, technical support is okay. It's fast and usually, within four or five hours, I get a reply.

How was the initial setup?

The setup was very easy. Everything was fine during the installation process.

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

I think the pricing matches what we get from the product. It is good value.

Licensing is a bit of a complicated process because there are three different types of licenses and sometimes it's a bit confusing. For example, when we had to reinstall Windows, and they had to contact support so that they reissue the license for me, that was not easy. It would be easier if I had the number and I could use that number for the computer, somehow. It should connect to the hardware, not to Windows. Because each time I need to update Windows, they need to contact support to reissue licenses or switch to another type of license. They mention that there are additional charges for this. It's not an easy process for users. It should be way easier.

Which other solutions did I evaluate?

I considered erwin software and I compared different functionalities and installed a trial version before choosing this software. I analyzed and found out that this software would match our needs more, in terms of flexibility and the features that it allows us to do. Also, I like that we have logical and physical modeling. We can have two separate environments for different purposes to develop the structures.

What other advice do I have?

Any advice would depend on the infrastructure, but just start using it more and more. It's mainly for developing databases. If you have a smaller number of tables and all of them are relational, you may not need this software. But, if you have a data warehouse that needs to be developed and you need to frequently implement changes to the databases, it will help.

I rate the solution a rating of eight out of ten. I would consider it one of the best solutions on the market.

**Disclosure: IT Central Station contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
More IDERA ER/Studio reviews from users
...who work at a Government
...who compared it with erwin Data Modeler (DM)
Find out what your peers are saying about IDERA, erwin, Inc., SAP and others in Architecture Management. Updated: December 2020.
454,950 professionals have used our research since 2012.
Add a Comment