We performed a comparison between Oracle Autonomous Data Warehouse and Oracle Database Appliance based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The performance and scalability are awesome."
"The solution integrates well with Power BI."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"A very good integration feature that restricts access to unauthorized people."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"Oracle has good technical support."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"Oracle Database Appliance provides high stability."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"The product is very light."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"The installation process is complex. Oracle can make the installation process better."
"A lot of the tools that were previously there have now been taken away."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"The solution lacks visibility options."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"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."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"Oracle could improve its capacity for built-in visualization."
"If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this."
"Oracle's product support is an area of concern where improvements are required."
"The tool's setup can be easier."
"Even though the solution can handle a lot of data, it's just too expensive currently."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Oracle Database Appliance is rated 8.0. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". On the other hand, the top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica. See our Oracle Autonomous Data Warehouse vs. Oracle Database Appliance report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.