We performed a comparison between Oracle Database Appliance and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The tool is a specific and effective system. I am impressed with its usability."
"Oracle has good technical support."
"The most valuable features of the solution revolve around its performance, simplicity, and its installation phase."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The solution is pretty automated, which takes out the possibility of human error."
"If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime."
"The product is good value for money. It is a secure solution."
"The solution is simple to use and easy to maintain."
"The initial setup is very simple."
"It is very fast and the performance is great."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"The initial setup is straightforward. You just need to follow the documentation."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"For us, the virtual warehousing is likely the most valuable aspect."
"Oracle could improve its capacity for built-in visualization."
"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."
"They could incorporate a more secure and internet-centric management system for the platform."
"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"The product's technical support services need improvement."
"The product's performance could be improved."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"This solution could be improved by offering machine learning apps."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Oracle Database Appliance is rated 8.0, while Snowflake is rated 8.4. The top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our Oracle Database Appliance vs. Snowflake report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.