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."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."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"Compression is a great feature, where one can really save a lot of storage."
"The most valuable feature is the time to 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."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"The offloading of data to the SIM is a valuable feature."
"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."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Speed and resiliency are probably the best parts of this product."
"The scalability can be improved as it is not a parallel execution."
"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."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"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."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"The management monitoring tools are quite important and an area that needs some improvement."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"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."
"The biggest problem is the cost of cloud deployment."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Documentation has become much better, but can always use some improvement."
"The geospatial functionality could be designed better."
"We faced some challenges when trying to use the temporary tables feature."
"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."
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.