We use the solution for data modeling, including both relational and dimensional data models.
The complexities allowed in the models and the expressiveness are the most valuable features of the solution. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts.
Since the solution was originally developed in the eighties and nineties and hasn't changed much since then, it could use an overhaul. The solution is not so strong at creating modeling views and database views.
I have been using IDERA ER/Studio since 2018.
There are some areas where the solution could be more stable, and its performance could be better. I think this is mainly due to its legacy environment.
I rate the solution an eight out of ten for stability.
We have five concurrent licenses for IDERA ER/Studio. The solution's scalability is good.
I rate the solution's scalability an eight out of ten. If IDERA were to put the tool into a cloud environment instead of an on-premises environment, then it would be even higher.
The solution's technical support is good. Sometimes, getting the support team to respond takes time.
I have previously worked with erwin, and I understand its capabilities. IDERA ER/Studio and erwin are rather comparable. They just do things a little differently, but they have basically the same type of enterprise-wide capabilities. I've also looked at some cloud offerings, and they don't have the same level of support for logical models as IDERA ER/Studio or erwin.
The solution's initial setup was not as easy as I had hoped.
On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup an eight out of ten.
The solution was deployed by me.
The solution’s pricing is high.
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains.
The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network.
The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that.
Overall, I rate the solution an eight out of ten.
