Oracle Autonomous Data Warehouse Pros and Cons

Self-patching and runs machine-learning across its logs all the time

The solution integrates well with Power BI.

It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.

I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.

The analytics have been very good. We've found them to be quite useful.

Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets.

I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.

Ease of connectivity could be improved.

The initial setup was pretty complex. It was not easy.

One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace.

I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end.

Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.

An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud.

I would like to see an on-premise solution in the future.