2019-04-29T15:06:00Z
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
  • 0
  • 3

What advice do you have for others considering Oracle Autonomous Data Warehouse?

If you were talking to someone whose organization is considering Oracle Autonomous Data Warehouse, what would you say?

How would you rate it and why? Any other tips or advice?

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

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.

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 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_user1182006 - PeerSpot reviewer
Principal Consultant at DXC
Real User
2020-07-16T06:21:09Z
Jul 16, 2020

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.

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

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.

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

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.

MichaelBeeck - PeerSpot reviewer
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.

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

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.

BenjaminArnulf - PeerSpot reviewer
Senior Director BI & Analytics at Hertz Global Holdings, Inc.
Real User
2019-04-29T15:06:00Z
Apr 29, 2019

Amazing performance. It's a revolution.

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.