Try our new research platform with insights from 80,000+ expert users

Amazon Redshift 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

Amazon Redshift
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
67
Ranking in other categories
Cloud Data Warehouse (5th)
Oracle Database Appliance
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
43
Ranking in other categories
Data Warehouse (6th)
 

Featured Reviews

Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
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 often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.
Charu Mazumdar - PeerSpot reviewer
Simplifies database management tasks and provides high availability and disaster recovery
Oracle Database Appliance has simplified our database management tasks. Our clients are using the solution for high availability and disaster recovery. Our overall experience with the solution was good, especially the DR. Oracle Database Appliance's integrated storage solutions have enhanced our data management. Oracle Database Appliance's integration with other solutions was straightforward. We faced compatibility issues while moving from another device to this one, and the integration was not seamless. I would recommend the solution to other users. Overall, I rate the solution an 8 out of 10.

Quotes from Members

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

Pros

"This service can merge and integrate well with all databases."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"It is very easy to dump data into the tool."
"With the APIs that are available, it can be easily integrated with other tools."
"The most valuable feature is its scalability."
"The product offers good support for the data lake."
"The processing of data is very fast."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The most valuable feature is the performance."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
"The solution is simple to use and easy to maintain."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."
"The product is excellent. It is simple and reliable in terms of installation and maintenance."
"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."
 

Cons

"I would like to improve the pricing and the simplicity of using this solution."
"The OLAP slide and dice features need to be improved."
"When working with third-party services requires additional integrations and configurations, which can sometimes add more cost."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"The speed of the solution and its portability needs improvement."
"It is difficult to work with unstructured data and JSON documents."
"There might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"The license cost could be cheaper, especially for long-term contracts."
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."
"They could incorporate a more secure and internet-centric management system for the platform."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"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."
"You can only scale storage, not developer nodes."
 

Pricing and Cost Advice

"Pricing for Amazon Redshift is reasonable, though it could be somewhat higher than other solutions, such as Azure. Still, when you base your comparison on the services offered and the pricing, it's the most reasonable versus its competitors, such as RDS."
"For Amazon Redshift, we pay around INR 60,000 annually. The cost factor also depends on the number of existing customers."
"The cost will depend on how you set up your warehouse and what kind of data you store."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"It's pay per use. You can have multiple models."
"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"At the moment, pricing is a little bit on the higher side, although it depends on the size of the company."
"BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."
"The solution's pricing is very high."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"Oracle’s pricing is ridiculously high."
"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"The price of the solution should be less expensive. However, they will increase the price more."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"The product is costly."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
63%
Financial Services Firm
7%
Computer Software Company
5%
Manufacturing Company
3%
Financial Services Firm
29%
Computer Software Company
12%
Manufacturing Company
8%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
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?
I have heard from colleagues that Oracle is very costly compared to open databases like PostgreSQL. I cannot personally comment on it.
What needs improvement with Oracle Database Appliance?
The scalability part is missing. It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization. The Oracle cloud hasn't reached the level of offe...
 

Also Known As

No data available
X5-2
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about Amazon Redshift vs. Oracle Database Appliance and other solutions. Updated: January 2025.
831,265 professionals have used our research since 2012.