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 (10th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
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…
Ahmed-Yehia - PeerSpot reviewer
Enhanced performance and simplified operations with integrated features
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP databases. You can only scale storage, not developer nodes. It's priced a little higher, which could be optimized for small or medium businesses.

Quotes from Members

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

Pros

"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It is a very stable tool...It is an extremely scalable tool."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The product has self-repair features."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The performance and scalability are awesome."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"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."
"Oracle is a stable database."
"Oracle has good technical support."
"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."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The most valuable feature is the ease of dashboarding and ease of reporting."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"The product is good value for money. It is a secure solution."
 

Cons

"The initial setup was pretty complex. It was not easy."
"The setup is complex."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"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."
"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."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"They should make the solution more user-friendly."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"The tool's setup can be easier."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"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."
"The solution’s flexibility could be improved."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
 

Pricing and Cost Advice

"You pay as you go, and you don't pay for services that you don't use."
"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."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The solution is expensive."
"The cost is perfect with Oracle Universal credit."
"Oracle Database Application's support and maintenance are included in the contract."
"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."
"You must pay for the license."
"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"The product is costly."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
"The price should be lower."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,129 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
26%
Financial Services Firm
11%
Computer Software Company
8%
Manufacturing Company
5%
Financial Services Firm
27%
Computer Software Company
12%
Manufacturing Company
9%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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?
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

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: June 2025.
859,129 professionals have used our research since 2012.