Business Solutions Specialist at a energy/utilities company with 10,001+ employees
Real User
Top 5
2025-02-07T13:07:00Z
Feb 7, 2025
ER/Studio lacks a pure cloud option for deployment. Both Erwin and ER/Studio do not have AI or machine learning features for automation. Offering a comprehensive cloud-based version could enhance its usability.
Enterprise Data Architect & Senior Manager at Health First Inc.
Real User
Top 10
2024-06-17T09:21:52Z
Jun 17, 2024
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.
Data Architect at a performing arts with 201-500 employees
Real User
Top 5
2024-05-15T12:10:46Z
May 15, 2024
The solution's reporting could be improved because the report writer is terrible. Writing definitions and not being able to generate a nice report to view is useless. To me, that's a huge problem.
It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization
With ER/Studio, the roadmap to send us new versions with the new database is slow. I think it could allow us to test and use new database versions faster. Sometimes we get new functionalities like, for example, the Collibra integration. We receive these new functionalities, and sometimes we start to test them and we find errors that we need to correct by talking with tech support. I think they allow functionalities to be released before the full tests for catching and correcting errors are completed. My other point is about the team server. We're using the web portal, and the interface is not so good. The client was modified, and we have the new version. It's good. The client is good to us, but the web portal is using the old UI. It's not as modern, and it's limited. We found that the new version is slow when compared to the older version. We are trying to investigate what component is causing the slowness, because you have the client access, the repository, the API, the team server, and the web portal. Getting a single sign-on feature is very important to us.
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
Real User
2020-10-07T07:04:40Z
Oct 7, 2020
The model diagram because very clumsy when you save it on the team server and the models are very big. It becomes difficult to enlarge and difficult to print. Although they say that it supports concurrent users, we have issues while branching, merging, and performing check-in or check-out. It's not as seamless as it should be. Now that we are all working from home and our repository is on the cloud servers, we are experiencing issues with performance. In general, support for big data should be improved.
Data Architect at a pharma/biotech company with 1,001-5,000 employees
Real User
2020-07-13T06:56:52Z
Jul 13, 2020
The visual presentation is a little too colorful and seems that it is dumbed down. I would like to see support for creating macros in the way that erwin can. It did not reverse engineer all of the data types correctly, although it was pretty close. The only mistake was with some Oracle table objects, where it incorrectly determined them to be character references.
Senior Business Intelligence Developer at a construction company with 501-1,000 employees
Real User
2018-11-01T11:57:00Z
Nov 1, 2018
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.
Database Administrator at a government with 10,001+ employees
Real User
2018-10-29T15:46:00Z
Oct 29, 2018
The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare). The screens are a bit outdated. They could use a new look and feel.
It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo. Also, Business Objects doesn't seem to be very stable at the moment, so we've stopped using that.
Asst. Director, Data Management & Analytics at a healthcare company with 10,001+ employees
Real User
2018-08-16T08:28:00Z
Aug 16, 2018
I've been an ERwin user for quite some time, almost 10 years. One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct. We can directly relate to different keys but here it is a little more complicated than ERwin.
Database Designer at a manufacturing company with 1,001-5,000 employees
Real User
2018-08-05T06:48:00Z
Aug 5, 2018
What I would like to see improved is the reliability of the releases, releases that are a little less buggy. Also, I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use, to find out where the problem that threw that error occurs. That would be a really cool feature.
Data Architect at a computer software company with 1,001-5,000 employees
Real User
2018-08-02T11:48:00Z
Aug 2, 2018
Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade. For example, we are moving from 16 to 17. What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business. I already mentioned this to my account manager. He said they will put me with one of the product development teams to have this kind of discussion.
IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the...
ER/Studio lacks a pure cloud option for deployment. Both Erwin and ER/Studio do not have AI or machine learning features for automation. Offering a comprehensive cloud-based version could enhance its usability.
There was no specific mention of areas needing improvement.
I cannot evaluate any areas for improvement at this time. I need more time to assess this aspect.
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.
The solution's reporting could be improved because the report writer is terrible. Writing definitions and not being able to generate a nice report to view is useless. To me, that's a huge problem.
It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization
With ER/Studio, the roadmap to send us new versions with the new database is slow. I think it could allow us to test and use new database versions faster. Sometimes we get new functionalities like, for example, the Collibra integration. We receive these new functionalities, and sometimes we start to test them and we find errors that we need to correct by talking with tech support. I think they allow functionalities to be released before the full tests for catching and correcting errors are completed. My other point is about the team server. We're using the web portal, and the interface is not so good. The client was modified, and we have the new version. It's good. The client is good to us, but the web portal is using the old UI. It's not as modern, and it's limited. We found that the new version is slow when compared to the older version. We are trying to investigate what component is causing the slowness, because you have the client access, the repository, the API, the team server, and the web portal. Getting a single sign-on feature is very important to us.
What needs the most improvement are semantic lineage and usability.
The model diagram because very clumsy when you save it on the team server and the models are very big. It becomes difficult to enlarge and difficult to print. Although they say that it supports concurrent users, we have issues while branching, merging, and performing check-in or check-out. It's not as seamless as it should be. Now that we are all working from home and our repository is on the cloud servers, we are experiencing issues with performance. In general, support for big data should be improved.
The visual presentation is a little too colorful and seems that it is dumbed down. I would like to see support for creating macros in the way that erwin can. It did not reverse engineer all of the data types correctly, although it was pretty close. The only mistake was with some Oracle table objects, where it incorrectly determined them to be character references.
This solution needs more precise documentation.
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.
The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare). The screens are a bit outdated. They could use a new look and feel.
It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo. Also, Business Objects doesn't seem to be very stable at the moment, so we've stopped using that.
I've been an ERwin user for quite some time, almost 10 years. One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct. We can directly relate to different keys but here it is a little more complicated than ERwin.
When building the relationships there should be a little more flexibility.
The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting.
What I would like to see improved is the reliability of the releases, releases that are a little less buggy. Also, I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use, to find out where the problem that threw that error occurs. That would be a really cool feature.
Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade. For example, we are moving from 16 to 17. What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business. I already mentioned this to my account manager. He said they will put me with one of the product development teams to have this kind of discussion.