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
5th
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 May 2025, in the Database Development and Management category, the mindshare of CA IDMS is 1.1%, up from 0.8% compared to the previous year. The mindshare of Toad for Oracle is 5.5%, up from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

it_user558606 - PeerSpot reviewer
We get network database performance. It supports our back office.
I don't have anything to add. I've heard about web services. We might be looking at a Java connection or web services in the future. It's serving our purpose right now. We're not looking for anything new. For what we do, it meets all our needs. We have to use DB2 when we need more relational constructs, expanded inquiry and reporting; so it's not perfect in that regards. We use it really for our transaction processing, not as much for reporting. For transaction processing, it's doing the job we need. To go into more in-depth, high-volume reporting, we offload a lot of the data to DB2.
Joseph Jolly - PeerSpot reviewer
Highly stable solution and efficiently pinpoints specific areas with issues, which has saved us time troubleshooting.
I think one area is being able to use shortcuts, for example, being able to press F5 to run a query or having the ability to seamlessly copy and paste. 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. In additional features, I would like maybe one for the integration with the ticketing system. For example, if a ticket is raised to resolve an issue, there should be something that I can click on to update the ticket when I'm done.

Quotes from Members

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

Pros

"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. ​"
"Technical support is very good. They are very knowledgeable, very quick to respond, and very nice people, too.​"
"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."
"Simply the best GUI software for administration is the most valuable aspect for me."
"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."
"Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries."
"I haven't seen any issues with scalability. We have about 1000 people on our IT team who use the solution."
"It is very easy to manage all of the objects."
"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."
 

Cons

"​I would like to see it made simpler to operate and maintain."
"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."
"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."
"Toad for Oracle could improve code completion, it is very slow."
"I would like to see an improvement in the performance because opening the browser and the editor should be faster."
"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."
"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."
"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."
"Query optimization is still very resource-intensive."
"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."
 

Pricing and Cost Advice

"Do not hold back on asking questions about the maintenance and continued support of the product."
"In my opinion, this solution is a little expensive, but I understand that good programs cost more money."
"The pricing is okay, it's reasonable."
"I would rate it six, where one is a low price, and ten is a high price."
"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."
"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."
"Toad for Oracle has a relatively high cost compared to other similar tools."
"The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
851,491 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Government
14%
Computer Software Company
10%
University
7%
Financial Services Firm
19%
Computer Software Company
11%
Government
11%
University
6%
 

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: April 2025.
851,491 professionals have used our research since 2012.