IDERA ER/Studio Room for Improvement
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.
View full review »MG
Mike Grove
DBA at a consumer goods company with 201-500 employees
The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting.
View full review »RK
DataArchd5df
Asst. Director, Data Management & Analytics at a healthcare company with 10,001+ employees
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.
View full review »Buyer's Guide
Enterprise Architecture Management
March 2024
Find out what your peers are saying about IDERA, erwin by Quest , SAP and others in Enterprise Architecture Management. Updated: March 2024.
765,234 professionals have used our research since 2012.
SV
reviewer1429329
Sr Data Integration Modeler at a insurance company with 1,001-5,000 employees
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.
View full review »CL
VpDataInd01c
Database Designer at a manufacturing company with 1,001-5,000 employees
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.
View full review »PS
DataArchadd7
Data Architect at a computer software company with 1,001-5,000 employees
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.
View full review »LW
Larry Wilson
Data Architect at a insurance company with 1,001-5,000 employees
I would like to see better documentation/help for the Data Architect tool.
Creation of tutorials would be nice. There are some features which are not as clearly defined as they should be.
View full review »
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.
View full review »
FD
reviewer1318779
Data Architect at a pharma/biotech company with 1,001-5,000 employees
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.
View full review »MS
Mariya Salamatova
Senior Business Intelligence Developer at a construction company with 501-1,000 employees
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.
View full review »Things that come to mind that I’ve not been able to do in prior projects include:
- Support for SQL Server filtered indexes, both a means to effectively represent this in a data model and have it produce the filtered index in the rendered DDL
- Support for some of the open source RDBMS for reverse engineering and migration
Although the tool allows for many different options as far as the what can be displayed on the model, it would be nice if they allowed for entity objects (attributes, indexes, keys, etc.) as well as the textual definition of the object. The current design only allows one or the other. I like to have a little verbiage on each entity included in the model that describes it purpose, this is allowed in the tool but you can't show both the entity structure and the text at the same time without creating a separate text object and placing the text in it.
View full review »DF
reviewer1477701
Data Architect at a financial services firm with 501-1,000 employees
What needs the most improvement are semantic lineage and usability.
Product registration always seemed difficult and time consuming.
View full review »DN
David Nemec
Oracle developer at OKsystem a.s.
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
View full review »The print facility is a little lacking. It can be trying at times to get that perfect ERD printed on a plotter.
View full review »SM
Reviewer787
VP Product Strategy, Analytics at a financial services firm with 1,001-5,000 employees
This solution needs more precise documentation.
View full review »I don't have any specific ideas about how to improve the product. I always have the upgrades and every upgrade comes with some improvements and it's good.
View full review »JM
Reviewer951561
Database Administrator at a government with 10,001+ employees
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.
View full review »- Reusability of objects across multiple workspaces is a feature that would help in building a single enterprise model using linked up workspaces
- Copy/Paste of diagrams to create copies between workspaces would be a handy feature to have
This version does not properly generate SQL Server computed columns; future versions do this.
View full review »It did everything that I needed, and I didn't think about enhancements while using the product.
View full review »- Easier licensing
- It would be nice if we could use more modern standard dialogs, such as file selection
- Repository causes continuous problems, as it's slow and sometimes crashes.
- Integration with Active Directory does not function perfectly.
JC
Database9ac8
Database Administrator at a healthcare company with 1,001-5,000 employees
When building the relationships there should be a little more flexibility.
View full review »MP
DBA8d65
DBA at a consultancy with 501-1,000 employees
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.
View full review »- Diagram Versioning is not very intuitive
- Data Dictionary Bindings is not very intuitive
The product is pricey.
View full review »Buyer's Guide
Enterprise Architecture Management
March 2024
Find out what your peers are saying about IDERA, erwin by Quest , SAP and others in Enterprise Architecture Management. Updated: March 2024.
765,234 professionals have used our research since 2012.