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."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."
"The storage capacity and the performance of Oracle Exadata are good. When comparing the performance to other technologies it is very good. I am satisfied with the management of the solution."
"The ease of setup is an eight out of ten."
"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."
"Compression is a great feature, where one can really save a lot of storage."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"It is the best solution for OLTP and data warehousing."
"Oracle has reliable solutions and this one is no different."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The most valuable feature of Vertica is the unmatchable database performance."
"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."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"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 have found Oracle Exadata to be scalable. However, you have to purchase more hardware, such as memory."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"The cost of the solution is high and can be improved."
"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."
"The integration with third-party applications regarding access management security could be better."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"Tech support sometimes takes some time to identify and rectify issues."
"Limitations in group by projections is where I would like to see an improvement."
"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."
"Support is an area where it could get better."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"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."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"They could improve the integration and some of the features in the cloud version."
"It needs integration with multiple clouds."
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.