Nice
I used to use it in my previous role when I was working as a Spatial Data Analyst. I mostly used it to query and model GIS data and to …
Overview
What is Oracle Autonomous Data Warehouse?
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type.…
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
N/A
Unavailable
What is Oracle Autonomous Data Warehouse?
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
6 people also want pricing
Alternatives Pricing
What is Amazon Redshift?
Amazon Redshift is a hosted data warehouse solution, from Amazon Web Services.
What is ClicData?
ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of…
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is Oracle Autonomous Data Warehouse?
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The solution is built for the cloud and optimized using Oracle Exadata.
Oracle Autonomous Data Warehouse Competitors
- Amazon Redshift
- Microsoft SQL Server
- SAP Business Warehouse (SAP BW), formerly SAP NetWeaver Business Warehouse
Oracle Autonomous Data Warehouse Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
Oracle Autonomous Data Warehouse is optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can discover business insights using data of any size and type. The solution is built for the cloud and optimized using Oracle Exadata.
Amazon Redshift and Microsoft SQL Server are common alternatives for Oracle Autonomous Data Warehouse.
The most common users of Oracle Autonomous Data Warehouse are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(242)Attribute Ratings
Reviews
(1-25 of 32)Companies can't remove reviews or game the system. Here's why
March 29, 2022
Nice
- ROI
- User trainning
- Cost
December 21, 2021
Oracle Autonomous Data Warehouse for Enterprise Analytics
- Scalability
- Availability
- Managing cost
October 07, 2021
A quick way to analyze your data
- It has helped generate key insights, reducing the cost of company per claim
- It has helped gather average recovery information from each claim
- It helped streamline the process of data analysis
May 01, 2021
Oracle Data Warehouse provides enough functionality for basic data warehousing transformations
- Oracle Data Warehouse is very convenient and easy to understand tool; any pl sql developer can start developing in it quickly.
April 12, 2021
New era of data warehouse
- It's a high performance platform. Machine learning notebooks are super helpful!
- No ability to use APEX and SQL Developer extensions like Data Miner
- No ability to incorporate spatial
- Positive: Make development faster and small high index is are requirement which we achieve in Oracle Database.
- Positive: High user community so most of the situations are answered on internet, so no issue while development or integration.
- Negative: Not freeware, maybe a startup or small company should not use this.
December 23, 2020
The future of databases
- Quick to set up
- Initial POC can be delivered in a short period of time.
- System can be shut down when not in use, reducing the billing
- Auto-performant and self-correcting features are highly recommended
December 14, 2020
Oracle Autonomous Data Warehouse An Awesome Tool That Gets Better The More Your Organization Uses It
- Allowed us to downscale on expenses and man hour spent dedicated to warehouse data
- Ease of scheduling and workload optimizaion
- Using the Free Tier allows us to test production-like environments for free
- The "autonomous" behaviour is really great, you can forget about many tedious tasks and concentrate on using the data you already have in a efficient way
December 13, 2020
First hand with Oracle Autonomous Data Warehouse
- Positive - Save time which means cost.
- Positive - Reduced cost including administrative.
- Positive - Quick scale up and down feature which again means cost effective.
- Positive - High Availability, Performance and Security.
- Negative - Not stronger analytic
- Negative - No support for R language.
December 11, 2020
Oracle ADWH for manufacturing company
- No costs for hardware or server rooms
- Cost reduction, turning off or decreasing resources (RAM or CPUs) for the database when it's not needed
- No costs for maintenance of the database (i.e.: patching or resources monitoring)
- No costs for backups and disaster recovery
December 11, 2020
New-generation data warehousing and analytics with Oracle Autonomous Data Warehouse
- Quick answer to business questions because of faster query processing and fast refresh of reports
- Accelerates product/solution development as backend code can be tested faster
- Time saved; existing SQL statements on Oracle Database were compatible with Oracle Autonomous Data Warehouse
December 10, 2020
ADW review
- It added more value to my business with easy data marts and analysis
- Since it is Cloud there is no need of maintenance
- Overall positive impact--Significantly reduced admin cost
- Auto-tuning, patching, and indexing reduced manual intervention
- Built-in reports eliminated the integration of a data warehouse with other reporting tools
December 05, 2020
Awesome in-house solution!
- Faster reports
- Faster queries
- In-house solution
December 05, 2020
Great for digital data but sharing can be complicated
- Saved time
- Helped with data storage
- Saved manual resources
December 04, 2020
Oracle Data Warehouse in our data lake (Real scenario)
- One of the positive things is that we do not need to worry about scalability so we can grow as much as we can without any bottlenecks.
- As a negative of course are the costs which increased but I can ensure that it [is worth it].
November 03, 2020
Oracle Autonomous Data Warehouse + Oracle Analytics Cloud + Oracle Blockchain Platform = 🥰
Score 9 out of 10
Vetted Review
Verified User
- Oracle Autonomous Data Warehouse is approx 100 times faster spin up than manual setup of an Oracle DB.
- 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates.
November 02, 2020
The Oracle Autonomous Data Warehouse - My dream come true
Score 10 out of 10
Vetted Review
Verified User
- Just positive as we wanted to decommission an old application/database and now we have all the historical data - always available and it hardly cost us anything to store it on the Oracle Autonomous Data Warehouse.
November 26, 2019
ADW is a fantastic cloud data warehouse
- ADW is the only tool we explored as a cloud data warehouse and it is able to provide us with summary reports from the core ERP cloud that was previously only manual.
- ADW relieves us of maintenance issues as it is already taken care of.
- ADW lets us avoid having dedicated skilled resources such as DBA since the support is now primarily shifted to cloud.
October 02, 2019
Not the most affordable data warehousing solution
- We had to hire dedicated staff to manage the data warehouse. Negatively impacted ROI.
- Initial price dented the company budget. It took twice as much time to make it all back.
- It is not a cloud solution, so purchasing hardware to support Oracle Data Warehouse was expensive as well.
September 19, 2019
A high performance warehouse database
September 18, 2019
Inside review on ODW.
- Cumbersome sometimes due to the level of data transformation required to load the data ware house tables
September 18, 2019
Oracle Autonomous Warehouse Review
- Price factor is not good
- Report generation is great
- Performance is outstanding
January 04, 2019
Oracle Data Warehouse is the 800 Pound Gorilla
- We are just now opening up a Business Intelligence area in our company. In general, the business seems in love with the quick access to data.
- Analytics and predictive functions, much of which is done with the power of the database, have helped us stay ahead of our competition.
- This is an expensive and fantastic product all at the same time. Don't be fooled that administration costs will go down when you implement this. I believe it requires as much (or more) administration as anything out there.