We performed a comparison between CA Database Management for DB2 for zOS and IDERA ER/Studio based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It helps us to reduce hardware costs and to optimize processing times."
"Improved monitoring and performance 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."
"Straightforward setup."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"We are able to document the data lineage and data flows of our data from one system to another."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"We use the solution to create data models which describe our company's data architecture"
"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 data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"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."
"All the information we need, we could use to have it in a more usable format."
"Minor stability issues."
"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."
"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."
"When building the relationships there should be a little more flexibility."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"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 would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"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. It works fine. 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."
"We would always like to see Repository performance improve, checking in and checking out."
"What needs the most improvement are semantic lineage and usability."
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 , whereas IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest. See our CA Database Management for DB2 for zOS vs. IDERA ER/Studio report.
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.