Data Architect at a computer software company with 51-200 employees
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.
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.
Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
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.
Head of Data and Analytics at a financial services firm with 10,001+ employees
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'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.
CTO at a tech services company with 51-200 employees
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.
Technology Evangelist, CTO, Entrepreneur with 1-10 employees
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.
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.
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,...
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.
We provide technical support to our customers. Overall, I rate the solution a seven out of ten.
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.
It is a top-notch product. I rate the overall product a ten out of ten.
I rate the solution as an eight.
I rate this solution eight out of 10.
I would rate it a seven out of ten.
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.
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'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.
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.
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.
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.
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.
Amazing performance. It's a revolution.