Oracle Autonomous Data Warehouse Reviews

Oracle Autonomous Data Warehouse is the #5 ranked solution of our top Cloud Data Warehouse tools. It's rated 4.4 out of 5 stars, and is most commonly compared to Snowflake - Oracle Autonomous Data Warehouse vs Snowflake

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Andrew McLaren
Consultant
Principal Consultant at DXC
Jul 22 2020

What is most valuable?

I like the fact that the solution is self-patching, that it's running machine-learning generally across its logs all the time in order to identify any issues and to self-repair. It means that I don't really need a DBA for the most part. I… more »

What needs improvement?

Ease of interconnectivity could be improved by which I mean setting up the VPN access and the like from on-premises to cloud. If that was a little easier, it would certainly make my life easier.

What's my experience with pricing, setup cost, and licensing?

Licensing costs are typically arranged by Oracle CPU. You pay for the access and then you can scale. If you have a fairly intensive database activity, you'd scale up by CPU, and you're paying by the CPU and the uptime. So there's a marginal… more »

Which solution did I use previously and why did I switch?

Other solutions I use are the standard on-premise Oracle Database and Microsoft SQL. Obviously we do a lot of web development, but I use MySQL for that. The product I use at any one time depends on the client. As a consultant, I work with… more »

What other advice do I have?

It's worth looking at what Oracle has available because their ETL tool, for example, which is called ODI, Oracle Data Integration, is free if the target of the platform is Oracle ADW. So you can build an entire ETL or ODI process on a very… more »
Syed Jaffar Hussain
Real User
CTO at a tech services company with 51-200 employees
May 17 2020

What is most valuable?

ADB runs on Exadata technology, which is the proven industry best solution for any kind of workloads. Besides, ADB provides complete automated features, such as, self patching, upgrade, tuning… more »

How has it helped my organization?

The solution really helps to test our new applications, do modifications and updates with minimal costs and no HW requirements. Autonomous Database (ADB) provides a highly scalable, secured platform… more »

What needs improvement?

An ADB serverless service provides no control over storage, host, and facilities. One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace… more »

Which solution did I use previously and why did I switch?

We were using on-premises databases for testing new application functionality. This was causing a lot of cost to the organization.

What other advice do I have?

I highly recommend it for companies who want to test their application functionality, dev, or test DBs for cost optimization. With existing DBA knowledge, it is easy to manage and migrate a database… more »

Which other solutions did I evaluate?

We discussed other cloud solutions, but the Oracle offering was cost optimized.
Find out what your peers are saying about Oracle, Snowflake Computing, Microsoft and others in Cloud Data Warehouse. Updated: August 2020.
438,560 professionals have used our research since 2012.
Dan Vlamis
Real User
President at Vlamis Software Solutions
May 16 2019

What is most valuable?

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

How has it helped my organization?

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… more »

What needs improvement?

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… more »

What's my experience with pricing, setup cost, and licensing?

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

Which solution did I use previously and why did I switch?

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

What other advice do I have?

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"… more »
Real User
IT Administrator at a manufacturing company with 1,001-5,000 employees
Mar 07 2020

What is most valuable?

The analytics have been very good. We've found them to be quite useful.

What needs improvement?

The solution needs to offer support for the R language. It doesn't exist and it really is something they should have. Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable. There isn't support for data migrations. It would be helpful to have more documentation or information about this process. It's not easy for us to find online… more »

What other advice do I have?

I'm not sure if I'm capable of giving advice to anyone as it's a solution that's so new to us still. I'd rate the solution seven out of ten.
BenjaminArnulf
Real User
Senior Director BI & Analytics at Hertz Global Holdings, Inc.
May 02 2019

What is most valuable?

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… more »

How has it helped my organization?

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

What needs improvement?

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… more »

What's my experience with pricing, setup cost, and licensing?

The cost is perfect with Oracle Universal credit.

Which solution did I use previously and why did I switch?

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

What other advice do I have?

Amazing performance. It's a revolution.

Which other solutions did I evaluate?

The products that we evaluated before choosing this solution were: * Redshift * Oracle DBaaS * Tableau Extract
MichaelBeeck
Real User
Technology Evangelist, CTO, Entrepreneur with 1-10 employees
Nov 18 2019

What is most valuable?

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

What other advice do I have?

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.

Which other solutions did I evaluate?

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.

What is Oracle Autonomous Data Warehouse?

Autonomous Data Warehouse is market-leading Oracle Database software running on proven Oracle Exadata infrastructure that is optimized to deliver unbeatable performance for data warehouse workloads. Built-in adaptive machine learning eliminates manual labor for administrative management. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes.

Oracle Autonomous Data Warehouse customers
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
BUYER'S GUIDE
Download our free Cloud Data Warehouse Report and find out what your peers are saying about Oracle, Snowflake Computing, Microsoft, and more!