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

OpenText Analytics Database (Vertica) vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jun 19, 2025

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

OpenText Analytics Database...
Ranking in Cloud Data Warehouse
11th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (8th)
SAP Business Warehouse
Ranking in Cloud Data Warehouse
14th
Average Rating
7.8
Reviews Sentiment
6.3
Number of Reviews
25
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2025, in the Cloud Data Warehouse category, the mindshare of OpenText Analytics Database (Vertica) is 5.7%, up from 5.4% compared to the previous year. The mindshare of SAP Business Warehouse is 1.5%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

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…
JavedKhan1 - PeerSpot reviewer
Offers powerful analytics and integration capabilities but requires improved upgrade processes
SAP Business Warehouse could have been better. There is room for improvement from a technical perspective. So, from a technical perspective, when we are upgrading a Business Warehouse server or we are migrating from one place to another, the capability required for this upgradation has many manual activities. It took us around a month to streamline our server. Let’s say there are some transaction codes. Transaction code is a set of programs, and when you want to run a program from the backend, you need to hit the transaction code. It is called a T-code. So during the upgrade, many transaction codes get affected, and as a security consultant, it is my responsibility to recheck those transaction codes which are affected. Sometimes more than 100 codes may get affected, sometimes 500, and sometimes more as well. So, it takes a hell lot of time to integrate them again. That is a limitation or defect within the SAP Business Warehouse. SAP Business Warehouse should come up with proper solutions. Upgradation is an automatic activity. It should happen by itself. We just need to initiate it, and the backend SAP server is automatically upgraded. But it should handle the transactional code as well. They should not get absolutely, and any authorization object should not get deleted from the transaction codes. So, that functionality SAP Business Warehouse should come up with.

Quotes from Members

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

Pros

"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"The product's initial setup phase is extremely simple."
"Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"The solution is quick, has good compression data, and is not expensive."
"I enjoy the cybersecurity and backup features."
"It has improved my organization's functionality and performance."
"Out-of-the-box reports are very useful."
"The most valuable feature of SAP Business Warehouse is transformation, where I extract data from different sources, particularly the raw data. Then I do some transformations and store that in a format that allows me to do reporting easily."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"The product is very stable."
"I like that it integrates to open-source."
"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."
"Having the back-end data set with the right information is the best qualification for this solution."
"SAP Business Warehouse is a scalable solution."
 

Cons

"The geospatial functionality could be designed better."
"I believe the installation process could be streamlined."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Pricing could be more competitive."
"They could improve on customer service."
"Suboptimal projection design causes queries to not scale linearly."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"I would like to see a different end solution in order to read the data and attract internal users."
"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"It's a product that is at the end of life so they will not improve it anymore."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"There is room for improvement from a technical perspective."
"The advanced structuring can be complicated and the interface is not very intuitive."
 

Pricing and Cost Advice

"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."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"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 pricing could improve, it is a little expensive."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"It's an expensive product"
"It's moderately expensive, but definitely has its branding and price value for it."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"The solution is quite expensive."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"I would not recommend it to small-scale companies. The price is too much."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"Overall, the pricing is not fixed and is expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,129 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Computer Software Company
17%
Manufacturing Company
8%
Comms Service Provider
4%
Manufacturing Company
13%
Financial Services Firm
10%
Computer Software Company
9%
Energy/Utilities Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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.
What is your experience regarding pricing and costs for SAP Business Warehouse?
The solution is quite expensive. We paid a yearly subscription fee.
What needs improvement with SAP Business Warehouse?
Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bo...
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
No data available
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about OpenText Analytics Database (Vertica) vs. SAP Business Warehouse and other solutions. Updated: May 2025.
859,129 professionals have used our research since 2012.