We performed a comparison between Oracle Autonomous Data Warehouse and Oracle Exadata based on real PeerSpot user reviews.Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"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 integrates well with Power BI."
"A very good integration feature that restricts access to unauthorized people."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"The performance on the databases is good."
"The most valuable feature of Oracle Exadata is its capabilities for storing and processing data. It is very good for our domain."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The offloading of data to the SIM is a valuable feature."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"The solution lacks visibility options."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"The initial setup was pretty complex. It was not easy."
"The solution could always be more stable and more reliable."
"We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata."
"We used the support from Oracle Exadata to complete the implementation."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
"The solution lacks a visualized console."
"The integration with third-party applications regarding access management security could be better."
Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.
Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.
Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).
The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.
Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.
Oracle Exadata Database Machine Key Benefits
Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.
Reviews from Real Users
Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.
Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."
Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
Oracle Autonomous Data Warehouse is ranked 7th in Cloud Data Warehouse with 5 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 21 reviews. Oracle Autonomous Data Warehouse is rated 8.4, while Oracle Exadata is rated 8.4. The top reviewer of Oracle Autonomous Data Warehouse writes "Integrates well with other cloud services, provides great ROI and guarantees 99.995% up-time". On the other hand, the top reviewer of Oracle Exadata writes "Exadata can significantly improve performance but there's a learning curve in a few key areas". Oracle Autonomous Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, Amazon Redshift, BigQuery and Azure Data Factory, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Snowflake, Amazon Redshift and IBM Netezza Performance Server. See our Oracle Autonomous Data Warehouse vs. Oracle Exadata report.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.