New era of data warehouse
April 12, 2021

New era of data warehouse

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse is a fully managed database that’s tuned and
optimized for data warehouse workloads, so we decided to give it a try with a POC. It combines the market-leading
performance of Oracle Database with the ease of Autonomous Database and
is self-driving, self-securing, and self-repairing. Our objective was to spend our time focusing on delivering applications
to solve our business problems. One of the hurdles was the
time spent in maintaining--upgrading, patching, installing new
services. Oracle Autonomous Data Warehouse gave us the confidence to
delegate the operational well-being of our database instances to the
experts who designed it from the ground up.
  • Excellent performance, ease of use, great scalability, and most importantly excellent integration with Oracle GoldenGate for real-time data view
  • Fully managed enterprise class, full-featured relational database that brings the power of Oracle technology to managed Cloud; support for private endpoints to keep data private
  • Multi-user, high concurrency real-time reporting from across several data sources
  • Level of integration or compatibility to connect it to different applications can be improved
  • The support service is slow
  • The issue is with the record number limitation of not being able to bring back more than one million records or not being able to export larger datasets to Excel
  • It's a high performance platform. Machine learning notebooks are super helpful!
  • No ability to use APEX and SQL Developer extensions like Data Miner
  • No ability to incorporate spatial
Oracle Autonomous Data Warehouse stacks up great against all the existing data warehouse applications.
The ease of use for our team, their ability to create their own data
flows and bring in data sets, the function option for users with limited
SQL experience.
  • Drive innovation
  • Cost management
  • Create internal/operational efficiencies
  • Improve business process outcomes
  • Improve supplier or partner relationships
  • Improve compliance and risk management
  • Improve customer relations/service
  • Improve business process agility

Not suited: Nothing really. Now with the latest version; it is super stable and fast.