We performed a comparison between Amazon Redshift and Oracle Autonomous Data Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's scalable because it's on the cloud."
"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."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"For the on-premises version of Amazon Redshift, we need to start from scratch. However, with the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features."
"We have found Machine Learning use cases are very nice."
"The product offers good support for the data lake."
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have."
"The solution has very competitive pricing."
"It is a stable and scalable solution."
"The analytics have been very good. We've found them to be quite useful."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"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."
"The product is easy to use."
"The solution integrates well with Power BI."
"It is a very stable tool...It is an extremely scalable tool."
"In the solution, user-based access is quite hard. In general, certain permissions are difficult to manage."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"The explain panel in the Redshift database could be better."
"I would like to improve the pricing and the simplicity of using this solution."
"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."
"Improvement could be made in the area of streaming data."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"Running parallel queries results in poor performance and this needs to be improved."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"They should make the solution more user-friendly."
"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 initial setup was pretty complex. It was not easy."
"The installation process is complex. Oracle can make the installation process better."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"A lot of the tools that were previously there have now been taken away."
"Ease of connectivity could be improved."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Amazon Redshift is rated 7.8, while Oracle Autonomous Data Warehouse is rated 8.6. 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 Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Teradata, Vertica and VMware Tanzu Greenplum, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Teradata. See our Amazon Redshift vs. Oracle Autonomous Data Warehouse report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.