Oracle Autonomous Data Warehouse Other Advice

Miodrag Milojevic - PeerSpot reviewer
Senior Data Archirect at Yettel

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.

View full review »
KM
Global Head of Architecture at a financial services firm with 1,001-5,000 employees

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

View full review »
BA
Senior Director BI & Analytics at Hertz Global Holdings, Inc.

Amazing performance. It's a revolution.

View full review »
Buyer's Guide
Oracle Autonomous Data Warehouse
April 2024
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.
GM
Data Architect at a computer software company with 51-200 employees

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. 

View full review »
DV
President at Vlamis Software Solutions

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.

View full review »
JB
Senior Data Warehouse Developer at a transportation company with 5,001-10,000 employees

I rate the solution as an eight.

View full review »
it_user1182006 - PeerSpot reviewer
Principal Consultant at DXC

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. 

View full review »
CS
Digital Project Delivery Manager at a computer software company with 51-200 employees

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

View full review »
MJ
Research Analyst

I rate this solution eight out of 10. 

View full review »
Abhik Ray - PeerSpot reviewer
Co-Founder at Quantic

I would rate it a seven out of ten.

View full review »
KopanoRamaphoi - PeerSpot reviewer
Consultant at Rpc Data

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.

View full review »
JA
Head of Data and Analytics at a financial services firm with 10,001+ employees

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.

View full review »
SH
CTO at a tech services company with 51-200 employees

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.

View full review »
JV
IT Administrator at Unior d.d.

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.

View full review »
MB
Technology Evangelist, CTO, Entrepreneur with 1-10 employees

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. 

View full review »
Buyer's Guide
Oracle Autonomous Data Warehouse
April 2024
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,415 professionals have used our research since 2012.