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?
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.
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.