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