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
94% willing to recommend

174 followers

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

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

Principal Consultant at DXC

Jul 16, 2020

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

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: February 2025.

839,319 professionals have used our research since 2012.

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

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

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

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

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

Consultant at Rpc Data

Mar 16, 2021

The performance and scalability are awesome.

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

Show 9 more reviews (out of 19)

Oracle Autonomous Data Warehouse Cons review quotes

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

Principal Consultant at DXC

Jul 16, 2020

Ease of connectivity could be improved.

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: February 2025.

839,319 professionals have used our research since 2012.

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

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

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

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

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

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

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

Show 9 more reviews (out of 19)

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Azure Data Factory vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

Vertica vs Oracle Autonomous Data Warehouse

Amazon Redshift vs Oracle Autonomous Data Warehouse

Dremio vs Oracle Autonomous Data Warehouse

BigQuery vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

See all alternatives

Product Categories

Product Categories

Cloud Data Warehouse

Popular Comparisons

Popular Comparisons

Azure Data Factory vs Oracle Autonomous Data Warehouse

Snowflake vs Oracle Autonomous Data Warehouse

Teradata vs Oracle Autonomous Data Warehouse

Microsoft Azure Synapse Analytics vs Oracle Autonomous Data Warehouse

Vertica vs Oracle Autonomous Data Warehouse

Amazon Redshift vs Oracle Autonomous Data Warehouse

Dremio vs Oracle Autonomous Data Warehouse

BigQuery vs Oracle Autonomous Data Warehouse

AWS Lake Formation vs Oracle Autonomous Data Warehouse

See all alternatives

Related questions

40

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

124

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

226

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

87

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

8

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

15

What cloud data warehouse solution do you recommend?

89

Can you please help me understand cloud databases?

0

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

82

bitmap index as preferred choice in data warehousing environment

11

Why do you recommend using a cloud data warehouse?