1. Home
  2. Data Warehouse Software
  3. Oracle Autonomous Data Warehouse Reviews
  4. User Review of Oracle Autonomous Data Warehouse
Your own Datawarehouse on a few clicks. Fast and easy to provision and configure.
December 13, 2020

Your own Datawarehouse on a few clicks. Fast and easy to provision and configure.

Lisandro Fernigrini | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Data Warehouse

I'm using the a Free Tier [Oracle] Autonomous Data Warehouse in a PoC / Test environment to centralize information from a wide range of sources in order to allow quick Reporting and OLAP analysis of data coming from our suite of tolling software. I'm integrating information from more than 30 databases (20 SQL Server, 5 Oracle and other like Postgres). This POC will try to demonstrate the ease of use and maintenance of Autonomous databases so we can recommend them to our customers.
  • Simple and quick provisioning and configuration
  • Really good and fast ETL features allow quick data load
  • Always pached, always available. Foerget about many tedious admin tasks
  • Pricing may we high when using all features
  • 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
It's great if you are already using othe Oracle Cloud products. It is really simple to integrate with them. We plan to use it as a central datawarehous hosting data from many different data sources.

Using Oracle Autonomous Data Warehouse

  • We plan to offer a ready to use data warehouse to our customers
  • We wera able to provision, configure and use a DW for free with the Free Tier option
Because
  • It is really simple to provision and configure.
  • Does not require continous attention from the DBA, autonomous features allows the database to perform most of the regular admin tasks without need for human intervention.
  • Allows to integrate multiple data sources on a central data warehouse, and explode the information stored with different analytic and reporting tools.

Evaluating Oracle Autonomous Data Warehouse and Competitors

  • Product Features
  • Product Usability
I wanted a simple to provision and configure solution

Oracle Autonomous Data Warehouse Implementation

Understanding Oracle Cloud Infrastructure is really simple, and Autonomous databases are even more. Using shared or dedicated infrastructure is one of the few things you need to consider at the moment of starting provisioning your Oracle Autonomous Data Warehouse.
  • Implemented in-house
Change management was minimal - Since this is a PoC, we have not implemented it as a functional piece of our suite of products, but the decision was to use ADW in order to reduce the need of change management. Autonomous features allow to deploy and use Oracle ADW with less effort than other available options
  • None during provision / configuring
  • Minor effort to create ETL to upload data
  • Minor effort to confgure reporting and analytic tools to use the DW

Oracle Autonomous Data Warehouse Support