Compare Oracle Database Appliance vs. Snowflake
Quotes From Members
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros | |
"The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance." "The solution is simple to use and easy to maintain." "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 most valuable feature is the performance." "The database is solid." "The solution is pretty automated, which takes out the possibility of human error." | "As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes." "The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications." "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." "The initial setup is straightforward. You just need to follow the documentation." "The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services." "It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL." "I like the idea that you can assign roles and responsibilities, limiting access to data." "The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes." |
Cons | |
"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." "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." "In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution." "We would like the ability to add more storage without having to upgrade to Oracle Exadata." "Oracle could improve its capacity for built-in visualization." "The product is quite complex to set up, initially. It would be ideal if it was simpler." | "There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source." "Support needs improvement, as it can take several days before you get some initial support." "The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template." "The solution could improve the user interface and add functionality to the system." "Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway." "They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in." "If you go with one cloud provider, you can't switch." "Availability is a problem." |
Pricing and Cost Advice | |
Information Not Available | "Pricing can be confusing for customers." "The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year." "You pay based on the data that you are storing in the data warehouse and there are no maintenance costs." "It is not cheap." "The pricing for Snowflake is competitive." "On average, with the number of queries that we run, we pay approximately $200 USD per month." "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month." "The price of Snowflake is very reasonable." |
 Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs. 457,459 professionals have used our research since 2012. | |
Questions from the Community | |
Ask a question Earn 20 points | Top Answer: Apache Hadoop is for data lake use cases. But getting data out of Hadoop for meaningful analytics is indeed need quite an amount of work. by either using spark/Hive/presto and so on. The way i look at… more » Top Answer: The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes. Top Answer: Basically, it is not cheap. |
Ranking  | |
Views 4,188 Comparisons 2,817 Reviews 6 Average Words per Review 562 Rating 8.5 | Views 30,694 Comparisons 20,985 Reviews 21 Average Words per Review 531 Rating 8.2 |
Popular Comparisons | |
 Compared 84% of the time.  Compared 4% of the time.  Compared 3% of the time.  Compared 3% of the time. Compared 2% of the time. |  Compared 40% of the time.  Compared 7% of the time.  Compared 7% of the time.  Compared 6% of the time.  Compared 6% of the time. |
Also Known As | |
| X5-2 | Snowflake Computing |
Learn | |
| Oracle | Snowflake Computing |
Overview | |
The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size. Optimized for the world's most popular database--Oracle Database--it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, and data warehousing applications. All hardware and software components are engineered and supported by Oracle, offering customers a reliable and secure system with built-in automation and best practices. In addition to accelerating the time to value when deploying database solutions, the Oracle Database Appliance offers flexible Oracle Database licensing options and reduces operational expenses associated with maintenance and support. | Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed. |
Offer | |
Learn more about Oracle Database Appliance | Learn more about Snowflake |
Sample Customers | |
| LifeLock, Incarlopsa, Al Yusur Industrial Contracting | Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops |
Top Industries | |
Comms Service Provider33% Financial Services Firm22% Transportation Company11% Marketing Services Firm11% Computer Software Company45% Comms Service Provider16% Financial Services Firm8% Government4% | Computer Software Company30% Manufacturing Company20% Financial Services Firm20% Media Company10% Computer Software Company33% Comms Service Provider15% Financial Services Firm7% Media Company5% |
Company Size | |
Small Business42% Midsize Enterprise16% Large Enterprise42% | Small Business30% Midsize Enterprise19% Large Enterprise52% Small Business5% Midsize Enterprise18% Large Enterprise77% |
Find out what your peers are saying about Oracle Database Appliance vs. Snowflake and other solutions. Updated: January 2021.
457,459 professionals have used our research since 2012.
Oracle Database Appliance is ranked 8th in Data Warehouse with 6 reviews while Snowflake is ranked 1st in Data Warehouse with 21 reviews. Oracle Database Appliance is rated 8.6, while Snowflake is rated 8.2. The top reviewer of Oracle Database Appliance writes "Affordable, user-friendly, and offers good technical support". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, SAP BW4HANA, IBM Integrated Analytics System and IBM Netezza Performance Server, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Firebolt, Amazon Redshift, Vertica and Teradata. See our Oracle Database Appliance vs. Snowflake report.
See our list of best 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.