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

IBM Db2 Warehouse on Cloud vs Oracle Database Appliance comparison

 

Comparison Buyer's Guide

Executive Summary

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

IBM Db2 Warehouse on Cloud
Average Rating
7.6
Reviews Sentiment
6.3
Number of Reviews
7
Ranking in other categories
Cloud Data Warehouse (16th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
Data Warehouse (6th)
 

Featured Reviews

FM
Enhancing analytics with seamless data dumping and reliable support
Our primary use case is data storage and analytics The organization has decided to purchase a full stack solution from IBM due to positive responses, which helped them upgrade from the previous version. The data dumping into the raw zone and the feature of BigQuery is quite attractive. There…
Charu Mazumdar - PeerSpot reviewer
Simplifies database management tasks and provides high availability and disaster recovery
Oracle Database Appliance has simplified our database management tasks. Our clients are using the solution for high availability and disaster recovery. Our overall experience with the solution was good, especially the DR. Oracle Database Appliance's integrated storage solutions have enhanced our data management. Oracle Database Appliance's integration with other solutions was straightforward. We faced compatibility issues while moving from another device to this one, and the integration was not seamless. I would recommend the solution to other users. Overall, I rate the solution an 8 out of 10.

Quotes from Members

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

Pros

"It will be MPP, so performance should improve."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"
"It is stable when there is support from IBM."
"The performance is okay as long as the volume of queries is not too high."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."
"The performance due to the all-flash of ODA is very nice."
"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"Easy management (it saves a lot of installation and patching time)."
 

Cons

"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"The license cost could be cheaper, especially for long-term contracts."
"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
 

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
"The solution's pricing is very high."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."
"The price of the solution should be less expensive. However, they will increase the price more."
"The product is costly."
"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."
"Oracle’s pricing is ridiculously high."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
30%
Computer Software Company
12%
Manufacturing Company
10%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What advice do you have for others considering IBM Db2 Warehouse on Cloud?
Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operatio...
What needs improvement with IBM Db2 Warehouse on Cloud?
There are some limitations in adding data files to table spaces, and improvements are needed for regional support.
What is your primary use case for IBM Db2 Warehouse on Cloud?
Our primary use case is data storage and analytics.
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
 

Also Known As

IBM dashDB
X5-2
 

Overview

 

Sample Customers

Copenhagen Business School, BPM Northwest, GameStop
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about IBM Db2 Warehouse on Cloud vs. Oracle Database Appliance and other solutions. Updated: April 2025.
846,617 professionals have used our research since 2012.