We performed a comparison between Oracle Autonomous Data Warehouse and Oracle Big Data Appliance based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It is a stable and scalable solution."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The solution integrates well with Power BI."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"A very good integration feature that restricts access to unauthorized people."
"The performance and scalability are awesome."
"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"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."
"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."
"The solution lacks visibility options."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"The installation process is complex. Oracle can make the installation process better."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"A lot of the tools that were previously there have now been taken away."
"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."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"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."
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 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.