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."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."
"It offers a significant advantage for accommodating a large number of users."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"It is a highly relevant option with extreme performance."
"What I like most about Oracle Exadata is its smart scan feature. I also like that it supports higher capacities and it's high-performing, so my company can use Oracle Exadata for massive databases."
"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."
"Oracle Exadata is stable."
"The product is flexible."
"Eighty percent of the ETL operations have improved since implementing this solution."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Partition and join back to node are easy and simple for DBAs."
"The product's initial setup phase is extremely simple."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions."
"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 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 could improve the platform performance tuning should be easier, automated, and user-friendly."
"Since the product is an appliance, it is very costly."
"The customization can sometimes be difficult to achieve."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"The handling of temp space has room for improvement."
"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."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Limitations in group by projections is where I would like to see an improvement."
"I believe the installation process could be streamlined."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"They could improve the integration and some of the features in the cloud version."
"I have found that coding support could be simplified."
Oracle Exadata is ranked 2nd in Data Warehouse with 25 reviews while Vertica is ranked 4th in Data Warehouse with 10 reviews. Oracle Exadata is rated 8.4, while Vertica 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 Vertica writes "Reliable and feature-rich, with optimization techniques to fine-tune queries for faster report generation". 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.