Oracle Autonomous Data Warehouse Reviews

6 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.6 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-3 of 3)

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
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.
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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
The autonomous data warehouse is being used as a test case currently. We are using it to test how much more efficient and reliable it can be compared to our current configuration. It is used solely in my department . It is used to address performance issues for the most part.
  • It enables us to execute large queries quicker
  • It is easier to set up
  • It is easier to manage
  • I want more admin access for DBA to configure this database
It is well suited when buying new server hardware is too costly and when setting up a warehouse quickly is very necessary. It is also great when a DBA has very limited experience managing a data warehouse.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
We used Oracle Autonomous Database for our warehouse reporting. It is a 50 TB huge database and reports are generated every day. It is pretty read intensive database. It's availability is required for 24 X 7. We have several thousands customers using it on a regular basis. The performance is phenominal.
  • Read queries
  • ETL process
  • Performance.
  • Use case for hybrid environment
  • Price factor
  • Clustering
We used Oracle Autonomous Database for our warehouse reporting. It is a 50 TB huge database and reports are generated every day. It is a pretty read intensive database. Its availability is required for 24 X 7. We have several thousands of customers using it on a regular basis. The performance is phenomenal.
Read this authenticated review

Oracle Autonomous Data Warehouse Scorecard Summary

About Oracle Autonomous Data Warehouse

Oracle now offers their Autonomous Data Warehouse Cloud PaaS, a fully managed data warehouse available through Oracle Cloud.
Categories:  Data Warehouse

Oracle Autonomous Data Warehouse Technical Details

Operating Systems: Unspecified
Mobile Application:No