We performed a comparison between CA Datacom and Toad for Oracle 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."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."
"The initial setup is fairly straightforward for a mainframe product."
"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."
"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."
"Toad for Oracle has proven to be better than other tools since we have never experienced any crashes."
"Simply the best GUI software for administration is the most valuable aspect for me."
"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."
"A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++."
"The schema browser is the most valuable feature. The way it presents the objects in our database."
"I like that it's very flexible and helpful in query accuracy, analysis, and data visualization. I also like the move facilities available in Toad for Oracle. Overall, I think it's a fantastic product for analyzing SQL queries and managing all kinds of queries."
"The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development."
"I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time."
"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."
"There could be a tool for automated SQL query functioning."
"Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."
"There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases."
"Toad for Oracle does not have a particular resolution within the application."
"In future releases, the product can be more intuitive. It has to be lighter than what it is because sometimes it is not responding quickly. If I do some features at the same time, it's not supporting. I have to wait sometimes to get the action. It's dependent on the resources of the workstation, but it has to be improved in this area. The faster processing is needed."
"I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it."
"The way the dialog boxes appear can be improved."
"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."
Earn 20 points
CA Datacom is ranked 33rd in Database Development and Management while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. CA Datacom is rated 9.0, while Toad for Oracle is rated 8.8. 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 Toad for Oracle writes "Advanced query optimization and tuning features ". CA Datacom is most compared with CA IDMS, whereas Toad for Oracle is most compared with Toad Edge, Aqua Data Studio, Oracle Enterprise Manager, DbVisualizer and Redgate SQL Toolbelt. See our CA Datacom vs. Toad for Oracle 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.