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."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 business intelligence is very good."
"Exadata with the In-Memory option is several levels about SAP HANA."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"Oracle Exadata has very good hardware."
"The offloading of data to the SIM is a valuable feature."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"The most valuable feature of Vertica is the unmatchable database performance."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"The most valuable feature is Vertica's performance and the ease of using the database."
"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 is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The solution is quick, has good compression data, and is not expensive."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"Checking the Smart Scan issues is complicated."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"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 scalability can be improved as it is not a parallel execution."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"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."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"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."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
"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."
"The documentation of Vertica is an area with shortcomings where improvements are required."
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.