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."Amazon Redshift is very fast. It has really good response times. It's very user-friendly."
"The valuable features are performance, data compression, and scalability."
"Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten."
"The most valuable feature is that the solution is fully embedded in the AWS stack."
"Amazon Redshift is a really powerful database system for reporting and data warehousing."
"The solution has very competitive pricing."
"The initial setup is easy."
"I have primarily used the Redshift Spectrum feature and found it most valuable."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"Self-patching and runs machine-learning across its logs all the time"
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The performance and scalability are awesome."
"The analytics have been very good. We've found them to be quite useful."
"It is a stable and scalable solution."
"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."
"There are too many limitations with respect to concurrency."
"The solution could improve in handling more data formats and more native support for RDF."
"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."
"It lacks a few features which can be very useful, such as stored procedures"
"The explain panel in the Redshift database could be better."
"Amazon Redshift could improve the user interface support."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Redshift's GUI could be more user-friendly. It's easier to perform queries and all that stuff in Azure Synapse Analytics."
"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."
"The solution lacks visibility options."
"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."
"A lot of the tools that were previously there have now been taken away."
"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."
"The installation process is complex. Oracle can make the installation process better."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
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.