Data Architect at a financial services firm with 10,001+ employees
Real User
Top 20
Jan 12, 2026
I have not used IDERA ER_Studio's impact analysis tools, so I really could not judge that regarding mitigating database risks for security. I am not on the end as far as the pricing, as this is what the enterprise uses, so that is what I use. Years ago, the costing model was different; it was more of an enterprise type of product, while IDERA was connected to the external system, meaning you had to pay for whatever system, such as if you were connecting to Oracle, you would have one price, and if you connected to SQL Server, it would be another price. That may have changed in the last 10 years. We are using IDERA ER_Studio with both on-premises and cloud, and that is seamless. I would rate this product an 8 overall.
Works at a energy/utilities company with 10,001+ employees
Real User
Top 5
Feb 7, 2025
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's okay. If I had to rate ER/Studio, I would give it nine out of ten because the absence of a cloud version is a limitation. Overall, I rate this solution 9 out of 10.
Enterprise Data Architect & Senior Manager at Health First Inc.
Real User
Top 5
Jun 17, 2024
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.
Data Architect at a performing arts with 201-500 employees
Real User
Top 10
May 15, 2024
New users must ensure that the report writing will do what they want it to. Other than that, the solution is perfectly fine. Overall, I rate the solution a seven out of ten.
Assistant Architect at a energy/utilities company with 501-1,000 employees
Real User
Top 20
Oct 19, 2022
I would tell those who are planning to use the tool that I think the interface is okay; there's no problem with it. They need to verify whether the portal has all the functionalities that they are expecting. It's very useful to do a POC to test the functionalities and verify that the database will work okay with the company. I would rate this solution as an eight out of ten.
Data Architect at a financial services firm with 501-1,000 employees
Real User
Jan 10, 2021
My advice for anybody who is considering this product is to understand what your requirements are of the system, of whatever tool you're going to select. There are loads of people and organizations that have bought this product and used it, and that's dependent upon their requirements, their needs. Plenty of others have bought SAP PowerDesigner. Personally, and I'm self-employed, or a freelance contractor, I invested more money and decided on SAP Power Designer. Overall, I don't like any of the features and I think that it's a poor system. I would rate this solution a five out of ten.
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
Real User
Oct 7, 2020
My advice to anybody who is considering ER Studio is to look at the size of their models. If they have very large models then it may not be suitable because we are having performance issues in this case. On the other hand, if they have midsized models then I think it is pretty good. Overall, this product is pretty good. It can certainly be better but it still has features that are quite good. I would rate this solution a seven out of ten.
Database Developer at a financial services firm with 1,001-5,000 employees
Real User
Nov 28, 2018
I would recommend IDERA ER/Studio, but people in my profession are divided by their loyalties. I am loyal to this product, but if you talk to another developer who has been using erwin all his life, that person might say, "Hey, erwin is better." I say ER/Studio is good but in the world of developers, people still have to evaluate things for themselves. I have no complaints. That's why I've been using it for so long. I rate it a nine out of ten. It's easy and fast to use.
Senior Business Intelligence Developer at a construction company with 501-1,000 employees
Real User
Nov 1, 2018
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.
Database Administrator at a government with 10,001+ employees
Real User
Oct 29, 2018
You will save time, switching from whatever product you're using. It's the best data modeling tool out there. It's fast. It can do what I need it to do. We connected to Oracle, MySQL, and SQL Server (as data sources) to this solution. I have plans to expand the use of the built-in tool functionality. However, I haven't had the time.
I really like ER/Studio personally, so for me, it's a nine out of 10. I like it because it doesn't let you make stupid mistakes - and it's easy to make a stupid mistake. The tool can save you a lot of trouble. The only other tool I used before this was Oracle Designer, back in the 90s. This is way better than that. I haven't used anything else, so I'm a loyal customer.
Asst. Director, Data Management & Analytics at a healthcare company with 10,001+ employees
Real User
Aug 16, 2018
ER/Studio is good. It is really user-friendly and you can start without much training. If modeling is a technique you know, you're familiar with all the concepts, you can sit with the tool and start doing the modeling. Not much training is needed.
IT Specialist at a government with 10,001+ employees
Real User
Aug 7, 2018
Especially with the Repository/Team Server installation, get Idera to install it for you. Just watch over their shoulder while they do it. Otherwise, just learn it and enjoy it. I rate this product at nine out of 10 because it does so much. It's so powerful. The only reason I don't give it a 10 is because it probably has things in it that I'll never use because I don't know how to use them.
Database Designer at a manufacturing company with 1,001-5,000 employees
Real User
Aug 5, 2018
Try to take advantage of as many of the features as you can. It has a wealth of time-savers and features that are extremely useful. We haven't been able to use all of them because we already had so much done. To try and use some of them by going back over thousands and thousands of tables and columns would have been impossible. If you are is just starting with it, if you can take advantage of the Data Lineage and some of the other interesting features that it has, it is definitely worthwhile. My rating comes from a purely selfish perspective, in the way I use it. For what I do, I give it an eight out of 10. The reason is - and this is partly our fault because we haven't finished, we haven't upgraded to newest release yet - that there are some buggy things in it that we still have to get resolved. For us, upgrading is very difficult because we have so many people, and we have to coordinate with our database people. Our services are now outsourced, so to coordinate things and get everybody on and get an upgrade done is not easy. Obviously, we try to avoid it as long as we can.
Data Architect at a computer software company with 1,001-5,000 employees
Real User
Aug 2, 2018
It's a good tool but we have not had much training, so we are really exploring it on our own. There are some features we are still working on with our stakeholders to implement. So my advice to other customers who are implementing this product is to really understand the full features of the product and try to implement all the features at the beginning. Get training in all areas of expertise before launching the product. I wish we could have done that from the beginning.
IDERA ER/Studio provides advanced data modeling and reverse engineering capabilities, supporting collaboration via a centralized repository. Its intuitive interface and extensive automation options enhance teamwork and data governance for complex database structures.
IDERA ER/Studio is a comprehensive platform for data modeling, database design, and reverse engineering. It plays a key role in building data governance programs and managing enterprise models. The tool integrates well with...
I have not used IDERA ER_Studio's impact analysis tools, so I really could not judge that regarding mitigating database risks for security. I am not on the end as far as the pricing, as this is what the enterprise uses, so that is what I use. Years ago, the costing model was different; it was more of an enterprise type of product, while IDERA was connected to the external system, meaning you had to pay for whatever system, such as if you were connecting to Oracle, you would have one price, and if you connected to SQL Server, it would be another price. That may have changed in the last 10 years. We are using IDERA ER_Studio with both on-premises and cloud, and that is seamless. I would rate this product an 8 overall.
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's okay. If I had to rate ER/Studio, I would give it nine out of ten because the absence of a cloud version is a limitation. Overall, I rate this solution 9 out of 10.
My overall rating for the solution is ten out of ten.
I would 100% recommend the product. Out of ten, I would rate it nine out of ten.
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.
New users must ensure that the report writing will do what they want it to. Other than that, the solution is perfectly fine. Overall, I rate the solution a seven out of ten.
I would rate the product a nine out of ten. The tool is simple to use.
I would tell those who are planning to use the tool that I think the interface is okay; there's no problem with it. They need to verify whether the portal has all the functionalities that they are expecting. It's very useful to do a POC to test the functionalities and verify that the database will work okay with the company. I would rate this solution as an eight out of ten.
My advice for anybody who is considering this product is to understand what your requirements are of the system, of whatever tool you're going to select. There are loads of people and organizations that have bought this product and used it, and that's dependent upon their requirements, their needs. Plenty of others have bought SAP PowerDesigner. Personally, and I'm self-employed, or a freelance contractor, I invested more money and decided on SAP Power Designer. Overall, I don't like any of the features and I think that it's a poor system. I would rate this solution a five out of ten.
My advice to anybody who is considering ER Studio is to look at the size of their models. If they have very large models then it may not be suitable because we are having performance issues in this case. On the other hand, if they have midsized models then I think it is pretty good. Overall, this product is pretty good. It can certainly be better but it still has features that are quite good. I would rate this solution a seven out of ten.
I would rate this solution a seven out of ten.
It is a good product but it needs improvement of the documentation process.
I would recommend IDERA ER/Studio, but people in my profession are divided by their loyalties. I am loyal to this product, but if you talk to another developer who has been using erwin all his life, that person might say, "Hey, erwin is better." I say ER/Studio is good but in the world of developers, people still have to evaluate things for themselves. I have no complaints. That's why I've been using it for so long. I rate it a nine out of ten. It's easy and fast to use.
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.
You will save time, switching from whatever product you're using. It's the best data modeling tool out there. It's fast. It can do what I need it to do. We connected to Oracle, MySQL, and SQL Server (as data sources) to this solution. I have plans to expand the use of the built-in tool functionality. However, I haven't had the time.
I really like ER/Studio personally, so for me, it's a nine out of 10. I like it because it doesn't let you make stupid mistakes - and it's easy to make a stupid mistake. The tool can save you a lot of trouble. The only other tool I used before this was Oracle Designer, back in the 90s. This is way better than that. I haven't used anything else, so I'm a loyal customer.
ER/Studio is good. It is really user-friendly and you can start without much training. If modeling is a technique you know, you're familiar with all the concepts, you can sit with the tool and start doing the modeling. Not much training is needed.
There are a lot of options, so take the time to play with it a bit before you start doing things the hard way.
Especially with the Repository/Team Server installation, get Idera to install it for you. Just watch over their shoulder while they do it. Otherwise, just learn it and enjoy it. I rate this product at nine out of 10 because it does so much. It's so powerful. The only reason I don't give it a 10 is because it probably has things in it that I'll never use because I don't know how to use them.
Try to take advantage of as many of the features as you can. It has a wealth of time-savers and features that are extremely useful. We haven't been able to use all of them because we already had so much done. To try and use some of them by going back over thousands and thousands of tables and columns would have been impossible. If you are is just starting with it, if you can take advantage of the Data Lineage and some of the other interesting features that it has, it is definitely worthwhile. My rating comes from a purely selfish perspective, in the way I use it. For what I do, I give it an eight out of 10. The reason is - and this is partly our fault because we haven't finished, we haven't upgraded to newest release yet - that there are some buggy things in it that we still have to get resolved. For us, upgrading is very difficult because we have so many people, and we have to coordinate with our database people. Our services are now outsourced, so to coordinate things and get everybody on and get an upgrade done is not easy. Obviously, we try to avoid it as long as we can.
It's a good tool but we have not had much training, so we are really exploring it on our own. There are some features we are still working on with our stakeholders to implement. So my advice to other customers who are implementing this product is to really understand the full features of the product and try to implement all the features at the beginning. Get training in all areas of expertise before launching the product. I wish we could have done that from the beginning.