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

SAP BW4HANA vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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 BW4HANA
Ranking in Data Warehouse
9th
Average Rating
7.6
Reviews Sentiment
6.6
Number of Reviews
42
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Data Warehouse
5th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (8th)
 

Mindshare comparison

As of January 2025, in the Data Warehouse category, the mindshare of SAP BW4HANA is 4.6%, up from 4.6% compared to the previous year. The mindshare of Vertica is 9.1%, up from 8.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

DilipRoshantha - PeerSpot reviewer
Offers good value for money to users
There have been no hiccups for my company when it comes to integrating SAP products with the data analytics and the transactional systems since my company uses SAP PI for it, but lately my organization has been using SAP Process Orchestration for data integration. With SAP, there is a small visualization part inside SAP BW4HANA. I can visualize some of the reports with the help of SAP BW4HANA. The tool can be configured and is compatible with all SAP applications, which makes it a good product. I believe that the product has the capabilities to cater to various business requirements. The product does offer value for money. There are big customers along with medium or small customers. Small and medium-sized customers cannot afford the cost of the tool's licensing. From a value point of view, in business terms, it is good. I rate the tool a nine out of ten.
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

"We can get good visualization and less redundant data."
"The solution saves time and cost."
"The solution seamlessly integrates with SAP products."
"The most valuable feature is that it's robust."
"Provides a great analytics engine with all the capabilities."
"You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider."
"The most valuable aspect of this solution is that the infrastructure is easy to understand."
"The most valuable feature is the dashboard."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. ​"
"The solution is quick, has good compression data, and is not expensive."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"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. ​"
"I have found the solution to be scalable."
"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."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
 

Cons

"Real-time processing isn't BW/4HANA's strongest point."
"The monitoring for the remodeling feature is very difficult to understand."
"There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."
"There should be a direct pipeline from Azure to SAP."
"Challenges arise with real-time client requirements when clients are accustomed to Microsoft Excel's extensive features for data analysis. They expect similar flexibility and customization in the solution, particularly regarding headers displaying keys and descriptions or just keys. Achieving this level of customization can be challenging, and it's an area that may need improvement."
"The tool is not cloud-compatible."
"The solution is not easy to implement. It requires a lot of learning at the beginning."
"The UI is not user-friendly."
"It would be great if this were a managed service in AWS."
"Very bad support, I would rate it two out of 10."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Pricing could be more competitive."
"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."
"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
 

Pricing and Cost Advice

"As an investment, the solution is very expensive."
"Price wise, this solution is on the higher side."
"SAP BW/4HANA is expensive."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"The product is free if we have the ECC license."
"The tool is affordable."
"For the on-premises version of the product, the solution offers a perpetual-based licensing model to its users. In general, SAP offers a monthly subscription-based licensing model to its users."
"The cost and licensing depends on how the customer is going to use the solution."
"The price could be cheaper and it is best to negotiate the price."
"It's an expensive product"
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"The pricing could improve, it is a little expensive."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"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 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 relatively cost-effective."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
830,455 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
18%
Computer Software Company
10%
Energy/Utilities Company
8%
Financial Services Firm
8%
Financial Services Firm
18%
Computer Software Company
18%
Manufacturing Company
8%
Energy/Utilities Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about SAP BW4HANA?
One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integrati...
What is your experience regarding pricing and costs for SAP BW4HANA?
We have a broad licensing arrangement, which is expensive but worth it for sizeable businesses.
What needs improvement with SAP BW4HANA?
The interface could be more user-friendly, as we often need to do low-level coding to get things done.
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 BW/4HANA
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Learn More

 

Overview

 

Sample Customers

Information Not Available
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about SAP BW4HANA vs. Vertica and other solutions. Updated: January 2025.
830,455 professionals have used our research since 2012.