We performed a comparison between Oracle Exadata and Snowflake based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Snowflake wins out in this comparison, as it has a better user rating regarding both ease of deployment and pricing.
"Oracle Exadata is stable."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The performance on the databases is good."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The data replication is very good."
"The business intelligence is very good."
"A user-friendly and reliable solution."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
"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."
"The pricing is reasonable and matches the rest of the market."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"We used the support from Oracle Exadata to complete the implementation."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"I have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"There is room for improvement in Snowflake's integration with Python. We do a lot of SQL programming in Snowflake, but we go to a different tool to program when we have to in Python."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
"If they could bring in some tools for data integration, it would be really great."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"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."
"I would like to see a client version of the GUI."
Oracle Exadata allows enterprises to run any Oracle Database workload with the highest performance, scale, availability, and security on fully compatible cloud and on-premises infrastructure. Exadata uses a scale-out design with unique optimizations that include persistent memory, SQL query offload, and built-in resource management to optimize performance for OLTP, analytics, machine learning, and mixed workloads running in consolidated environments. By running hundreds or thousands of optimized Autonomous Database and Exadata Database instances on Exadata Cloud or Cloud@Customer infrastructure, customers are able to minimize their infrastructure, reduce management, improve developer productivity, and lower total costs by up to 40%, as described in Wikibon’s analysis (PDF).
The main benefit of Exadata is its speed. It hosts operating systems, CPU memory, and hard drives. It runs all types of databases, including online transaction systems, processors, and data warehouses, while remedying the poor performances of older databases.
Oracle Exadata features a simple and fast database storage system that protects and backs up your critical data. It accelerates data warehouse performance for faster access to business information and data. It is the ideal database solution for companies looking to build up their infrastructure from scratch.
Oracle Exadata Database Machine Key Benefits
Accelerate database processing: Exadata Storage Server implements a unique, highly efficient database-optimized storage infrastructure that enables Exadata’s unparalleled performance without any of the bottlenecks that traditional storage experiences. Each storage server contains CPU processors that are used to offload database processing. The CPUs in the storage servers do not replace database CPUs, but work alongside them to accelerate database workloads.
Reviews from Real Users
Oracle Exadata stands out among its competitors for a number of reasons. Two major ones are its robust performance and its wide variety of database features that make it a comprehensive database solution.
Adriano S., an IT system integrator at a financial services firm, writes, "Oracle Exadata's performance is one of its best features. We are very satisfied with it. The previous equipment used to make a payment for all the government employees used to take at least two days for some of the transactions. Now, it will take hours to make the same amount of payments. Another thing is the flexibility to organize all our databases. We can use it with new features that come with this version of Oracle 19c, which is the container database. With container databases, we can work with many databases, organized, and segregated, and still access the functions and management, the things that most of the technical people like to have in place."
Paulo X., a sales manager at LTA-RH Informatica, notes, "Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.
Its platform is made up of three components:
Snowflake has many valuable key features. Some of the most useful ones include:
There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.
Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
A Solution Architect at a wholesaler/distributor comments, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
Oracle Exadata is ranked 2nd in Data Warehouse with 22 reviews while Snowflake is ranked 1st in Data Warehouse with 50 reviews. Oracle Exadata is rated 8.4, while Snowflake is rated 8.4. The top reviewer of Oracle Exadata writes "Exadata can significantly improve performance but there's a learning curve in a few key areas". 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 Exadata is most compared with Teradata, Oracle Database Appliance, Amazon Redshift, Oracle Autonomous Data Warehouse and IBM Netezza Performance Server, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Vertica, Teradata, Amazon Redshift and SAP BW4HANA. See our Oracle Exadata 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.