Oracle Autonomous Data Warehouse can be useful for data warehousing. It's easier to do setup and maintenance compared to Oracle Exadata. For some users, if it is satisfying, they can use it very easily because you don't have to do anything, including any kind of streaming or special kind of physical design for most of the use cases, making it easy to use. It is very easy to expand and allocate dynamic resources because you can use some processing units of Oracle which are virtualized. In the product, considering the processor power and memory, you can easily add processing units to make your system more powerful, which can be planned. For working hours, you can use as many processing units of Oracle, while later, you can reduce its use. For test purposes, you can use fewer processing units of Oracle on the platform, and you can switch it off and activate it only when you need to develop something. The processing units are very flexible. Using the tool means payment for resources has to be made. The tool makes it very easy to use the space provided in the product because you can add one terabyte or gigabyte to your space. For somebody who knows how to use the features of the tool and go deep into its physical design, everything becomes available, including Oracle Exadata on Oracle Autonomous Data Warehouse. So people who are experienced and know Oracle Autonomous Data Warehouse can use the product to improve performance and do better design, making it more efficient. Somebody who doesn't know how to use the tool and does not have people to help can use it with a much simpler approach.

Mostly, we use it in our company for online transaction systems.

We implemented Oracle Autonomous Data Warehouse in Oracle Cloud with Oracle Analytics on top of financial and procurement data.

The solution can be used for many things, including:

• Data storage
• Analytical transactions 
• Provisioning for the Oracle Autonomous Database
• Connecting to Oracle Autonomous Database
• Use with JDeveloper
• Use with Eclipse IDE
• Use with Toad for Oracle
• Use with Oracle SQL Developer
• Use with Oracle Data Pump
• Migrating Amazon Redshift to Oracle Autonomous Database
• Migrating Amazon Aurora to Oracle Autonomous Database
• Migrating Amazon RDS to Oracle Autonomous Database
• Use with Oracle Data Integrator
• Use with Oracle Analytics Cloud
• Use with REST APIs

We evaluated Oracle Autonomous Data Warehouse for use in a client project. We were among the first to try out this solution.

Oracle Autonomous is a self-repairing version or cloud-based version of the Oracle Database. I typically use the new Data Warehouse capacity so I'll use it if I'm building anything connected to finance, HR, plus any of the standard business products. We also use it for other Oracle products if they're cloud-based; such as with ACM and all their other ERP tools, where the data resides on ADW. We're a consultancy so we partner with Oracle as well as other companies. I'm the principal consultant of the company. 

We have a number of clients that are universities. They use the solution for student management. We also have clients in transport, banking, and science domains.

I'm a research analyst and we are customers of Oracle. 

It is used by banking customers. Oracle is strong in banking, and many of their existing customers do use or continue to use Oracle solutions.

This solution is used for bigger projects that involve a large number of transactions. For companies with these requirements, it is perfect.

At this point, we don't have any customers on this platform because, unfortunately, in our country, we are still lagging behind when we talk about the cloud.

We used to report all reports from Oracle. We centralized all the connections in the data warehouse, and we have a business intelligence team that makes all the reports for the company. The database connects with Power BI to show the dashboard to the management team.

Oracle offers this solution as Platform as a service (PaaS). The serverless option provides cost optimization to the organization where they can save huge amounts of money, but not require a highly skilled DBA to manage the database. 

Oracle controls the entire service, where a customer is only responsible for managing data. All other things are managed and maintained by Oracle. There is no billing when the service is stopped.

We're currently using the solution to move data from legacy systems to the cloud.

Our primary use case of this solution is as a data management system for analytics.