No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle Autonomous Data Warehouse pros and cons

Vendor: Oracle

4.2 out of 5

19 reviews
95% willing to recommend

Leave a review Why PeerSpot?

Pros & Cons summary

Oracle Autonomous Data Warehouse offers extreme performance on large financial data sets with features like self-tuning and seamless Oracle Database integration, ensuring stability and scaling. Security is bolstered by Transparent Data Encryption and self-patching. However, it lacks full support for Application Express, Oracle R Enterprise, and custom tablespaces in the serverless option, with migration tool improvements needed for better integration with other cloud services and internal IP support for VCN in Oracle Cloud.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Oracle Autonomous Data Warehouse delivers extreme performance on large financial data sets and provides self-tuning and self-scaling capabilities.

The system includes Transparent Data Encryption by default, addressing data security concerns effectively.

It integrates seamlessly with Power BI and existing Oracle Database systems, enhancing functionality.

The automatic self-patching feature and continuous machine learning on logs ensure robust security and reliability.

Oracle Autonomous Data Warehouse simplifies backup and repair processes through self-backup and self-repair functionalities, eliminating the need for a database administrator.

CONS

Oracle Autonomous Data Warehouse needs consistent and predictable performance between cloud and on-premises environments.

There is inadequate support for unstructured data and online analytics, lacking compared to Hadoop.

The platform suffers from a complex installation process that could benefit from simplification.

Customization options, such as creating custom tablespaces, are limited with Oracle Autonomous Data Warehouse.

Technical support for Oracle services is reportedly unsatisfactory with a lack of understanding.

Oracle Autonomous Data Warehouse Pros review quotes

reviewer1297710

IT Administrator at a manufacturing company with 1,001-5,000 employees

Feb 25, 2025

The solution is used for analytics and it works for our data security needs.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Aug 15, 2024

The product has self-repair features.

Read full review

reviewer2324613

Data Architect at a computer software company with 51-200 employees

Dec 29, 2023

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.

Read full review

Oracle Autonomous Data Warehouse

Free Report: Oracle Autonomous Data Warehouse Reviews and More

Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: September 2026.

913,806 professionals have used our research since 2012.

Miodrag Milojevic

Senior Data Archirect at Yettel

Jul 25, 2023

It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.

Read full review

MS

MohammadSalamah

CTO at a hospitality company with 1,001-5,000 employees

Apr 2, 2024

The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Jun 23, 2023

It is a very stable tool...It is an extremely scalable tool.

Read full review

DV

Web Developer at NuBean

Nov 3, 2021

The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.

Read full review

reviewer2301549

Digital Project Delivery Manager at a computer software company with 51-200 employees

Oct 30, 2023

The product is easy to use.

Read full review

reviewer1740096

Senior Data Warehouse Developer at a transportation company with 5,001-10,000 employees

Apr 11, 2023

It is a stable and scalable solution.

Read full review

MJ

Research Analyst

Nov 8, 2022

The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people.

Read full review

Show 9 more reviews (out of 19)

Oracle Autonomous Data Warehouse Cons review quotes

reviewer1297710

IT Administrator at a manufacturing company with 1,001-5,000 employees

Feb 25, 2025

Optimization should be better.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Aug 15, 2024

The setup is complex.

Read full review

reviewer2324613

Data Architect at a computer software company with 51-200 employees

Dec 29, 2023

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.

Read full review

Oracle Autonomous Data Warehouse

Free Report: Oracle Autonomous Data Warehouse Reviews and More

Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: September 2026.

913,806 professionals have used our research since 2012.

Miodrag Milojevic

Senior Data Archirect at Yettel

Jul 25, 2023

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.

Read full review

MS

MohammadSalamah

CTO at a hospitality company with 1,001-5,000 employees

Apr 2, 2024

Oracle Autonomous Data Warehouse is not available as an on-premises solution.

Read full review

Kwajah Mohiuddin

Global Head of Architecture at a financial services firm with 1,001-5,000 employees

Jun 23, 2023

The installation process is complex. Oracle can make the installation process better.

Read full review

DV

Web Developer at NuBean

Nov 3, 2021

The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora.

Read full review

reviewer2301549

Digital Project Delivery Manager at a computer software company with 51-200 employees

Oct 30, 2023

A lot of the tools that were previously there have now been taken away.

Read full review

reviewer1740096

Senior Data Warehouse Developer at a transportation company with 5,001-10,000 employees

Apr 11, 2023

They should make the solution more user-friendly.

Read full review

MJ

Research Analyst

Nov 8, 2022

The solution lacks visibility options.

Read full review

Show 9 more reviews (out of 19)

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Databricks vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

SAP Business Data Cloud vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

Azure Data Factory vs Oracle Autonomous Data Warehouse

OpenText Analytics Database (Vertica) vs Oracle Autonomous Data Warehouse

Amazon Redshift vs Oracle Autonomous Data Warehouse

Dremio vs Oracle Autonomous Data Warehouse

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

BigQuery vs Oracle Autonomous Data Warehouse

Amazon EMR vs Oracle Autonomous Data Warehouse

Snowflake Analytics vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

SAP Business Warehouse vs Oracle Autonomous Data Warehouse

IBM Db2 Warehouse on Cloud vs Oracle Autonomous Data Warehouse

See all alternatives

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Databricks vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

SAP Business Data Cloud vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

Azure Data Factory vs Oracle Autonomous Data Warehouse

OpenText Analytics Database (Vertica) vs Oracle Autonomous Data Warehouse

Amazon Redshift vs Oracle Autonomous Data Warehouse

Dremio vs Oracle Autonomous Data Warehouse

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

BigQuery vs Oracle Autonomous Data Warehouse

Amazon EMR vs Oracle Autonomous Data Warehouse

Snowflake Analytics vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

SAP Business Warehouse vs Oracle Autonomous Data Warehouse

IBM Db2 Warehouse on Cloud vs Oracle Autonomous Data Warehouse

See all alternatives

Related questions

260

Which ETL or Data Integration tool goes the best with Amazon Redshift?

382

What are the main differences between Data Lake and Data Warehouse?

236

What are the benefits of having separate layers or a dedicated schema for each layer in ETL?

287

What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?

209

Are there any general guidelines to allocate table space quota to different layers in ETL?

205

What cloud data warehouse solution do you recommend?

243

Can you please help me understand cloud databases?

115

When evaluating Cloud Data Warehouse, what aspect do you think is the most important to look for?

99

bitmap index as preferred choice in data warehousing environment

128

Why do you recommend using a cloud data warehouse?