Try our new research platform with insights from 80,000+ expert users

CA IDMS vs Toad for Oracle comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

CA IDMS
Ranking in Database Development and Management
29th
Average Rating
9.0
Reviews Sentiment
7.8
Number of Reviews
5
Ranking in other categories
No ranking in other categories
Toad for Oracle
Ranking in Database Development and Management
7th
Average Rating
9.0
Reviews Sentiment
7.4
Number of Reviews
16
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of August 2025, in the Database Development and Management category, the mindshare of CA IDMS is 1.3%, up from 0.6% compared to the previous year. The mindshare of Toad for Oracle is 4.3%, down from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

AS
Helps us to manage user profiles very quickly and in an assertive way
I would rate this solution 9 out of 10. I would advise that they should evaluate other possibilities because this is a very quickly changing environment and there are other possible providers that have good solutions. I would do some kind of test. I would test other possible solutions too and compare them.
Bikramjeet Singh - PeerSpot reviewer
Advanced query optimization and tuning features
Sometimes when I write a query, it gives an unusual error code. Toad for Oracle does not have a particular resolution within the application. Then, I have to search for the code and find a solution. I would like Oracle to implement error codes so that we don't have to search for solutions on Google. It would be more convenient if the error codes were included within the application.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Technical support is very good. They are very knowledgeable, very quick to respond, and very nice people, too.​"
"The most useful feature is the governance feature, because it can show us and help us to manage user profiles very quickly and using it in assertive way."
"It is a really stable platform. It has been around for many years. We trust it implicitly. ​"
"Toad has a lot of features that are very useful, fast, and well developed."
"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 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."
"The most valuable feature of Toad for Oracle is the fashion browser and the Schema browser. It is very complete."
"One of the most valuable features of Toad for Oracle is its ability to manage sessions by killing those that are hung or blocking other sessions."
"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."
"The product's most valuable features are UI and monitoring."
"Simply the best GUI software for administration is the most valuable aspect for me."
 

Cons

"Right now, it's not easy to start using this solution. You have to take long course and train people. It's not an easy path."
"​I would like to see it made simpler to operate and maintain."
"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."
"Sometimes it works in some areas, but in others, it doesn't. Like when you copy, you find that it's blank and doesn't copy anything. So, there are some objects that do copy, and sometimes they don't."
"Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions."
"Toad for Oracle does not have a particular resolution within the application."
"Toad for Oracle could improve code completion, it is very slow."
"It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue."
"It would be beneficial if Toad for Oracle could incorporate OEM features, as having monitoring capabilities in the same interface would simplify workload and management tasks."
"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."
 

Pricing and Cost Advice

"Do not hold back on asking questions about the maintenance and continued support of the product."
"Toad for Oracle has a relatively high cost compared to other similar tools."
"I would rate it six, where one is a low price, and ten is a high price."
"The pricing is okay, it's reasonable."
"There are paid and free-for-use versions of the product."
"My advice is to try to use the three-year maintenance agreement if possible."
"In my opinion, this solution is a little expensive, but I understand that good programs cost more money."
"The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."
"The product's pricing is just right because if it were slightly higher, it would not have been as widely adopted as it currently is in our organization."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Government
12%
Manufacturing Company
10%
University
7%
Financial Services Firm
19%
Computer Software Company
13%
Government
11%
Performing Arts
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Ask a question
Earn 20 points
What do you like most about Toad for Oracle?
The product's most valuable features are UI and monitoring.
What is your experience regarding pricing and costs for Toad for Oracle?
The licensing cost for Toad for Oracle is relatively high, with their license and DPA suite totaling around five thousand dollars.
What needs improvement with Toad for Oracle?
It would be beneficial if Toad for Oracle could incorporate OEM features, as having monitoring capabilities in the same interface would simplify workload and management tasks.
 

Also Known As

IDMS
No data available
 

Overview

 

Sample Customers

Blue Hill Data Services Inc.
intel, ebay, uber, mars, microsoft
Find out what your peers are saying about CA IDMS vs. Toad for Oracle and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.