2019-04-29T15:06:00Z

What is your primary use case for Oracle Autonomous Data Warehouse?

Miriam Tover - PeerSpot reviewer
  • 1
  • 57
PeerSpot user
14

14 Answers

CS
Real User
Top 20
2023-10-30T11:39:50Z
Oct 30, 2023

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.

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

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.

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

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

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

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

Abhik Ray - PeerSpot reviewer
Real User
Top 5
2022-07-18T07:43:11Z
Jul 18, 2022

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.

DV
Real User
2021-10-27T15:28:00Z
Oct 27, 2021

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

Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
KopanoRamaphoi - PeerSpot reviewer
Real User
Top 10
2021-03-16T21:03:37Z
Mar 16, 2021

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.

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

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.

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

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.

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

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.

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

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

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

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

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

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

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

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

RN
User
Nov 11, 2020

@BenjaminArnulf We have both Oracle ERP and EPM cloud services, and we are in the process of evaluating OAC and Oracle DW. Did you evaluate any other solutions such as Tableau and Snowflake? What is your experience with OAC and Oracle DW? Did you hire a 3rd party consulting firm to help you implement? What business needs are you trying to solve with these solutions?

PeerSpot user
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