Global Head of Architecture at a financial services firm with 1,001-5,000 employees
Real User
Top 5
2024-08-15T13:25:36Z
Aug 15, 2024
I am using the most recent version of the solution. We are primarily an Oracle shop. The tool does its job. I will recommend it for OLTP. Overall, I rate the product a seven out of ten.
CTO at a hospitality company with 1,001-5,000 employees
Real User
Top 20
2024-04-02T09:38:37Z
Apr 2, 2024
There is a master data management, and there is another data management where you will ingest the data, start the calculation, and develop some dashboards. We did not cover the master data management inside Oracle Autonomous Data Warehouse. We implemented some concepts like Data Safe and have done some encryption and masking for the database with full support from Oracle Autonomous Data Warehouse. The way it was streamlined was very simple. When it's connected to the data source, it is very simple to build a pipeline through EDI and another product for the pipeline. The acting variable was the default data load, and the acting variable would be the incremental load. Sometimes, they call it delta loading, and it's acting very well with the management of the environment of the data warehouse. Since it has self-backup and self-management capabilities, we did not need a specialized person to manage the infrastructure or solution from the DBA point of view. The solution acted pretty well regarding the dashboards and building some KPI dashboards and analytics. Oracle Autonomous Data Warehouse is a scalable solution because it is cloud-based. The tool can be easily scaled up and scaled down. You can do it automatically or manually. Since it is self-tuning, you don't need to pay attention to the tuning part of Oracle Autonomous Data Warehouse. The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup. When it comes to AI, you will find it a lot on the analytics side. You will find two functionalities in the analytics. The first one is the Insights functionality, which allows you to understand your data by giving you some insights, statistics, and personal understanding of the data. The Insights functionality powered by AI will translate the data to give you the best understanding of the data. It will suggest some KPIs, dashboards, and analytics so that you don't need to pay attention to how to understand your data and from where you have to start using dashboards. This is the first part. The second part is called augmented functionality. AI can generate an automatic dashboard that best fits your visualization through this augmented functionality. Suppose you have ten columns and don't know the right dashboard or visualization you need to create. You need to right-click and go to create the best visualization. It will automatically create the best-fit visualization for you. AI is managing insights and augmented functionality for the solution. This will eliminate the need for business users to have IT staff or specialists to develop dashboards or visualization. They can do it and discover the data by themselves. I would not recommend the solution for public sector companies in the Gulf region that have problems with compliance. You need to comply with the compliance for the cloud providers. They don't want to host their data on the cloud. They need it to be on-premises. Oracle Autonomous Data Warehouse is not available as an on-premises solution. You have to use another solution, such as an enterprise database. This is a major challenge, but it is also a general challenge in the Gulf region. The second challenge is that Oracle Autonomous Data Warehouse doesn't want to host its data outside its data center. Oracle Autonomous Data Warehouse is a scalable solution. If you read the Oracle roadmap, you will find that they are taking steady steps to make it the best solution globally. Whatever you need for your journey to build a data warehouse solution or analytics side, you will find a roadmap or alternative solutions through the OCI in general. Suppose you need to deal with a data lake at a specific time. You will find a data lake inside OCI and integrate it with Oracle Autonomous Data Warehouse. Suppose you need some Cloudera components for a specific case. Within six hours to one day, you can easily configure the Cloudera environment and do some pipeline or streaming from Kafka or HDFS from the Hadoop platform powered by Cloudera. I believe that it is very scalable. Oracle has very good capabilities when it comes to data warehouse and data management in general. Oracle is the best database in the world. Oracle Autonomous Data Warehouse is nothing but a relational database. I would recommend the solution to other users. Overall, I rate the solution ten out of ten.
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: November 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 am using the most recent version of the solution. We are primarily an Oracle shop. The tool does its job. I will recommend it for OLTP. Overall, I rate the product a seven out of ten.
There is a master data management, and there is another data management where you will ingest the data, start the calculation, and develop some dashboards. We did not cover the master data management inside Oracle Autonomous Data Warehouse. We implemented some concepts like Data Safe and have done some encryption and masking for the database with full support from Oracle Autonomous Data Warehouse. The way it was streamlined was very simple. When it's connected to the data source, it is very simple to build a pipeline through EDI and another product for the pipeline. The acting variable was the default data load, and the acting variable would be the incremental load. Sometimes, they call it delta loading, and it's acting very well with the management of the environment of the data warehouse. Since it has self-backup and self-management capabilities, we did not need a specialized person to manage the infrastructure or solution from the DBA point of view. The solution acted pretty well regarding the dashboards and building some KPI dashboards and analytics. Oracle Autonomous Data Warehouse is a scalable solution because it is cloud-based. The tool can be easily scaled up and scaled down. You can do it automatically or manually. Since it is self-tuning, you don't need to pay attention to the tuning part of Oracle Autonomous Data Warehouse. The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup. When it comes to AI, you will find it a lot on the analytics side. You will find two functionalities in the analytics. The first one is the Insights functionality, which allows you to understand your data by giving you some insights, statistics, and personal understanding of the data. The Insights functionality powered by AI will translate the data to give you the best understanding of the data. It will suggest some KPIs, dashboards, and analytics so that you don't need to pay attention to how to understand your data and from where you have to start using dashboards. This is the first part. The second part is called augmented functionality. AI can generate an automatic dashboard that best fits your visualization through this augmented functionality. Suppose you have ten columns and don't know the right dashboard or visualization you need to create. You need to right-click and go to create the best visualization. It will automatically create the best-fit visualization for you. AI is managing insights and augmented functionality for the solution. This will eliminate the need for business users to have IT staff or specialists to develop dashboards or visualization. They can do it and discover the data by themselves. I would not recommend the solution for public sector companies in the Gulf region that have problems with compliance. You need to comply with the compliance for the cloud providers. They don't want to host their data on the cloud. They need it to be on-premises. Oracle Autonomous Data Warehouse is not available as an on-premises solution. You have to use another solution, such as an enterprise database. This is a major challenge, but it is also a general challenge in the Gulf region. The second challenge is that Oracle Autonomous Data Warehouse doesn't want to host its data outside its data center. Oracle Autonomous Data Warehouse is a scalable solution. If you read the Oracle roadmap, you will find that they are taking steady steps to make it the best solution globally. Whatever you need for your journey to build a data warehouse solution or analytics side, you will find a roadmap or alternative solutions through the OCI in general. Suppose you need to deal with a data lake at a specific time. You will find a data lake inside OCI and integrate it with Oracle Autonomous Data Warehouse. Suppose you need some Cloudera components for a specific case. Within six hours to one day, you can easily configure the Cloudera environment and do some pipeline or streaming from Kafka or HDFS from the Hadoop platform powered by Cloudera. I believe that it is very scalable. Oracle has very good capabilities when it comes to data warehouse and data management in general. Oracle is the best database in the world. Oracle Autonomous Data Warehouse is nothing but a relational database. I would recommend the solution to other users. Overall, I rate the solution ten out of ten.
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.