Oracle ADW working experience
Use Cases and Deployment Scope
Pros
- 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
Cons
- 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
