Item: Oracle Autonomous Database
Rating: 9
Author: Gorthy Rohith

Use Cases and Deployment Scope

We implemented Oracle ADW for an aviation client implementing ODI marketplace & OAC (Oracle Analytics Cloud) building Finance, supply chain & HR Analytics.

Pros and Cons

Fully Managed Cloud Infrastructure
Easy Admin Activties
friendly Developer UI/web SQL option
Wallet/Security option ease in SQL Dev Desktop application
Option of loading parquet files into ADW DB
Oracle_CX Python package

Easier access to connecting to Data lake files & reading them directly similar to Apache Hive
Association/Intro to Data lakes & Spark access from ADW
Streaming Features direct availability/Plugging stream data into ADW

Return on Investment

Return on the admin resources
No separate security setup needed
Ready performance related metrics

Alternatives Considered

Azure Synapse Analytics (Azure SQL Data Warehouse), Apache Hive and Delta Lake

Tight Coupling with ERP, Easier administration. Availability of performance metrics.

Key Insights

Do you think Oracle Autonomous Database delivers good value for the price?

Yes

Are you happy with Oracle Autonomous Database's feature set?

Yes

Did Oracle Autonomous Database live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle Autonomous Database go as expected?

Yes

Would you buy Oracle Autonomous Database again?

Yes

Other Software Used

Azure Synapse Analytics (Azure SQL Data Warehouse), Azure Data Factory, Azure Data Lake Analytics

Likelihood to Recommend

More for relational database requirements where DW analytics is needed. While Not many features to connect the data from a data lake & use it against real-time/stream analytics.

Oracle ADW working experience

Overall Satisfaction with Oracle Autonomous Database