TrustRadius Insights for Oracle Autonomous Data Warehouse are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Easy to Use: Users consistently commend the platform's user-friendly setup process, even for those with limited database administration experience. There is not much of a learning curve which allows users to perform and increase work productivity almost right away.
Intuitive: Users have found Oracle Autonomous Data Warehouse to be intuitive and adaptive to their work, allowing for a more seamless and convenient experience. This includes adapting to other work processes and integration capabilities.
High Performance: The system's exceptional performance enables efficient task completion, while its autonomous features simplify management and usage, resonating positively with users who appreciate these aspects during their database operations.
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.
Pros
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
Cons
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
Likelihood to Recommend
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.
VU
Verified User
Engineer in Engineering (Internet company, 5001-10,000 employees)
The blockchain style for data storage and analysis. We have many different data formats from XML, HTML, JSON and this tool is very useful in organizing and querying all types of data at once. Getting all of our data centralized in one place and then only using one tool to look at all of it is hugely beneficial.
Pros
Integration with other Oracle products is very easy.
Centralizing different data formats.
Smooth implementation.
Cons
Learning curve can be high if the user is inexperienced.
Can get expensive with options.
Likelihood to Recommend
Again, it is great for consolidating our data. It performs much better than our last tool. Our reports are smooth and we are able to integrate more data within each report. This is huge because this is the ideal outcome of a product like this. We haven't moved all of our ETL to the tool yet, but any new pipelines being built are utilizing the tool.