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."We primarily use it for OLTP, which has improved our costs."
"The most valuable feature is the performance."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"We use the solution for our Java applications."
"The product is good value for money. It is a secure solution."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"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 solution is pretty automated, which takes out the possibility of human error."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"Scaling is a big plus point of Snowflake."
"It is very fast and the performance is great."
"The solution is very stable."
"Snowflake's most valuable features are data enrichment and flattening."
"The product's most important feature is unloading data to S3."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"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."
"I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"Oracle could improve its capacity for built-in visualization."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"The price could be improved."
"The documentation could improve. They should provide architecture information."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"The cost of the solution could be reduced."
"There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
Oracle Database Appliance is ranked 6th in Data Warehouse with 40 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.