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

Amazon Redshift vs Oracle Autonomous Data Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Amazon Redshift
Ranking in Cloud Data Warehouse
4th
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
66
Ranking in other categories
No ranking in other categories
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
9th
Average Rating
8.6
Reviews Sentiment
7.5
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Cloud Data Warehouse category, the mindshare of Amazon Redshift is 7.7%, down from 11.9% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 6.1%, up from 4.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

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.
Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…

Quotes from Members

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

Pros

"The processing of data is very fast."
"Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there."
"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 stability of Amazon Redshift is good."
"The solution's flexibility is its most valuable feature. It's also easy to scale and has relatively painless pricing."
"It allows for the storage of huge amounts of data."
"We have found Machine Learning use cases are very nice."
"The most valuable features are that it's easy to set up and easy to connect the many tools that connect to it."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The product has self-repair features."
"The solution integrates well with Power BI."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"A very good integration feature that restricts access to unauthorized people."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The analytics have been very good. We've found them to be quite useful."
 

Cons

"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"What would make Amazon Redshift better is improvising on the pricing structure. For example, Acronis provides backups in cybersecurity, yet the pricing is a bit lesser than Amazon Redshift."
"The OLAP slide and dice features need to be improved."
"Infinite storage is available in Snowflake and is not available in Redshift."
"The product could be improved by making it more flexible."
"Amazon Redshift is a little more expensive than other products."
"Running parallel queries results in poor performance and this needs to be improved."
"The customer support could be more responsive."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"The setup is complex."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"The solution lacks visibility options."
"They should make the solution more user-friendly."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
 

Pricing and Cost Advice

"I have heard complaints about the solution’s pricing, and thus I rate it as a five."
"Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
"If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
"The solution is available at a mid-range price compared to other vendors."
"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."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"The solution is expensive."
"ROI is high."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"The cost is perfect with Oracle Universal credit."
"You pay as you go, and you don't pay for services that you don't use."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
60%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
Educational Organization
49%
Financial Services Firm
7%
Computer Software Company
7%
Manufacturing Company
4%
 

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 is your experience regarding pricing and costs for Amazon Redshift?
You can start small with a basic cluster to learn and practice with it. Selecting the most basic and economical cluster type can save you enough money to move forward with the solution or go with a...
What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
 

Overview

 

Sample Customers

Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about Amazon Redshift vs. Oracle Autonomous Data Warehouse and other solutions. Updated: October 2024.
816,406 professionals have used our research since 2012.