We compared Amazon Redshift and Oracle Exadata based on our users’ reviews in four categories. After reading the collected data, you can find our conclusion below.
Comparison of Results: Based on the parameters we compared, Amazon Redshift seems to be the superior solution. Our reviewers feel that Oracle Exadata’s complexity of deployment and its expensive price tag make Amazon Redshift the better investment.
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"It allows for the storage of huge amounts of data."
"It allows you write complex queries and perform row by row processes."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"We have found Machine Learning use cases are very nice."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"Redshift allows you to transform different data formats and consolidate them into one Redshift cluster. This means you can transform various siloed data sources like Excel files and CSV files into Redshift."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"We can use virtualization on Exadata."
"The offloading of data to the SIM is a valuable feature."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"The performance on the databases is good."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"This solution lacks integration with non-AWS sources."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Should be made available across zones, like other Multi-AZ solutions."
"There are too many limitations with respect to concurrency."
"Amazon Redshift could improve the user interface support."
"The setup is a little bit complex. We would like to see the installation part get easier."
"Sometimes it takes too long time to get help with technical issues."
"Exadata would be improved with single dashboard visibility."
"The cost of the solution is high and can be improved."
"Since the product is an appliance, it is very costly."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"The handling of temp space has room for improvement."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews. Amazon Redshift is rated 7.8, while Oracle Exadata is rated 8.4. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". On the other hand, the top reviewer of Oracle Exadata writes "Offers a variety of valuable features". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and Azure Data Factory, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and VMware Tanzu Greenplum. See our Amazon Redshift vs. Oracle Exadata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.