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 ease of setup is an eight out of ten."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"The business intelligence is very good."
"It is a highly relevant option with extreme performance."
"Oracle Exadata has very good hardware."
"The most valuable feature is the time to solution."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"The tool's performance is good."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"The product's initial setup phase is extremely simple."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"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."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"I like the projection feature, which increases query performance."
"The extensibility and efficiency provided by their C++ SDK."
"Partition and join back to node are easy and simple for DBAs."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"We used the support from Oracle Exadata to complete the implementation."
"We had issues with system restoration."
"I would like to see more database features and maybe more archiving features, because we need to do data archiving."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"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."
"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."
"Limitations in group by projections is where I would like to see an improvement."
"Suboptimal projection design causes queries to not scale linearly."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"It should provide a GUI interface for data management and tuning."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The integration of this solution with ODI could be improved."
"They could improve on customer service."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
Oracle Exadata is ranked 2nd in Data Warehouse with 124 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Oracle Exadata is rated 8.4, while Vertica is rated 8.2. The top reviewer of Oracle Exadata writes "Offers a variety of valuable features". 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.