First hand with Oracle Autonomous Data Warehouse
December 13, 2020

First hand with Oracle Autonomous Data Warehouse

Krishan Mohil | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Data Warehouse

One of the biggest challenge is the scaling and provisioning of hardware & software for any data ware house solution and also the associate problems like configuration, security and importantly tuning of the storing and fetching/querying data. For the same reason Oracle Autonomous Data Warehouse tool used for one of the project for the customer. It help overcome some of critical, complex, manual and time consuming tasks like hardware procurement, configuration, security, high availability and high performance all this with reducing administrative cost and no human error.

  • Scale Up & Down as you need to reduce the cost immediately.
  • Save lots of time and costs, helped project delivery in less time which is a big plus for customer and vendor. Also, saving administrative cost.
  • Performance Tuning, security, backup and high availability.
  • Combine the abilities of a data lake and a data warehouse to manage any data type for business analysis.
  • The analytics come with it to code collaboratively with the rest of your team, not the classic data miner GUI interface.
  • Due to security limitations, neither the powerful GUI development environment Application Express (yet?) nor Oracle R Enterprise are not available.
  • 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.
[Oracle Autonomous Data Warehouse] is well suited in most of case when it comes to save time, cost, quick project delivery, over the cloud and instant scale up and down features. I would not say scenarios where it is less appropriate, it always with anything which comes news have some features missing or not available as of time, you can find ways for better analytics or other ways than no support for R language.