Try our new research platform with insights from 80,000+ expert users

SAP HANA vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

SAP HANA
Average Rating
8.4
Reviews Sentiment
6.5
Number of Reviews
85
Ranking in other categories
Data Virtualization (2nd), Embedded Database (4th), Relational Databases Tools (4th)
Vertica
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (11th)
 

Mindshare comparison

SAP HANA and Vertica aren’t in the same category and serve different purposes. SAP HANA is designed for Embedded Database and holds a mindshare of 8.7%, down 12.4% compared to last year.
Vertica, on the other hand, focuses on Data Warehouse, holds 8.6% mindshare, down 8.7% since last year.
Embedded Database
Data Warehouse
 

Featured Reviews

Jayarami Reddy Pujeri - PeerSpot reviewer
Comprehensive system with real-time analytics for versatile industry applications
Our primary use case is working with various clients in industries such as pharmaceuticals and other services. We support clients as implementers of SAP HANA, providing expertise in functionality, finance, logistics, and processes The solution is very user-friendly and supports all kinds of…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product handles high volumes very well and provides good integration."
"It has a very huge bandwidth and data transfer."
"The solution is marvelous because it controls everything including workflow and that makes our company more productive."
"Provides us with predictive capabilities for asset maintenance, and real-time forecasts."
"It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that."
"It's very convenient and very innovative."
"The most valuable feature of SAP HANA is its performance and integration."
"The most valuable features of SAP HANA include its user-friendliness, flexibility, and extensive support for various functionalities like finance, logistics, and workforce processes."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. ​"
"Speed and resiliency are probably the best parts of this product."
"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."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
 

Cons

"The solution needs to work on its performance and make it faster."
"The solution could improve in the handling of backup data and the administration tools."
"A documents preview could be helpful."
"While new users to this solution have the benefit of the new design, existing ERP users may experience issues with migrating legacy data. We would like to see development of ready-made tools that allow for easy mapping when upgrading."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"I give the scalability of SAP HANA a six out of ten."
"The high price of the product is an area of concern where improvements are required."
"Needs graphical programming without coding."
"It would be great if this were a managed service in AWS."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"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."
"Suboptimal projection design causes queries to not scale linearly."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"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."
 

Pricing and Cost Advice

"The price of SAP HANA is very expensive and it is paid annually."
"The pricing is relatively high for both customers and partners."
"A monthly or yearly license must be purchased, although its utility will be based on the cost-benefit analysis that is reached by the individual customer."
"The price of licensing is dependent on the size of the project, however, we have found that there is scope to negotiate the cost. If the solution is implemented on-premises there may be some extra costs for hosting etc."
"We pay $200 on a monthly basis."
"The pricing is a bit on the high side."
"The price is on the expensive side, at eight out of ten, with ten being expensive."
"The tool is expensive compared to other products, like Oracle R or Microsoft, but it offers a range of all the company's functions."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"The solution is free and we pay for the storage."
"Read the fine print carefully."
"Vertica is an expensive tool."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"It's an expensive product"
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
849,190 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
15%
Computer Software Company
11%
Financial Services Firm
10%
Government
7%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What are the biggest benefits of using SAP HANA?
Based on my work with SAP HANA, the biggest benefit that it can bring to your business is total data management. This product is by SAP - a company that serves almost all needs a client may have co...
Is SAP HANA’s customer and technical support reliable?
We have been using SAP HANA for a fairly short period of time and have only taken advantage of their customer support. So far, we have not had issues that required specialized help from technical s...
Is SAP HANA difficult to set up and start using?
SAP HANA is fairly easy to set up, however, I do not think a complete beginner can do it. You certainly need some preparation - either you need to have experience with similar solutions, or with ot...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

SAP High-Performance Analytic Appliance, HANA
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company Limited
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Firebird, SQLite, Oracle and others in Embedded Database. Updated: April 2025.
849,190 professionals have used our research since 2012.