ADW is a fantastic cloud data warehouse
Anonymous | TrustRadius Reviewer
November 26, 2019

ADW is a fantastic cloud data warehouse

Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is the data warehousing tool for our company in cloud. It is currently being utilized by the transportation department, but we are in the process of expanding its adoption to other departments once the single sign-on issues with the connection to our core Oracle ERP Cloud is resolved. We have a need for many summary reports which could be a challenge from OTBI, hence we are planning to do summarization at the ADW level and then report out of ADW using Oracle Analytics Cloud.
  • Data warehouse in-cloud, that is the biggest plus point.
  • No need to worry about backups or maintenance since it is in-cloud.
  • Oracle Analytics Cloud comes with a default connector to ADW which makes it handy in terms of integration. OAC is our reporting tool that sits on top of ADW.
  • ODI Marketplace is a free add-on that can be installed on the compute of ADW and could be used as a complete ETL tool.
  • Oracle ADW should definitely improve in terms of cumbersome connectivity with third-party tools like ODI Marketplace.
  • Oracle Data Sync that is used to load data into ADW does not work if we have single sign-on enabled.
  • ADW can also be priced on a subscription basis instead of universal credits. This way customers need not be hooked all the time concerned about overages but use the tool to its full capacity.
  • ADW is the only tool we explored as a cloud data warehouse and it is able to provide us with summary reports from the core ERP cloud that was previously only manual.
  • ADW relieves us of maintenance issues as it is already taken care of.
  • ADW lets us avoid having dedicated skilled resources such as DBA since the support is now primarily shifted to cloud.
Since our core was Oracle ERP Cloud, we were looking for a cloud data warehouse solution from Oracle. Autonomous Data Warehouse perfectly fit that need and has already provided us with the results. Our CSM and the readily available support helps us to resolve issues and find solutions at no extra cost. The tool comes with APEX and Machine Learning developer tools that add more value to what we are planning to invest in future.

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

Yes

Are you happy with Oracle Autonomous Data Warehouse's feature set?

Yes

Did Oracle Autonomous Data Warehouse live up to sales and marketing promises?

Yes

Did implementation of Oracle Autonomous Data Warehouse go as expected?

Yes

Would you buy Oracle Autonomous Data Warehouse again?

Yes

We didn't use one. The benefit of cloud was very obvious and it empowered us to just click and provision the software with no third-party vendor.
Oracle Autonomous Data Warehouse is well suited for on-prem to cloud situations. That is more controllable as we have control over the ETL tools and database. It is still a challenge to adopt ADW on a full scale for cloud-to-cloud implementations primarily because the tool is still evolving and the challenges pose a risk to critical implementations without resolving the challenges.