We performed a comparison between Oracle Exadata and Vertica 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 technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"The most valuable feature is the time to solution."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"It is the best solution for OLTP and data warehousing."
"Oracle Exadata is stable."
"It offers a significant advantage for accommodating a large number of users."
"The tool's performance is good."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"The solution is quick, has good compression data, and is not expensive."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Allows us to take volumes and process them at a very high speed."
"I have found the solution to be scalable."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"The handling of temp space has room for improvement."
"We have a little trepidation with the system as it does have a learning curve. Also changing to a binary logging format for us feels like retrograde motion, but sadly almost all Linux variants have moved in this direction."
"We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata."
"The integration with third-party applications regarding access management security could be better."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"The initial setup process is very difficult and extremely complex."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Documentation has become much better, but can always use some improvement."
"It should provide a GUI interface for data management and tuning."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.4. The top reviewer of Oracle Exadata writes "Very fast, scalable, stable, and demonstrates good performance". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Snowflake and Apache Hadoop, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery. See our Oracle Exadata vs. Vertica 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.