New-generation data warehousing and analytics with Oracle Autonomous Data Warehouse
December 11, 2020

New-generation data warehousing and analytics with Oracle Autonomous Data Warehouse

Nitika Dhingra | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Data Warehouse

We are using Oracle Autonomous Data Warehouse for storing our data from various fusion apps, marketing technology stack, and customer transaction data. We are stitching these disparate data sources/systems together so that eventually we can perform historical and OLAP analysis using Tableau.
  • Extremely fast query execution for large volumes of data
  • Very rich library of statistical and aggregation functions
  • We can access the underlying data objects from Multiple IDEs such as SQL developer
  • Highly granular and robust access control on data warehouse objects
  • Sometimes when we run queries the error codes/details are not detailed or very helpful
  • We need a built-in easy-to-use data pumping tool
  • I get confused sometimes between the schema vs user in Oracle Autonomous Data Warehouse (it is the same)
  • 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
  1. For a large volume of data and quick results, Oracle Autonomous Data Warehouse is best
  2. You can choose columnar storage options to persist data
  3. No learning curve if you have already used Oracle SQL
  4. Self-maintenance and auto-scaling based on usage and load