It's been two months since this profile received a new review

Oracle Autonomous Data Warehouse Reviews & Product Details

What Is Oracle Autonomous Data Warehouse? Autonomous Data Warehouse is a fully managed database that’s tuned and optimized for data warehouse workloads. It combines the market-leading performance of Oracle Database with the ease of Autonomous Database, and is self-driving, self-securing, and self-repairing. Get faster access to analytics, instant elasticity, and smarter data from your data warehouse in the cloud. Autonomous Data Warehouse eliminates error-prone data management processes with powerful self-driving, self-securing, and self-repairing capabilities. Stop worrying about your data management and focus on growing your business with fast, easy, and secure access to your data. Easy - Fully autonomous database - Automated provisioning, patching, and upgrades - Automated backups - Automated performance tuning Fast - Built on Exadata, so you can expect high performance, scalability, and reliability. - It’s also built on key Oracle Database capabilities: parallelism, columnar processing, and compression Elastic - Elastic scaling of compute and storage, without downtime. You only pay for resources consumed. Whether you’re a data warehouse developer, business user, or data scientist, with Autonomous Data Warehouse you gain a comprehensive cloud experience for data warehousing—one that’s fully self-driving, with all of the complicated parts taken care of for you. But not only that, because Autonomous Data Warehouse uses the same Oracle Database software and technology that runs on Oracle on-premises marts, data warehouses, and applications, it’s compatible with your existing data warehouse, data integration, and BI tools. See how this frees you up for data exploration with a free cloud trial of Autonomous Data Warehouse.

Seller

Oracle

Discussions

Oracle Autonomous Data Warehouse Community

Overview by

Amit Satoor

Top-Rated Alternatives

View All Alternatives

Oracle Autonomous Data Warehouse Media

Oracle Autonomous Data Warehouse Screenshot

Provision Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse Demo - Getting Started and Provisioning a New Autonomous Data Warehouse

Provision Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse Reviews (15)

G2 reviews are authentic and verified.

Here's how.

Rok P.

CIO

Enterprise (> 1000 emp.)

11/22/2021

"Use ADW and OAC for Business Intelligence project"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

It's really fast to set up (like 2 minutes to create a new database)

It's cheap, and its costs are based on dedicated resources (RAM and CPUs)

It can be easily turned off

Disaster recovery is granted thanks to fault domains provided by Oracle

Resources (RAM and CPUs) can be increased or decreased at run-time

Oracle automatically performs patching and release upgrades at scheduled times

Backups are automatically performed and very easy to restore

User friendly Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

It's really limited from a DBA point of view

There is only one tablespace associated with all the users you create on the database

The cost (license and monthly fees) are not always very clear

The loading of data on the cloud is subjected to network speed, so vast amounts of data may take a lot of time to be loaded on the database

More data connections to different applications can be introduced

It can get expensive with options and additional features

Do not have a provision to control the database instance and configuration. Review collected by and hosted on G2.com.

What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?

Oracle Autonomous Data Warehouse and Oracle Analytics Cloud are being used to help us get the best out of our data which was earlier analyzed using Microsoft Excel. Before the project, users used spreadsheets, different reports tools, and other databases to perform management analysis. Review collected by and hosted on G2.com.

Phil B.

CTO

Mid-Market (51-1000 emp.)

11/23/2021

Business partner of the seller or seller's competitor, not included in G2 scores.

"ADW - Enabling Enterprise Data Management with SaaS UI"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

The elements that are most helpful to a traditional 'techie' is the automation of the platform and infrastructure, e.g. patching and upgrades now all sorted. It's biggest draw against its competitors is the performance of the underlying platform, making it pound for pound super competitive. Finally the lastest enhancements in terms of the UI for data ingesting, loading, charting and data gives it a complete SaaS feel. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

Historically the issue was the lack of integration into existing OCI cloud services and networking constructs however this has been resolved. Ideally, more flexibility on the sizing of the autonomous DR would be a good improvement, i.e. pilot light capability. Review collected by and hosted on G2.com.

Biju T.

Senior Director, Global Oracle Practice

Mid-Market (51-1000 emp.)

11/22/2021

Business partner of the seller or seller's competitor, not included in G2 scores.

"Capacity on demand Data Warehouse"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

Autoscaling of Autonomous Database computing resources - completely automated, no user intervention required, and per-second billing. True capacity-on-demand, and very flexible. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

The requirement to have a multi-tenancy license to use BYOL for ADB. Most customers do not own multi-tenancy licenses but hold EE licenses. Maybe create a new tier where up to 4 OCPU ADW does not require multi-tenancy. Review collected by and hosted on G2.com.

Recommendations to others considering Oracle Autonomous Data Warehouse:

Give serious consideration to ADW and ATP when migrating databases to the Public Cloud. If you are not doing BYOL, you will get many benefits from the autoscaling feature, where the scaling up and scaling down are automatic. Review collected by and hosted on G2.com.

What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?

We use ADW for our departmental warehouse to consolidate reporting and to integrate various applications. The APEX dashboards and Oracle Analytics Warehouse reports add value to ADW. The integration with third-party non-Oracle applications is straightforward. Review collected by and hosted on G2.com.

Jerry G.

Director of Database Services

Mid-Market (51-1000 emp.)

11/23/2021

"A Game Changer"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

What's not to like about ADW? It doesn't require a DBA to provision or manage, It runs on the Oracle Exadata infrastructure, tunes itself, can scale OCPUs automatically, and comes with a wide variety of enterprise-level data management and analysis tools. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

There isn't anything that I dislike, and I would only suggest that they continue to add more tools and functionality to the integrated toolset. Review collected by and hosted on G2.com.

What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?

We had outgrown our on-premise solution. As a result, we were having performance issues due to hardware limitations. By moving our Data Warehouse to ADW we have solved the performance and sclability issues while also reducing the amount of effort and resources necessary to support the environment. Review collected by and hosted on G2.com.

Holger F.

CEO

Small-Business (50 or fewer emp.)

11/22/2021

Business partner of the seller or seller's competitor, not included in G2 scores.

"ADW review by sumIT"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

Not only a performant, fully-managed Data Warehouse/Lakehouse service, but one that does bring all the features of a mature converged RDBMS to the table. Competing services don't offer services like model-based data consistency for example. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

A major advantage is that the service is available in the Oracle Cloud only. Many of our customers still try to carry out a single Cloud strategy since setting up Cloud environments is highly complex and expensive regarding required manpower, time spent, and network cost. Therefore customers dismiss ADW, not on the grounds of limited performance or missing features, but because of lacking multi-Cloud platform availability. Review collected by and hosted on G2.com.

Recommendations to others considering Oracle Autonomous Data Warehouse:

a) Should you have existing investments in the Oracle database, using ADW is a no-brainer. Secure your investment.

b) Don't dismiss ADW based on the on-premises cost of Oracle database. Use the Oracle cost estimator to realistically estimate the required investment. Very likely, you will be positively surprised.

c) Assess the competition realistically. Do they offer comprehensive SQL support, model-based data consistency, converged multiple engines, etc.? Should you need these features, the new Cloud services may not be sufficient for your needs. Review collected by and hosted on G2.com.

What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?

Relational Data Lake access, i.e. a Data Lakehouse use case.

Classical Data Warehouse and Business Intelligence/Analytics workloads.

Low code development with APEX. Review collected by and hosted on G2.com.

Sushant D.

Business Intelligence Engineer - 2

Small-Business (50 or fewer emp.)

6/30/2022

"Good to use. Less user interactive."

3.5/5

What do you like best about Oracle Autonomous Data Warehouse?

Security and performance. Data retrieval is smooth. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

The user friendliness is not up to the mark. Review collected by and hosted on G2.com.

Julian D.

Managing Director

Enterprise (> 1000 emp.)

11/22/2021

Business partner of the seller or seller's competitor, not included in G2 scores.

"Global Database Lead at Accenture"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

The fastest existing data warehouse with the highest possible level of automation. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

No DBA access and no operating system access Review collected by and hosted on G2.com.

Verified User in Financial Services

Mid-Market (51-1000 emp.)

11/24/2021

Business partner of the seller or seller's competitor, not included in G2 scores.

"Enterprise database service even for companies without DBAs"

5/5

What do you like best about Oracle Autonomous Data Warehouse?

The flexibility to increase or decrease the resources without downtime, the ability to start with a very small database and make it grow as needed. The fact that all upgrades and patches are applied by Oracle.

The guaranty that a database server as Oracle and a powerfull hardware as Exadata are under the hood. Review collected by and hosted on G2.com.

What do you dislike about Oracle Autonomous Data Warehouse?

The cost can be thought as high but since you can adapt the resources to what you actually need at every moment, the price can be lower than other products where you cannot modify the resources. Review collected by and hosted on G2.com.