We performed a comparison between CA Datacom 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."Scalability is definitely one thing. The size of the database can grow without any issues. We've got one database table that's got over a billion rows in it; quite a bit of data, and it handles access like a champ."
"The initial setup is fairly straightforward for a mainframe product."
"Nowadays, CA is doing a lot of improving as far as online maintainability of definitions, which is a huge improvement over the past. I'm able to do a lot of changes without any outage."
"It definitely cuts down on our support costs. I do not get woken up in the middle of the night very often for a problem with Datacom."
"It is a solid product."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"Straightforward setup."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"The reverse engineering is the most important feature."
"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."
"It does the job."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"For the "no-outage maintainability" of things, they are making improvements as we speak, but there is definitely still room for more of that."
"The only minor issue that we have had with Datacom is in the installation guide: Some of the sizings for the databases have not really worked out for us, so we had to go in and resize them."
"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."
"This solution needs more precise documentation."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"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."
"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."
Earn 20 points
CA Datacom is ranked 33rd in Database Development and Management while IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews. CA Datacom is rated 9.0, while IDERA ER/Studio is rated 8.4. The top reviewer of CA Datacom writes "It is like a black box type of product. We just set it up and it runs". 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 Datacom is most compared with CA IDMS and CA Database Management for DB2 for zOS, 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.