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.
"Easy to build out our snowflake design and load data."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"The valuable features are performance, data compression, and scalability."
"It's very easy to migrate from other databases to Redshift. There are migration tools dedicated for this purpose, enabling migration from other databases like MS SQL directly to Redshift. The majority of the scripts will be automatically transposed."
"The product is relatively easy to use because there is no indexing and no partitions."
"The solution is scalable. It handles different loads very well."
"The solution has very competitive pricing."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"They just have a lot of products, and they work well together."
"The offloading of data to the SIM is a valuable feature."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"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."
"This product can noticeably enhance performance of contextual Oracle databases."
"The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"The data replication is very good."
"Complete management occurs from one single address instead of different servers."
"In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic."
"We recently moved from the DC2 cluster to the RA3 cluster, which is a different node type and we are finding some issues with the RA3 cluster regarding connection and processing. There is room for improvement in this area. We are in talks with AWS regarding the connection issues."
"The OLAP slide and dice features need to be improved."
"The product could be improved by making it more flexible."
"It lacks a few features which can be very useful, such as stored procedures"
"The solution is unable to work fast."
"It would be good to see Redshift as a serverless offering."
"The explain panel in the Redshift database could be better."
"The handling of temp space has room for improvement."
"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."
"The solution's pricing is very high."
"The initial setup process is very difficult and extremely complex."
"We had issues with system restoration."
"There's room for improvement in terms of deployment, as it could be made faster and more user-friendly."
"Since the product is an appliance, it is very costly."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
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.