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 (15th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.5
Number of Reviews
46
Ranking in other categories
Data Warehouse (9th)
 

Featured Reviews

FM
Database Engineer at Meezan Bank
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…
Rubens Oliveira - PeerSpot reviewer
Data & Solution Archtect at Enkel
Automated provisioning simplifies deployment and integration
The Oracle Database Appliance is customizable and has excellent features.I don't have any problems with Oracle Database Appliance because this product is very automated, with scheduler and automatic processes throughout. You can make small inferences and changes for creating all the specific modifications. The automated provisioning feature helps speed up the database deployment process because you can use one command or option to resize all the disks or increase memory, depending on the occasion. The Oracle Database Appliance has integration in OCI Cloud. The same services simplify all the manager work regarding backups, configuration, resizing disks, and other services. Deploying the Oracle Database Appliance both on-premises and in the cloud offers the same simplification. You simply input your database name and specify memory quantity, CPU quantity, and database size. The process is identical for both on-premises and cloud deployments. The flexibility of Oracle Database Appliance has helped grow business needs for many customers. Using the Oracle Database Appliance has positively impacted my organization because I can deliver it much more comfortably. Creating a database involves many processes, but with this solution, you just input the name and configure the network and other parameters. It is very similar to RDS in AWS services, where you specify the name, choose the engine, indicate parameter groups, VPC, subnet groups, and proceed. Both Oracle Database Appliance and RDS have greatly simplified the work.

Quotes from Members

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

Pros

"One of the most amazing features of dashDB is how it uses compression to get results in lighting speed."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"
"The performance is okay as long as the volume of queries is not too high."
"DashDB is a good product to work with and the extra cost you spend on performance, technical support and tools to work with is worth it."
"Since my company is an IBM partner, it has enabled us to offer cloud data warehouse solutions on a 100% IBM stack."
"I like that the dashDB solution is built on DB2 technology, which means that you can use all the features of a DB2 database while outsourcing all the hardware and software maintenance."
"The performance is okay as long as the volume of queries is not too high."
"It is stable when there is support from IBM."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"It has many valuable features, including High Availability and failover, which means you can have an all-ERP solution in one box, so you can use your database with your application server together."
"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The performance due to the all-flash of ODA is very nice."
"The solution is simple to use and easy to maintain."
"Scalability, high availability, easy installation, and good performance are the reasons to switch."
"The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."
 

Cons

"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"I would rate the level of dashDB support 3.5/5. While they are very knowledgeable in many areas, you can still struggle to get the correct resolution."
"Db2 is not a solution that I recommend. We have a lot of experience and we are not satisfied with the product or the support that we received."
"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."
"The support channels need to improve."
"I would like to see improvements in backup and authentication. It needs the ability to increase the number of retained backups to more than 2 days."
"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."
"With dashDB, scalability and uptime need more improvement."
"The solution's initial setup is not easy."
"Creating a VM on ODA could be improved."
"Oracle Database Appliance has not impacted my organization positively."
"There is room for improvement in better integration with third-party tools, such as Power BI or Redshift."
"The biggest disadvantage of this server is its availability when you patch the whole machine, i.e. when you patch the entire ODA firmware, not the databases within it."
"It had a lot of bugs, especially with the old patch bundles."
"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."
 

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
"The product is costly."
"The price of the solution should be less expensive. However, they will increase the price more."
"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"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."
"Get benefit from the capacity-on-demand features. License your cores according to your licenses."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
884,933 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
18%
Computer Software Company
8%
Government
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
By reviewers
Company SizeCount
Small Business21
Midsize Enterprise9
Large Enterprise15
 

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 needs improvement with Oracle Database Appliance?
Currently, Oracle Database Appliance is good with no room for improvement.In future updates of Oracle Database Appliance, I would like to see AI implemented since AI is getting more attention.
 

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: March 2026.
884,933 professionals have used our research since 2012.