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 is quite simple to use and there are no issues with creating the tables."
"Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The most valuable feature is its scalability."
"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."
"The processing of data is very fast."
"The feature that we find most useful is the ability to do analytics on the fly."
"It's scalable because it's on the cloud."
"The most valuable feature is the time to solution."
"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."
"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."
"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."
"A very stable solution, which we have hardly any problems with."
"The tool performs well with a large database."
"It is the best solution for OLTP and data warehousing."
"Oracle has reliable solutions and this one is no different."
"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."
"In our experiments, the handling of unstructured data was not very smooth."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"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."
"The product must provide new indexes that support special data structures or data types like TEXT."
"Infinite storage is available in Snowflake and is not available in Redshift."
"This solution lacks integration with non-AWS sources."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"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."
"Sometimes it takes too long time to get help with technical issues."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"Checking the Smart Scan issues is complicated."
"Patching must be simplified."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 125 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 Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and Azure Data Factory, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and VMware Tanzu Data Services. 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.