Oracle Autonomous Data Warehouse Reviews

Our primary use case of this solution is as a data management system for analytics.

I really like the auto-tuning, auto-scaling, automatic load balancing, and query tuning in the system.

The solution is very stable.

The technical support is quick to answer but sometimes it takes too long to get a competent person on the line.

If you are familiar with Oracle products, the initial setup is easy and straightforward. The deployment took only a few hours because it is on the cloud.

Other options out there are Microsoft Azure Data Warehouse and AWS Redshift. Anyone who has to deal with analytics, to get the processes, marketing processes, and financial processes working, should consider a data warehouse solution because a data warehouse solution is always the underlying infrastructure for good analytics.

I would like to see an on-premise solution in the future. There are other very good solutions in the market, so if I would rate it a ten, it would be the best in the market. I, therefore, rate this solution an eight out of ten. 

We evaluated Oracle Autonomous Data Warehouse for use in a client project. We were among the first to try out this solution.

I was able to set up a data warehouse very quickly. For a pilot project, I didn't want to get into a complicated scenario of determining indexes and partition strategies. I just wanted to load my data and go. Oracle ADW worked very well in this regard.

I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.

Existing Oracle customers interested in the Autonomous Data Warehouse should know that this is a different experience than the classic Oracle DB Enterprise Edition. Yes, this is a database capable of running an entire enterprise, with unparalleled performance, available disaster recovery, and cutting-edge analytics. But the analytics come with new Notebook technology to code collaboratively with the rest of your team, not the classic data miner GUI interface. Don't expect to tune your queries with various indexes and fancy partitioning strategies. The system is designed to run on autopilot, not be carefully controlled and highly tuned. And, due to security limitations, neither the powerful GUI development environment Application Express (yet?) nor Oracle R Enterprise are not available. Hopefully these features can be added in a future release and the system can be accessed more easily without compromising the database's security.

I have previously built Oracle databases. I wanted to try out the autonomous database to save on database setup time.

I would recommend to fully utilize Oracle's trial service. It's a good way to try it out first.

Be aware that you still have to define your "schema". You still define the columns in each table. This is a necessary step. It would be great if Oracle added a wizard that takes data and "figures out" what the column names are (e.g. perhaps noticing that Boston, Los Angeles, New York could be a CITY column). This would be in line with making it "autonomous".  Maybe it's there and I don't know how to make that happen.

We implemented Oracle Autonomous Data Warehouse in Oracle Cloud with Oracle Analytics on top of financial and procurement data.

Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large financial data sets. The data warehouse offers amazing performance.

The three top features for us are:

• Self-tuning
• Self-securing
• Self-patching

On top of it, you can create an instance in three minutes and use it with Oracle Analytics.

An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud. Basically, the autonomous data warehouse can only be reached using the public network which is not ideal for some companies. We usually use private network and need private IP to include it into our subnet.

We do not need more for now, it's working perfectly. I know Oracle is working on a solution.

Stable, perfectly tuned, nothing to do.

We have had an amazing experience with technical support. Oracle has been helping us as we were almost the first to adopt it.

We tested different databases and vendors, but we needed extreme performance and a managed solution.

The initial setup for this solution is straightforward, with almost nothing to do. The setup is very, very fast.

We used Deloitte for implementation and deployment.

The cost is perfect with Oracle Universal credit.

The products that we evaluated before choosing this solution were:

• Redshift
• Oracle DBaaS
• Tableau Extract

Amazing performance. It's a revolution.