2019-04-29T15:06:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 1
  • 42

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

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

8
PeerSpot user
8 Answers
KR
Information Technology Administrator at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
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.

Search for a product comparison
JA
Head of Data and Analytics at a financial services firm with 10,001+ employees
Real User
Top 10
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
Principal Consultant at DXC
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.

Syed Jaffar Hussain - PeerSpot reviewer
CTO at a tech services company with 51-200 employees
Real User
Leaderboard
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.

Jurij Visnar - PeerSpot reviewer
IT Administrator at Unior d.d.
Real User
Top 20
2020-03-05T08:39:48Z
Mar 5, 2020

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

MichaelBeeck - PeerSpot reviewer
Technology Evangelist, CTO, Entrepreneur with 1-10 employees
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.

Learn what your peers think about Oracle Autonomous Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,465 professionals have used our research since 2012.
DV
President at Vlamis Software Solutions
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.

BenjaminArnulf - PeerSpot reviewer
Senior Director BI & Analytics at Hertz Global Holdings, Inc.
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
SVP, Loan Accounting and Technology at PennyMac
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
Related Questions
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Jul 18, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 5 answers
it_user1182006 - PeerSpot reviewer
Principal Consultant at DXC
Jul 16, 2020
Licensing costs are typically arranged by Oracle CPU. You pay for the access and then you can scale. If you have a fairly intensive database activity, you'd scale up by CPU, and you're paying by the CPU and the uptime. So there's a marginal uptime cost. If your operations are only running 12 hours a day, you can put your database offline after that and reduce costs. If you had multiple databases supporting the same environment, let's say a development, a test, and a production, you could just turn off the development and the test when you're not fixing anything or developing, and that would reduce your costs. There is also a free version of ADW that can be accessed if you create a cloud account. I think it allows for 20MB of space that is free.
JA
Head of Data and Analytics at a financial services firm with 10,001+ employees
Feb 22, 2021
I don't handle the billing or licensing aspect of the solution. I don't have any insights into the cost of the product or how many licenses the company holds.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Jul 18, 2022
Please share with the community what you think needs improvement with Oracle Autonomous Data Warehouse. What are its weaknesses? What would you like to see changed in a future version?
2 out of 7 answers
Jurij Visnar - PeerSpot reviewer
IT Administrator at Unior d.d.
Mar 5, 2020
The solution needs to offer support for the R language. It doesn't exist and it really is something they should have. Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable. There isn't support for data migrations. It would be helpful to have more documentation or information about this process. It's not easy for us to find online or on their website.
Syed Jaffar Hussain - PeerSpot reviewer
CTO at a tech services company with 51-200 employees
May 15, 2020
An ADB serverless service provides no control over storage, host, and facilities. One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace. There are many data types and parameters which are not supported. That should be improved a bit so many customers can adopt.
Download Free Report
Download our free Oracle Autonomous Data Warehouse Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
655,465 professionals have used our research since 2012.