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.2
Reviews Sentiment
6.5
Number of Reviews
84
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 solution is very stable."
"It's easy to use, and the Hana Studio is pretty good."
"It is a stable solution...It is a scalable solution."
"If you want to scale with new processes and new reports, that's fairly easy."
"A very feature-rich solution with excellent performance."
"The speed at which it gets the data is great."
"The most valuable features I have found are speed, dashboard, and reporting."
"We like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"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 feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The initial setup was straightforward."
"The performance is very good and the aggregate records are fast."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"I have found the solution to be scalable."
 

Cons

"It would be nice to know when SAP plans to stop its maintenance of a previous version of SAP ECC ERP because, at this point, anyone utilizing SAP will have no choice but to go on S/4HANA Database."
"It is challenging to integrate it with third-party tools."
"The SAP ERP processes are quite complex and it can be challenging."
"The support is lacking and not worth the premium price. If support was just a nominal fee, it would be perceived differently."
"Ease of use could be improved in SAP HANA. I like SAP because SAP solutions can be used by anyone, which means even laymen can start working on SAP tools, but in SAP HANA modeling, you'll need to know some other technologies and sequel scripting, and you need a separate skillset, so if you don't have the skillset, you won't be able to work on SAP HANA. Making SAP HANA low-code would make it even better."
"The solution needs to work on its performance and make it faster."
"The interface is a little bit hard to customize. You almost have to consult the SAP original developer to change it."
"There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Limitations in group by projections is where I would like to see an improvement."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
 

Pricing and Cost Advice

"Price-wise, the product falls on the higher side of the spectrum. There is no need to pay for maintenance and support additionally. Support is available for bug fixes in the product."
"The cost of SAP HANA is high, and I would rate the price at eight out of ten."
"The price is high and could be a bit cheaper."
"Set up a consortium of consulting partners and hardware vendors to define your tech. Landscape TCO (total cost of ownership) and then approach the OEM for pricing (on-premise or on cloud or a hybrid model). Check if you can bring your own licenses for some of the existing application licenses on the new platform, to reduce TCO."
"There is a yearly subscription to use SAP HANA. There is a fee for maintenance."
"People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or not. People often ask, how will I profit when the cost is so high?"
"It comes with a significant cost."
"The licensing cost for SAP HANA is approximately $200 per user per month."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The solution is relatively cost-effective."
"From a cost perspective, the software is less than most of its competitors."
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"The solution is free and we pay for the storage."
"The pricing could improve, it is a little expensive."
"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 of Vertica is less expensive than some competitors, such as Teradata."
report
Use our free recommendation engine to learn which Embedded Database solutions are best for your needs.
848,989 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
15%
Computer Software Company
12%
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.
848,989 professionals have used our research since 2012.