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 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."
"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."
"Redshift Spectrum is the most valuable feature."
"The most valuable feature is the scalability, as it grows according to our needs."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"I find the most valuable features to be the MPP style of processing, which mostly all of the data warehouses provide. The ability to integrate all other AWS services, such as NSS and S3, with little effort is very helpful. The service is well maintained, there are update patches frequently."
"The most valuable feature of Amazon Redshift is its ability to handle really large sets of data."
"Redshift is a major service of Amazon and is very scalable. It enables faster recalculations and data management, helping to retrieve data quickly."
"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."
"It is a very stable tool...It is an extremely scalable tool."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"Self-patching and runs machine-learning across its logs all the time"
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"It is a stable and scalable solution."
"It would be good to see Redshift as a serverless offering."
"The customer support could be more responsive."
"The explain panel in the Redshift database could be better."
"For people who struggle with IAM or role-based management, the setup isn't easy."
"Sometimes, it's difficult to get the metadata from Redshift."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"It lacks a few features which can be very useful, such as stored procedures"
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch."
"The installation process is complex. Oracle can make the installation process better."
"A lot of the tools that were previously there have now been taken away."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Ease of connectivity could be improved."
"They should make the solution more user-friendly."
"I would like to see an on-premise solution in the future."
"The solution lacks visibility options."
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.