# Oracle Autonomous Data Warehouse Reviews **Vendor:** Oracle **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 15 ## About Oracle Autonomous Data Warehouse 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. ## Oracle Autonomous Data Warehouse Reviews ### 1. Use ADW and OAC for Business Intelligence project **Rating:** 5.0/5.0 stars **Reviewed by:** Rok P. | CIO, Enterprise (> 1000 emp.) **Reviewed Date:** November 22, 2021 **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 **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. **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. ### 2. ADW - Enabling Enterprise Data Management with SaaS UI **Rating:** 5.0/5.0 stars **Reviewed by:** Phil B. | CTO, Mid-Market (51-1000 emp.) **Reviewed Date:** November 23, 2021 **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. **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. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** The main benefit is the turnkey solution for enterprise data problems; building a data warehouse is more accessible to customers as is loading and visualising the data. ### 3. Capacity on demand Data Warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Biju T. | Senior Director, Global Oracle Practice, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2021 **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. **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. **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. **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. ### 4. A Game Changer **Rating:** 5.0/5.0 stars **Reviewed by:** Jerry G. | Director of Database Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 23, 2021 **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. **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. **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. ### 5. ADW review by sumIT **Rating:** 5.0/5.0 stars **Reviewed by:** Holger F. | CEO, Small-Business (50 or fewer emp.) **Reviewed Date:** November 22, 2021 **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. **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. **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. **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. ### 6. Good to use. Less user interactive. **Rating:** 3.5/5.0 stars **Reviewed by:** Sushant D. | Business Intelligence Engineer - 2, Small-Business (50 or fewer emp.) **Reviewed Date:** June 30, 2022 **What do you like best about Oracle Autonomous Data Warehouse?** Security and performance. Data retrieval is smooth. **What do you dislike about Oracle Autonomous Data Warehouse?** The user friendliness is not up to the mark. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** Large data navigation and consolidation. ### 7. Global Database Lead at Accenture **Rating:** 5.0/5.0 stars **Reviewed by:** Julian D. | Managing Director, Enterprise (> 1000 emp.) **Reviewed Date:** November 22, 2021 **What do you like best about Oracle Autonomous Data Warehouse?** The fastest existing data warehouse with the highest possible level of automation. **What do you dislike about Oracle Autonomous Data Warehouse?** No DBA access and no operating system access **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** DW with minimum DBA intervention. Fastest database abailable right now from cloud vendors. Extremely easy to provision, use and maintain. ### 8. Enterprise database service even for companies without DBAs **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 24, 2021 **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. **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. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** Data security, systems always updated, high performance, scalable cost. ### 9. Follow Our Cloud Strategy **Rating:** 5.0/5.0 stars **Reviewed by:** Christian M. | CEO, Mid-Market (51-1000 emp.) **Reviewed Date:** November 23, 2021 **What do you like best about Oracle Autonomous Data Warehouse?** Ease of use and flexibility concerning scalability etc. **What do you dislike about Oracle Autonomous Data Warehouse?** The pricing model from Oracle from time to time confusing **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** A holistic view on our business with maximum speed concerning decision making. ### 10. Oracle ExaCC-A **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 25, 2021 **What do you like best about Oracle Autonomous Data Warehouse?** Flexibility, support of CI/CD pipeline for development systems. **What do you dislike about Oracle Autonomous Data Warehouse?** To use it, as it is a PaaS system, changes must be made. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** Agile, CI/CD ### 11. HDFS user **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 23, 2021 **What do you like best about Oracle Autonomous Data Warehouse?** Management/OPs Auto-provision As a Hadoop user, I would love to have the capabilities ADW. **What do you dislike about Oracle Autonomous Data Warehouse?** Lack of HDFS/HIVE support - it is my primary environment **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** N/A ### 12. After 17 Years a New Level of Data Warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Abdo G. | Group IT Business Solution Manager, Enterprise (> 1000 emp.) **Reviewed Date:** April 16, 2020 **What do you like best about Oracle Autonomous Data Warehouse?** When we talk about The ADW or Autonomous Data Warehouse we can not forget to mention the Elastic choice from our review. But many people ask about what it is the ADW? Does our Business Analyst need it? Well, it depends on your company; do you need scalability or no? do you need elasticity or no? Based on my experiences for about 17 years in the field, yes, we need that. The Oracle Autonomous Data Warehouse is a cloud-based software that can change your view as a decision-maker inside your enterprise. No need for days and hours to let the DBA work to prepare the data in order to be used. Based on Oracle the ADW needs only a few information from you and Voila!! Up and running. George Lumpkin, VP Product Management Oracle, mention on a YouTube video that you need minimum effort from your DBA, and he/she can you the effort in doing other things such as creating users, designing tablespaces and schemas. The Business Intelligence people were looking for this kind of software for years where DBA needs to do nothing like a major preparation. Finally, you will ask about the cost, so based on Oracle the ADW prices depend on your company size, storage, CPUs and many other factors. **What do you dislike about Oracle Autonomous Data Warehouse?** The Cost of Oracle ADW could be confusing sometimes and this due to many varieties of options available to choose from, but that I don't like honestly, I like to be straight and forward in the cost. **Recommendations to others considering Oracle Autonomous Data Warehouse:** If you have a problem with resources such as DBA and a huge database on the enterprise level, this software is for you... The Oracle Autonomous Data Warehouse is a cloud-based software that can change your view as a decision-maker inside your enterprise. No need for days and hours to let the DBA work to prepare the data in order to be used. Based on Oracle the ADW needs only a few information from you and Voila!! Up and running. George Lumpkin, VP Product Management Oracle, mention on a YouTube video that you need minimum effort from your DBA, and he/she can you the effort in doing other things such as creating users, designing tablespaces and schemas. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** I am solving many problems from the Existence of the DBA by minimizing the needs, and also mainly am solving the problem of the scales elastically, fast query and inquiries...and many other benefits. ### 13. Next Generation Database Product **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2019 **What do you like best about Oracle Autonomous Data Warehouse?** I like that i can use all the features of the Oracle Database without having to do all the patching and maintenance which is a pain. **What do you dislike about Oracle Autonomous Data Warehouse?** Well if it were free that would be fantastic but hey you can't have everything **Recommendations to others considering Oracle Autonomous Data Warehouse:** Schedule the start and stop of ADW as you can save 60% of the cost by running it business hours only **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** Building analytic solutions using a flexible platform ### 14. Autonomous Data Warehouse Cloud Makes Building Data Sources Fast **Rating:** 4.5/5.0 stars **Reviewed by:** Tim V. | Vice President & Analytics Strategist, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2018 **What do you like best about Oracle Autonomous Data Warehouse?** Ease of set up and computing power. It's a high performance platform. Machine Learning Zeppelin notebooks are GREAT! **What do you dislike about Oracle Autonomous Data Warehouse?** No ability to incorporate spatial (sdo data types). Can't create indexes when you know you need them. No ability to use APEX and SQL Developer extensions like Data Miner. **Recommendations to others considering Oracle Autonomous Data Warehouse:** Consider using OADWC when you need to stand up new instances for OAC very quickly. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** Set up data sources for Oracle Analytics Cloud quickly. Migrate existing data warehouses. ### 15. Strong new product for the data warehouse product offering **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Investment Management | Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2018 **What do you like best about Oracle Autonomous Data Warehouse?** I like that the software increases both efficiencies and security. It takes out the element of human error and replaces it with machine learning. **What do you dislike about Oracle Autonomous Data Warehouse?** There is nothing we have found negative with the product so far. **What problems is Oracle Autonomous Data Warehouse solving and how is that benefiting you?** The time efficiencies created from not having to maintain and patch are huge time savers. They allow our team to focus on new innovations and other projects. - [View Oracle Autonomous Data Warehouse pricing details and edition comparison](https://www.g2.com/products/oracle-autonomous-data-warehouse/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-12+20%3A28%3A06+-0500&secure%5Bsession_id%5D=c560dac7-a2e0-464f-ac71-f632f4d67990&secure%5Btoken%5D=ff1f5b2c47fa0712777f2f14b8087f2a6fe5821e60b13d62d30df29c0db62fd3&format=llm_user) ## Oracle Autonomous Data Warehouse Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Automation** - Workflow Automation - Multi-platform support - Data Management - Data Simplicity **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Functionality** - Documentation management - Platform support - Template functionality **Deployment** - On-Premise - Cloud **Administration** - Error Alerts - Service Automation - Workflow management **Performance ** - Scalability **Agentic AI - Data Warehouse Automation** - Proactive Assistance **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top Oracle Autonomous Data Warehouse Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (705 reviews) - [IBM Db2](https://www.g2.com/products/ibm-db2/reviews) - 4.1/5.0 (598 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (369 reviews)