IDERA ER/Studio Room for Improvement

AndersonMoura - PeerSpot reviewer
Data Management Product Owner at ExxonMobil

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
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
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
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
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
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
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 »
it_user92238 - PeerSpot reviewer
Director at a tech services company with 51-200 employees
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
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
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 »
it_user324030 - PeerSpot reviewer
Sr. Data Engineer at a computer software company with 501-1,000 employees

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
View full review »
it_user282783 - PeerSpot reviewer
Database Architect at a healthcare company with 1,001-5,000 employees

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
Data Architect at a financial services firm with 501-1,000 employees

What needs the most improvement are semantic lineage and usability.

View full review »
it_user297114 - PeerSpot reviewer
Principal Data Architect at a tech company with 201-500 employees

Product registration always seemed difficult and time consuming.

View full review »
DN
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 »
it_user277026 - PeerSpot reviewer
Senior Consultant with 501-1,000 employees

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
VP Product Strategy, Analytics at a financial services firm with 1,001-5,000 employees

This solution needs more precise documentation.

View full review »
it_user323850 - PeerSpot reviewer
ProQuest Development and Quality Assurance Support at a tech services company with 10,001+ employees

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
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 »
it_user323538 - PeerSpot reviewer
Associate Director, Enterprise Data Management, Practice Lead for Life Sciences UK&I at a tech services company with 1,001-5,000 employees
  • 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
View full review »
it_user277956 - PeerSpot reviewer
Senior SQL Server Developer at a tech vendor with 201-500 employees

This version does not properly generate SQL Server computed columns; future versions do this.

View full review »
it_user341061 - PeerSpot reviewer
Business Intelligence Analyst DBA at a government with 1,001-5,000 employees

It did everything that I needed, and I didn't think about enhancements while using the product.

View full review »
it_user91548 - PeerSpot reviewer
Infrastructure Expert at a tech services company with 1,001-5,000 employees
  • Easier licensing
  • It would be nice if we could use more modern standard dialogs, such as file selection
View full review »
it_user275646 - PeerSpot reviewer
Senior Consultant with 51-200 employees
  • Repository causes continuous problems, as it's slow and sometimes crashes.
  • Integration with Active Directory does not function perfectly.
View full review »
JC
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
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 »
it_user285069 - PeerSpot reviewer
Data Management Specialist at a government with 1,001-5,000 employees
  • Diagram Versioning is not very intuitive
  • Data Dictionary Bindings is not very intuitive
View full review »
it_user738693 - PeerSpot reviewer
Administrador de Dados at a non-tech company with 5,001-10,000 employees

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.