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."In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"The most valuable feature is its scalability."
"The feature that we find most useful is the ability to do analytics on the fly."
"I found the Amazon Redshift computing services easy. I found the computing instances the most incredible in the solution."
"The stability of Amazon Redshift is good."
"The valuable features are performance, data compression, and scalability."
"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."
"The solution integrates well with Power BI."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The product is easy to use."
"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."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It is a very stable tool...It is an extremely scalable tool."
"It is a stable and scalable solution."
"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."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"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 OLAP slide and dice features need to be improved."
"AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."
"The refreshment rate of data reaching Redshift from other sources should be faster."
"Query compilation time needs a lot of improvement for cases where you are generating queries dynamically."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"Ease of connectivity could be improved."
"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."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"The solution lacks visibility options."
"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."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Amazon Redshift is ranked 4th in Cloud Data Warehouse with 59 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 Snowflake, Teradata, AWS Lake Formation, 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.