Oracle Autonomous Data Warehouse Reviews & Insights

Score8.2 out of 10

242 Reviews and Ratings

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.

Oracle Autonomous Data Warehouse Reviews

32 Reviews

Nice

Rating: 9 out of 10

Incentivized

March 29, 2022

Use Cases and Deployment Scope

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

Verified User

Engineer in Information Technology (1001-5000 employees)

Vetted Review

2 years of experience

A quick way to analyze your data

Rating: 9 out of 10

Incentivized

October 7, 2021

Use Cases and Deployment Scope

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.

Prashast Vaish

Decision Scientist in Information Technology at Mu Sigma Inc. (1001-5000 employees)

Vetted Review

2 years of experience

View profile

Oracle Data Warehouse provides enough functionality for basic data warehousing transformations

Rating: 8 out of 10

Incentivized

May 1, 2021

Use Cases and Deployment Scope

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.

Kate Nadolinski

Senior Consultant in Finance and Accounting at CACI International Inc (10,001+ employees)

Vetted Review

5 years of experience

View profile

New era of data warehouse

Rating: 9 out of 10

Incentivized

April 12, 2021

Use Cases and Deployment Scope

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.

Verified User

Engineer in Engineering (5001-10,000 employees)

Vetted Review

2 years of experience

Must Use Tool for any Datawarehouse Business Intelligence Developer

Rating: 8 out of 10

Incentivized

April 10, 2021

Use Cases and Deployment Scope

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.

Verified User

Analyst in Information Technology (5001-10,000 employees)

Vetted Review

4 years of experience

The future of databases

Rating: 8 out of 10

Incentivized

December 23, 2020

Use Cases and Deployment Scope

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

Ease of use is one of the best features
Low initial investment
Better performance and highly scalable
Self correcting and automatic maintenance

Jyoti Shah

OCI Architect / Peoplesoft DBA in Information Technology at Astute Business Solutions (11-50 employees)

Vetted Review

2 years of experience

View profile

Oracle Autonomous Data Warehouse An Awesome Tool That Gets Better The More Your Organization Uses It

Rating: 8 out of 10

Incentivized

December 14, 2020

Use Cases and Deployment Scope

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.

Verified User

Manager in Marketing (11-50 employees)

Vetted Review

2 years of experience

Your own Datawarehouse on a few clicks. Fast and easy to provision and configure.

Rating: 8 out of 10

Incentivized

December 13, 2020

Use Cases and Deployment Scope

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.

Lisandro Fernigrini

Database Practice Lead in Information Technology at Kapsch Trafficcom (201-500 employees)

Vetted Review

1 year of experience

View profile

First hand with Oracle Autonomous Data Warehouse

Rating: 8 out of 10

Incentivized

December 13, 2020

Use Cases and Deployment Scope

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.

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.

Krishan Mohil

Manager Tech Architect in Finance and Accounting at Accenture (10,001+ employees)

Vetted Review

2 years of experience

View profile

Oracle ADWH for manufacturing company

Rating: 9 out of 10

Incentivized

December 11, 2020

Use Cases and Deployment Scope

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:

Object storage
Oracle Autonomous Data Warehouse
Oracle Analytics cloud

After a first as-is analysis, the project steps have been:

Export of data from the company ERP on flat files
Creation of a staging area layer
Creation of PL/SQL procedures to import files on staging structures, performing formal checks, cleaning and standardization processes
Creation of entity-relation models for some Data Marts
Creation of ETL flows to load data from the staging area on the Data Marts
Creation of a series of institutional reports, based on Data Marts
Profiling of users to access to the reporting layer and for free ad hoc analysis

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.

Paolo Borghi

Oracle Business Intelligence Consultant in Information Technology at Techedge SpA (1001-5000 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

Oracle ADWH for manufacturing company

Rating: 9 out of 10

Incentivized

December 11, 2020

Use Cases and Deployment Scope

Object storage
Oracle Autonomous Data Warehouse
Oracle Analytics cloud

After a first as-is analysis, the project steps have been:

Export of data from the company ERP on flat files
Creation of a staging area layer
Creation of PL/SQL procedures to import files on staging structures, performing formal checks, cleaning and standardization processes
Creation of entity-relation models for some Data Marts
Creation of ETL flows to load data from the staging area on the Data Marts
Creation of a series of institutional reports, based on Data Marts
Profiling of users to access to the reporting layer and for free ad hoc analysis

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

Paolo Borghi

Oracle Business Intelligence Consultant in Information Technology at Techedge SpA (1001-5000 employees)

Vetted Review

2 years of experience

View profile