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."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."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"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."
"It is quite simple to use and there are no issues with creating the tables."
"The most valuable feature of Redshift is its cluster."
"Easy to build out our snowflake design and load data."
"It allows for the storage of huge amounts of data."
"The main benefit is that our portal for end users is running in AWS, so we can easily connect it to other AWS services."
"A very good integration feature that restricts access to unauthorized people."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The solution integrates well with Power BI."
"The analytics have been very good. We've found them to be quite useful."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"It is a stable and scalable solution."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"They should provide a better way to work with interim data in a structured way than to store it in parquet files locally."
"It would be good to see Redshift as a serverless offering."
"If you require a highly scalable solution, I would not recommend Amazon Redshift."
"Amazon Redshift is a little more expensive than other products."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"Should be made available across zones, like other Multi-AZ solutions."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"The product could be improved by making it more flexible."
"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."
"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."
"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."
"Ease of connectivity could be improved."
"The solution lacks visibility options."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 61 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 Teradata, Vertica, Snowflake, Microsoft Azure Synapse Analytics and VMware Tanzu Data Services, whereas Oracle Autonomous Data Warehouse is most compared with Snowflake, Oracle Exadata, 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.