We performed a comparison between Oracle Autonomous Data Warehouse and Oracle Big Data 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."
"A very good integration feature that restricts access to unauthorized people."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"It is a stable and scalable solution."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The solution integrates well with Power BI."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"This is a comprehensive solution that is easy to deploy."
"A lot of the tools that were previously there have now been taken away."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"I would like to see an on-premise solution in the future."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The product should be simplified for the average user."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
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 Big Data Appliance is ranked 14th in Data Warehouse with 5 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Oracle Big Data 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 Big Data Appliance writes "Fast, and you don't need technical expertise to use it and produce results". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Microsoft Azure Synapse Analytics and Teradata. See our Oracle Autonomous Data Warehouse vs. Oracle Big Data 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.