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."Easy management (it saves a lot of installation and patching time)."
"The database is solid."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The solution is pretty automated, which takes out the possibility of human error."
"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"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."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"Very easy to use and easy to query."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"Everything is automatic, and I don't have to do any maintenance."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"Data Science capabilities are the most valuable feature."
"It is quite easy to manage."
"In my opinion only one single command should be used for all ODA models, as it’s confusing."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"I would like it if the scalability could be increased without having to change versions."
"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 Database Appliance patching comes out two to three months after the regular patching cycle."
"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."
"Sometimes, we cannot upgrade or patch it easily. The performance needs to improve."
"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 cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
"Availability is a problem."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"It doesn't enforce typical relational database constraints. Quite expensive."
"Snowflake needs transparency over costs and pricing."
Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews while Snowflake is ranked 1st in Data Warehouse with 94 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 Data Services, 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.