Oracle Autonomous Data Warehouse Reviews and Ratings
Rating: 10 out of 10
Score
10 out of 10
Community insights
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.
I used to use it in my previous role when I was working as a Spatial Data Analyst. I mostly used it to query and model GIS data and to write spatial queries to extract meaningful information. We used a GIS product that was only compatible with oracle and TOAD. I had some fun learning/experiences with it.
Pros
Querying & Extraction of Data
Data modelling
Materialised views and views creating
Cons
More user interactive
Syntax rectifying capability
UI
Likelihood to Recommend
It has always been well suited to me while writing spatial and nonspatial oracle SQL queries to extract some meaningful data. It made my life easier to write queries etc. The good thing is that it has got heaps of documentation available online and also tutorials which are good for learning purposes. Bad in the sense that probably can be improved in terms of UI
VU
Verified User
Engineer in Information Technology (1001-5000 employees)
Oracle Autonomous Data Warehouse is being used by our organization to help our clients get the best out of their data which was earlier analyzed using Microsoft Excel. It is currently being used by one department of the company which caters to an Australian insurance giant. The clients want to better utilize the claims data in order to reduce the pathing cost and increase income from recoveries.
Pros
Fast performance
User friendly
Fully managed
Data security
Cons
More data connection to different applications can be introduced
Pricing
User support service
Likelihood to Recommend
It is well suited for scenarios where large data sets are to be analyzed and insights to be extracted. It is not suitable for translations like update, delete, etc as it is not optimized for this. The major purpose of a data warehouse is to handle large sets of data to efficiently analyze them to help businesses.
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
<div>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.</div><ul><li>Drive innovation</li><li>Cost management</li><li>Create internal/operational efficiencies</li><li>Improve business process outcomes</li><li>Improve supplier or partner relationships</li><li>Improve compliance and risk management</li><li>Improve customer relations/service</li><li>Improve business process agility</li></ul>
<div>Not suited: Nothing really. Now with the latest version; it is super stable and fast.</div>
It is used in multiple departments to build in-house analytics tools where we use Oracle as our main database.
The current purpose of using Oracle in our team is just for storing less data but highly index database for frequent data fetch which enable our operation to resolve customer tickets/complaint within SLA. Our current system is small which may we scale in the future (10-20 million records in main and we also create SCD type 1,2 and 3 ETL flow using Oracle).
Pros
To work in SQL and PL SQL and create high index database. Its user base is very huge so it is used in most of the company which helps in building profile.
Easy integration in application development, I have used in python currently.
Developers must know the backend as well so that they can build a scalable product.
If you learn SQL using Oracle, which cover most of the syntax, then you will be proficient in SQL and can easily work on other tools too (for ex, MySQL and PostgreSQL).
Cons
In Oracle Data Warehouse I used to build Type 1 and Type 2 Load frequently, where I did not face any issue, so nothing to improve from a product functionality point of view.
If UI is more interactive as in Informatica, then maybe more users can start using this
Blog link must be there on one site for solving user issues.
Likelihood to Recommend
Create a whole review system that requires work table, stage table, and History table and OLAP table. In Oracle Data warehouse this is very easy, fast, and with a high user base you can get many solutions implemented by looking online. Building complete end-to-end data pipeline and updating old tables is very easy. Integration with other applications or loading data using an external API is very hassle free task.
We build a small review system where work table loaded using API and then cluster other processing stuff done on the work table and data saved to stage table and final SCD type 1 load to base table. This is ultimately used by the Operations team for solving end-user queries.
VU
Verified User
Analyst in Information Technology (5001-10,000 employees)
Oracle Autonomous Data Warehouse is used by the IT department . It is an automated version of Oracle Database. It removes the mandate layer of a database administrator to manage the database.
Pros
Out-of-the-box use
Flexibility of scaling out and in
Minimal DBA intervention required to run the system
Cons
Exposure of the OS on request basis
Delegate control of the Oracle binaries on an as-needed basis
View access of the OS which may be used for troubleshooting purposes
Likelihood to Recommend
<ul><li>Ease of use is one of the best features</li><li>Low initial investment</li><li>Better performance and highly scalable</li><li>Self correcting and automatic maintenance</li></ul>
Oracle Autonomous Data Warehouse is being used by our company to full
manage our warehouse inventory. Time that was wasted previously doing
repetitive tasks is now delegated and we did not have to worry about any
database management.
Pros
fully autonomous
Easy to use
Fast query performance
Cons
Complicated and time consuming setup
Several discovery calls are needed in order to begin process
Oracle customer service is not always responsive
Likelihood to Recommend
II would recommend Oracle Autonomous Data Warehouse to someone looking to fully automate the transferring of data especially in a warehouse scenario though I can see the elasticity of the suite that is offered and can see it is applicable in other scenarios not just warehouses.
I'm using the a Free Tier [Oracle] Autonomous Data Warehouse in a PoC / Test environment to centralize information from a wide range of sources in order to allow quick Reporting and OLAP analysis of data coming from our suite of tolling software. I'm integrating information from more than 30 databases (20 SQL Server, 5 Oracle and other like Postgres). This POC will try to demonstrate the ease of use and maintenance of Autonomous databases so we can recommend them to our customers.
Pros
Simple and quick provisioning and configuration
Really good and fast ETL features allow quick data load
Always pached, always available. Foerget about many tedious admin tasks
Cons
Pricing may we high when using all features
Likelihood to Recommend
It's great if you are already using othe Oracle Cloud products. It is really simple to integrate with them. We plan to use it as a central datawarehous hosting data from many different data sources.
<h3><span style="font-size: 15px; color: rgb(21, 21, 33); font-family: "Source Sans Pro", sans-serif; font-weight: 500;">One of the biggest challenge is the scaling and provisioning of hardware & software for any data ware house solution and also the associate problems like configuration, security and importantly tuning of the storing and fetching/querying data. For the same reason Oracle Autonomous Data Warehouse tool used for one of the project for the customer. It help overcome some of critical, complex, manual and time consuming tasks like hardware procurement, configuration, security, high availability and high performance all this with reducing administrative cost and no human error.</span></h3>
Pros
Scale Up & Down as you need to reduce the cost immediately.
Save lots of time and costs, helped project delivery in less time which is a big plus for customer and vendor. Also, saving administrative cost.
Performance Tuning, security, backup and high availability.
Combine the abilities of a data lake and a data warehouse to manage any data type for business analysis.
Cons
The analytics come with it to code collaboratively with the rest of your team, not the classic data miner GUI interface.
Due to security limitations, neither the powerful GUI development environment Application Express (yet?) nor Oracle R Enterprise are not available.
Likelihood to Recommend
[Oracle Autonomous Data Warehouse] is well suited in most of case when it comes to save time, cost, quick project delivery, over the cloud and instant scale up and down features. I would not say scenarios where it is less appropriate, it always with anything which comes news have some features missing or not available as of time, you can find ways for better analytics or other ways than no support for R language.
A manufacturing company recently asked my company to do a Business Intelligence project to improve and standardize the analysis of its users. Before the project, users used spreadsheets and local databases based on Access to perform management analysis.
For the project, we proposed them an Oracle cloud full-stack architecture based on:
<ul><li>Object storage</li><li>Oracle Autonomous Data Warehouse</li><li>Oracle Analytics cloud</li></ul>After a first as-is analysis, the project steps have been:
<ul><li>Export of data from the company ERP on flat files</li><li>Creation of a staging area layer</li><li>Creation of PL/SQL procedures to import files on staging structures, performing formal checks, cleaning and standardization processes</li><li>Creation of entity-relation models for some Data Marts</li><li>Creation of ETL flows to load data from the staging area on the Data Marts</li><li>Creation of a series of institutional reports, based on Data Marts</li><li>Profiling of users to access to the reporting layer and for free ad hoc analysis</li></ul>The project has recently been deployed and the architecture is currently being used by about fifty users.
Pros
It's really fast to set up (like 2 minutes to create a new database)
It's cheap, and its costs are based on dedicated resources (RAM and CPUs), and it can eventually be turned off
Resources (RAM and CPUs) can be increased or decreased at run-time
Patching and release upgrades are automatically performed by Oracle at scheduled times
It's secure, without the need to implement a VPN: it provides a wallet that includes encryption methods for authentication
It automatically extracts statistics (needed by Oracle database engine to improve performances) on its structures
Backups are automatically performed and very easy to restore
Disaster recovery is granted thanks to fault domains provided by Oracle
Cons
It's really limited from a DBA point of view
There is only 1 tablespace associated to all the users you create on the database
The cost (license and monthly fees) are not always very clear
The loading of data on the cloud is subjected to network speed, so huge amounts of data may take a lot of time to be loaded on the database
Likelihood to Recommend
Oracle Autonomous Data Warehouse is particularly well suited for small or medium-sized companies that are evaluating a new database for reporting goals or for creating a common data access point for the whole enterprise.
It's probably less suited for very big companies with huge amounts of data, for network latency in moving data through the network, or for companies that already have very big Data Warehouse on-premise, and want to migrate it into the cloud, since Autonomous database has some limitations.
