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.
Loading Reviews List....
Oracle Autonomous Data Warehouse Reviews
8 Reviews
InformationComputer Software7Internet1
Search is temporarily unavailable. Filters are still applied.
It's used by a department, it moves and transforms data from transactional financial database into warehouse database, so that end users can generate the reports out of it.
Pros
transformations
ease of use
Cons
Oracle Data Warehouse creates a package in the database for each mapping - it would be nice to have the ability to manually update that package and Oracle Data Warehouse to recognize those updates without problems
Likelihood to Recommend
It works good for data movement and transformations into data warehouse databases.
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.
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.
Pros
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
Cons
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)
Likelihood to Recommend
For a large volume of data and quick results, Oracle Autonomous Data Warehouse is best
You can choose columnar storage options to persist data
No learning curve if you have already used Oracle SQL
Self-maintenance and auto-scaling based on usage and load
Oracle Autonomous Data Warehouse is used in automation of provisioning and configuring a data warehouse. It is also used to tune and scale the data warehouse as needed. It is used across the whole organization. Business problems that it addresses: Since the manual work is almost completely eliminated, the cost of administering a data warehouse is reduced significantly. Also, this is highly secured and reliable.
Pros
High performance using continuous query optimization, table indexing, data summaries, and auto-tuning
Autonomous data encryption and security patch application
Different deployment models--shared, dedicated, and cloud@customer
Built in analytics--this makes data loading, indexing, and building good data visualization models easier
Cons
Improved machine learning capabilities
I find it to be the best autonomous solution out there with high scalability and reliability
More capabilities of Analytics Cloud
Likelihood to Recommend
Well suited when 1. High performance is needed--The autonomous data warehouse is capable of increasing performance for continuous query optimization, table indexing, data summaries, and auto-tuning even as data volume and number of users grows. 2. High scalability is needed--Unlike other cloud services that require downtime to scale, Oracle Autonomous Data Warehouse scales while the service continues to run. 3. Automation is needed--Oracle Autonomous Data Warehouse automates provisioning, configuring, securing, tuning, and scaling for a data warehouse.
Less suited when 1. There is not a significant amount of data that needs to be handled on a daily basis. 2. Data analytics is not a requirement.
VU
Verified User
Employee in Information Technology (51-200 employees)
One of our data warehouses is Oracle Autonomous Data Warehouse and it is being used for two years corresponding very well in terms of performance and reliability. Some of our data has been stored there and it's available to some departments to connect through it to pull data feeding their business intelligence tools.
Pros
Performance is really nice if set properly.
[Reliability].
Documentation is easy.
Cons
Some ETL tools are not compatible yet.
Even they have a good documentation, I don't think this is well structured.
The tool could be more intuitive.
Likelihood to Recommend
You definitely should go for Oracle Autonomous Data Warehouse if you are looking for something trustable, secure, tunable and that can be scalable easily. All these features make it one of the best tools in terms of Data Warehousing. If you are looking for something small and of course cheap, I would not suggest this option.
VU
Verified User
Employee in Information Technology (11-50 employees)
Oracle Data Warehouse is being used across our entire organization. Although each department in our organization has its own individual use cases for maintaining a data warehouse, the overall problems that are being solved are the same. We are using Oracle Data Warehouse for business intelligence related queries, finding trends in periods of time using all the historical data, and for deep data exploration.
Pros
Quick and easy deployment. There is no hassle in setting up software and maintaining hardware.
Highly available and scalable. Accessing the data warehouse is easy, and it can scale up based on the data size requirements.
Autonomous functionality. With the help of machine learning, autonomous data warehousing reduces the amount of time spent managing it.
Cons
Customer support isn't the best out there. We usually have to wait about an hour to get some form of assistance.
Pricing is a bit higher than many of its competitors such as AWS Redshift.
Tweaking features requires dedicated staff. Software is fairly advanced. Would be difficult to use for newcomers.
Likelihood to Recommend
Oracle Data Warehouse is well-suited for businesses medium-sized and up. Keep in mind to manage and utilize Oracle Data Warehouse's full potential, you will need to hire dedicated staff that is experienced in using it. Not to mention, the pricing is a bit high. It is less appropriate for smaller businesses that have smaller budgets and fewer employees.
VU
Verified User
Engineer in Information Technology (51-200 employees)
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.
Pros
Read queries
ETL process
Performance.
Cons
Use case for hybrid environment
Price factor
Clustering
Likelihood to Recommend
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.
VU
Verified User
Consultant in Information Technology (201-500 employees)
Currently, we are using Oracle Data Warehouse for service analytics, sales order management and install base module analytics. Business users are using it to solve their business problems where they want to analyse & understand different service contracts made by company, products orders, sales in different territories.
Pros
It provides ease, feasibility and flexibility to use Oracle out of box pre-built solutions with different verticals and horizontals of industries such as Insurance Analytics, Financial Analytics, Sales and Marketing Analytics, etc.
It's always easy to use Oracle Data Warehouse where you have Oracle EBS and other Oracle Transactional Systems. Since it provides pre-built data models based on various standard BI solutions (in ERP & CRM Areas).
With various customers and businesses using Oracle dbs for transactional systems, it is always easy to recommend oracle data warehouse in numerous beneficial ways like cost, ease for implementation and maintenance, support for various top Oracle BI tools efficiently, etc
Cons
Query Performance in Oracle Data warehouse compared to other parallel execution dbs is a little low. But given a chance on concentration with good Oracle DB design can overcome those problems in warehouse.
For Big Data Implementation, it's not very cost effective compared to other big data solutions that are based on Hadoop systems and light weight BI Tools.
It's more preferable with Dimensional Modeling compared to 3NF models datawarehouse.
Likelihood to Recommend
It's more preferred where ERP, CRM systems are built with Oracle and then it's always highly recommendable to use Oracle data warehouse and all Oracle solutions. It also does well with other source data systems from SAP, Peoplesoft, JD Edwards. For BI/Data warehouse solutions with Structured and Unstructured Data (Big Data Solutions) it's preferable to use Hadoop systems and other visually appealing tools.
