We performed a comparison between CA Database Management for DB2 for zOS and IDERA ER/Studio based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management."It is very stable. We have had no issues."
"It takes advantage of new features of DB2."
"The most important features are batch reporting and the ability to create repositories, enabling automated analysis. These are valuable because they enable me to do automated analysis of trends over time and reduce the time for comparing performance between two periods to identify anomalies."
"Improved monitoring and performance management."
"It helps us to reduce hardware costs and to optimize processing times."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"The tool is simple to use."
"Straightforward setup."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"Minor stability issues."
"All the information we need, we could use to have it in a more usable format."
"They need to provide a way to create and maintain performance repositories. The online tool is not perfect, but it is giving me what I need."
"The only thing I had an issue with was licensing, and the support was very good."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"We would always like to see Repository performance improve, checking in and checking out."
"What needs the most improvement are semantic lineage and usability."
"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."
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"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."
Earn 20 points
CA Database Management for DB2 for zOS is ranked 30th in Database Development and Management while IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews. CA Database Management for DB2 for zOS is rated 8.8, while IDERA ER/Studio is rated 8.4. The top reviewer of CA Database Management for DB2 for zOS writes "The most useful feature is the ability to create strategies across the products". On the other hand, the top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". CA Database Management for DB2 for zOS is most compared with CA IDMS and CA Datacom, whereas IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, Toad Data Modeler and erwin Evolve by Quest.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.