2019-04-29T15:06:00Z

What advice do you have for others considering Oracle Autonomous Data Warehouse?

Julia Miller - PeerSpot reviewer
  • 0
  • 1
PeerSpot user
15

15 Answers

GM
Real User
Top 5
2023-12-29T12:03:26Z
Dec 29, 2023

I recommend it, mainly because we don't need to work on configuration compared to others. There is no need for those manual setup steps. However, users should be aware of potential file strategy differences and some technical nuances versus other data warehouses. Overall, though, it's a smooth transition. Configuration and administrative side? I would rate it as nine and a half out of ten. But for development, data fetching, fixing, and applying algorithms, I would rate it a seven out of ten due to compatibility issues, extra coding, and other needs. Performance tuning, however, shines at eight to eight and a half! It automatically indexes and tunes based on my tables, saving me loads of work.

Search for a product comparison
CS
Real User
Top 20
2023-10-30T11:39:50Z
Oct 30, 2023

We provide technical support to our customers. Overall, I rate the solution a seven out of ten.

Miodrag Milojevic - PeerSpot reviewer
Real User
Top 5Leaderboard
2023-07-25T11:41:55Z
Jul 25, 2023

To those planning to use the product, I would say that if your implementation is not so complex, and if you don't have the knowledge, experience, and people who can help with the product, you can use this in this simple way. You will have to spend more on CPU units and disk space to get the desired results from Oracle Autonomous Data Warehouse. You will spend on storage costs. If you know the tool, then you can use it in a different way, which might not be through a completely automatized approach, but by using different physical designers. If you know the tool, you can use it more efficiently to get better performance and make better use of storage, making it more efficient and cheaper. Oracle Autonomous Data Warehouse is based on Oracle Exadata in the background, because of which one can't see it directly. The capabilities of Oracle Exadata in regard to large clusters is like some usual cloud database from Oracle which makes it very easy for some basic setup processes. The product's compatibility is better than Redshift or other solutions for somebody who knows how to use it. The costs attached to the solution can be lowered if you know how to use it. For some serious implementation, Oracle Autonomous Data Warehouse is a good tool since it is not a product for playing around with or for small companies, as it can be very expensive. For some larger companies and some serious implementations, they should take Oracle Autonomous Data Warehouse into account and compare it with other cloud solutions and see what is more suitable for them. Most of the solutions are comparable to each other. It all depends on what is better for some customers and which technology a customer prefers. The good part of Oracle Autonomous Data Warehouse is that there is no dependency on the amount of data written or read from the cloud. When you use some other cloud solution, you don't pay only for data storage on the cloud, but also you pay for the data written or read from the cloud. Every time you write or read data on the cloud, it gets counted. You pay for the throughput or transfer of data from one cloud to another cloud. In the case of Oracle Autonomous Data Warehouse, you don't have to pay. Overall, I rate the solution a nine or ten out of ten.

KM
Real User
Top 10
2023-06-23T19:05:17Z
Jun 23, 2023

It is a top-notch product. I rate the overall product a ten out of ten.

JB
Real User
Top 20
2023-04-11T03:26:16Z
Apr 11, 2023

I rate the solution as an eight.

MJ
Real User
Top 20
2022-11-08T09:51:56Z
Nov 8, 2022

I rate this solution eight out of 10.

Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Abhik Ray - PeerSpot reviewer
Real User
Top 5
2022-07-18T07:43:11Z
Jul 18, 2022

I would rate it a seven out of ten.

KopanoRamaphoi - PeerSpot reviewer
Real User
Top 10
2021-03-16T21:03:37Z
Mar 16, 2021

Overall, I am quite happy with this product. I recommend it to my customers and I will continue recommending it to others. I would rate this solution a ten out of ten.

JA
Real User
2021-02-22T21:55:48Z
Feb 22, 2021

We are customers and end-users of Oracle. We don't have a business relationship with the company. I'm not sure of which version we are using. I don't know the version number off-hand. In general, I would rate the solution seven out of ten. It's okay, however, the company has shown interest in moving away from on-premises in favor of some type of cloud solution.

it_user1182006 - PeerSpot reviewer
Real User
2020-07-16T06:21:09Z
Jul 16, 2020

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 capable tool and not have to pay for that tool if the target is an ADW database. I would rate this solution a nine out of 10.

SH
Real User
2020-05-15T22:11:00Z
May 15, 2020

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 to ADB.

JV
Real User
2020-03-05T08:39:48Z
Mar 5, 2020

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.

MB
Real User
2019-11-18T07:22:00Z
Nov 18, 2019

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.

DV
Real User
2019-05-01T21:56:00Z
May 1, 2019

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.

BA
Real User
2019-04-29T15:06:00Z
Apr 29, 2019

Amazing performance. It's a revolution.

Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and,...
Download Oracle Autonomous Data Warehouse ReportRead more