Try our new research platform with insights from 80,000+ expert users

Oracle Autonomous Data Warehouse pros and cons

Vendor: Oracle

4.2 out of 5

19 reviews
95% willing to recommend

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

BA

Senior Director BI & Analytics at Hertz Global Holdings, Inc.

May 2, 2019

Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets.

Read full review

DV

President at Vlamis Software Solutions

May 16, 2019

I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.

Read full review

MB

Technology Evangelist, CTO, Entrepreneur with 1-10 employees

Nov 18, 2019

I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.

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: January 2026.

881,082 professionals have used our research since 2012.

reviewer1297710

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

Mar 5, 2020

The analytics have been very good. We've found them to be quite useful.

Read full review

SH

Syed Jaffar Hussain

CTO at a tech services company with 51-200 employees

May 15, 2020

It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.

Read full review

Principal Consultant at DXC

Jul 16, 2020

Self-patching and runs machine-learning across its logs all the time

Read full review

reviewer1501608

Head of Data and Analytics at a financial services firm with 10,001+ employees

Feb 22, 2021

The solution integrates well with Power BI.

Read full review

Consultant at Rpc Data

Mar 16, 2021

The performance and scalability are awesome.

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

Co-Founder at Quantic

Jul 18, 2022

One advantage is that if you already have an Oracle Database, it easily integrates with that.

Read full review

Show 9 more reviews (out of 19)

Oracle Autonomous Data Warehouse Cons review quotes

BA

Senior Director BI & Analytics at Hertz Global Holdings, Inc.

May 2, 2019

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.

Read full review

DV

President at Vlamis Software Solutions

May 16, 2019

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.

Read full review

MB

Technology Evangelist, CTO, Entrepreneur with 1-10 employees

Nov 18, 2019

I would like to see an on-premise solution in the future.

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: January 2026.

881,082 professionals have used our research since 2012.

reviewer1297710

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

Mar 5, 2020

Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.

Read full review

SH

Syed Jaffar Hussain

CTO at a tech services company with 51-200 employees

May 15, 2020

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.

Read full review

Principal Consultant at DXC

Jul 16, 2020

Ease of connectivity could be improved.

Read full review

reviewer1501608

Head of Data and Analytics at a financial services firm with 10,001+ employees

Feb 22, 2021

The initial setup was pretty complex. It was not easy.

Read full review

Consultant at Rpc Data

Mar 16, 2021

It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment.

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

Co-Founder at Quantic

Jul 18, 2022

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.

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

Azure Data Factory vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

OpenText Analytics Database (Vertica) 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 Redshift vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

Snowflake Analytics 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

Azure Data Factory vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

OpenText Analytics Database (Vertica) 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 Redshift vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

Snowflake Analytics vs Oracle Autonomous Data Warehouse

See all alternatives

Related questions

49

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

158

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

57

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

54

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

46

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

38

What cloud data warehouse solution do you recommend?

147

Can you please help me understand cloud databases?

24

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

32

bitmap index as preferred choice in data warehousing environment

23

Why do you recommend using a cloud data warehouse?