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

Oracle Autonomous Data Warehouse 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

Oracle Autonomous Data Ware...
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
Cloud Data Warehouse (12th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.6
Number of Reviews
45
Ranking in other categories
Data Warehouse (5th)
 

Featured Reviews

Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…
Rubens Oliveira - PeerSpot reviewer
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

"A very good integration feature that restricts access to unauthorized people."
"Self-patching and runs machine-learning across its logs all the time"
"The product has self-repair features."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The performance and scalability are awesome."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The solution is used for analytics and it works for our data security needs."
"It is a very stable tool...It is an extremely scalable tool."
"The most valuable feature is the performance."
"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The most valuable feature is the ease of dashboarding and ease of reporting."
"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 initial setup was straightforward and quick - I was able to configure everything within an hour."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The product is excellent. It is simple and reliable in terms of installation and maintenance."
 

Cons

"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"The solution lacks visibility options."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"A lot of the tools that were previously there have now been taken away."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"The setup is complex."
"Ease of connectivity could be improved."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"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."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"The tool's setup can be easier."
"The solution's initial setup is not easy."
"Oracle Database Appliance could improve by having better integration."
"Oracle's product support is an area of concern where improvements are required."
 

Pricing and Cost Advice

"ROI is high."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"The solution is expensive."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The price depends on the configuration we choose."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
"The solution's cost is reasonable."
"The product is costly."
"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."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"Get benefit from the capacity-on-demand features. License your cores according to your licenses."
"The solution's pricing is very high."
"You must pay for the license."
"Oracle Database Application's support and maintenance are included in the contract."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
869,566 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
10%
Manufacturing Company
8%
University
7%
Insurance Company
7%
Financial Services Firm
24%
Computer Software Company
10%
Government
8%
Manufacturing Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business6
Midsize Enterprise1
Large Enterprise11
By reviewers
Company SizeCount
Small Business20
Midsize Enterprise9
Large Enterprise15
 

Questions from the Community

What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
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?
For the cloud version, there could be better storage options or more storage for lower prices. However, for on-premises, this is not possible because you have physical disks. In the cloud, more opt...
 

Also Known As

No data available
X5-2
 

Overview

 

Sample Customers

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: September 2025.
869,566 professionals have used our research since 2012.