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."The initial setup is easy."
"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'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 allows for the storage of huge amounts of data."
"The initial setup of this solution is straightforward."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"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 valuable features are performance, data compression, and scalability."
"The analytics have been very good. We've found them to be quite useful."
"A very good integration feature that restricts access to unauthorized people."
"It is a very stable tool...It is an extremely scalable tool."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The product is easy to use."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"Self-patching and runs machine-learning across its logs all the time"
"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."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"Running parallel queries results in poor performance and this needs to be improved."
"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."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"This solution lacks integration with non-AWS sources."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"The customer support could be more responsive."
"They should make the solution more user-friendly."
"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."
"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."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"The solution lacks visibility options."
"The installation process is complex. Oracle can make the installation process better."
"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."
"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, Snowflake, AWS Lake Formation, Vertica and VMware Tanzu Data Services, 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.