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

SAP BW4HANA vs SQL Server 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 BW4HANA
Average Rating
7.6
Reviews Sentiment
6.6
Number of Reviews
42
Ranking in other categories
Data Warehouse (9th)
SQL Server
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
266
Ranking in other categories
Relational Databases Tools (1st)
 

Mindshare comparison

SAP BW4HANA and SQL Server aren’t in the same category and serve different purposes. SAP BW4HANA is designed for Data Warehouse and holds a mindshare of 4.2%, down 4.5% compared to last year.
SQL Server, on the other hand, focuses on Relational Databases Tools, holds 20.1% mindshare, down 23.1% since last year.
Data Warehouse
Relational Databases Tools
 

Featured Reviews

Csaba Grünblatt - PeerSpot reviewer
Performs all necessary data warehouse tasks and offers additional functionalities
SAP BW4HANA improved data reporting processes significantly. Performance on HANA database is good. Well-built data models ensure consistent and fast reporting. Reusable models enhance efficiency, even for SaaS services. In-memory computing, especially since HANA, has greatly improved performance in data analysis tasks. It eliminates the need for complex optimizations like creating indexes or aggregates. Queries that once took minutes now run in seconds, enabling real-time reporting, especially for SAP ECC on HANA. SAP BW4HANA's integration capabilities are streamlined with a simplified architecture and more virtual layers. You can directly load data into optimized layers, reducing the need for extra storage. The introduction of Open ODS Views allows for additional logic and master data inclusion, making integration faster and simpler. The learning curve for SAP BW4HANA is much faster now compared to ten years ago, thanks to abundant free resources like documentation, videos, blogs, and learning journeys provided by SAP. It is simpler to learn with these resources available compared to the past when you had to attend courses and rely on books. I would recommend SAP BW4HANA to users looking to implement it, especially if they want to keep their systems on-premise and already have SAP systems. Those with BW on HANA have two choices: BW4HANA or DataSphere, depending on their cloud strategy. If they are advanced in their cloud strategy and want to migrate off-premise, DataSphere is a good choice. However, for a robust solution on-premise or in a private cloud, BW4HANA is an excellent option. Overall, I would rate BW4HANA as a nine out of ten. It performs all necessary data warehouse tasks and offers additional functionalities. We use it traditionally, with complex transformations and models but with less emphasis on real-time processing and third-party sources.
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

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

Pros

"Technology-wise, it is a very robust tool."
"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."
"We can get good visualization and less redundant data."
"It is a stable solution."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
"The solution is useful for connecting with external systems."
"It can calculate data in detail. Before we could not calculate financial documents and accountant documents in detail, we could not do it at a document level but now we can. This is the most important feature. It also has predictive analysis memory."
"The UI is completely new, beautiful, and user-friendly. There are some other helpful features like global filters and advanced tools. We can perform custom calculations easily From a technical perspective, the performance has been enhanced and optimized for a limited number of flows. The content settings are more advanced, and there are so many other features that I can't name them all."
"The solution is very common. It's easy to use."
"The setup process is straightforward."
"Unlike MySQL, SQL Server is advantageous because it allows the execution of stored procedures and commands. It's easy to understand, run, and manage. Also, Microsoft frequently updates SQL Server, quickly resolving issues in new versions."
"The solution is configurable."
"The installation was straightforward. We did not have a large installation and it took a couple of weeks to complete."
"It is easy to use and very stable."
"The feature that I have found most valuable is that it is easy to code."
"It is easy to manage for the administrator. It is also easy to use for applications that are Windows-based. It is a very stable product, and it has got backup and recovery tools."
 

Cons

"There's the complexity in migration from BW to BW/4HANA, especially with data migration."
"The monitoring for the remodeling feature is very difficult to understand."
"The problem is the expensive pricing of technical support, making it an area where improvements are required."
"The tool is not cloud-compatible."
"Real-time processing isn't BW/4HANA's strongest point."
"The UI is not user-friendly."
"Support could be more reliable."
"In the next release, I would like to see their BI component introduced with a mobile version, as it is not currently present."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"Right now we don't get much technical support from Microsoft"
"The tool needs to improve its pricing and technical support."
"Query optimitzer could be simplified."
"I would like to see the integration with other platforms improved in the future."
"It would be great if we were able to run it on multiple operating systems and not only stick with Windows."
"SQL could be improved by making all features available on the on-premise version of the product as well as the cloud version. When you buy the on-premise version, it's sort of an inferior product compared to the cloud version, which seems to get most of the latest and greatest features."
"It will be very useful to have high-level database monitoring. It should also have built-in business intelligence reporting."
 

Pricing and Cost Advice

"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 solution is expensive."
"The product is free if we have the ECC license."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"As an investment, the solution is very expensive."
"The tool is affordable."
"In general, it's quite expensive."
"The cost and licensing depends on how the customer is going to use the solution."
"There is a license to use this solution. However, the model is not easy to understand. There is a guide you have to read about all the information on how it works. If you read this documentation, you can understand how it works. We are paying for our SQL Servers by CPU cores with an enterprise license."
"For our purpose, we are not required to have a license for what we are using it for."
"There is an annual license and it is priced reasonably."
"This solution is available at a much lower price point than Oracle."
"We did a one-time payment. Its price, in general, can be reduced."
"We didn't have any licensing costs for SQL Server."
"There is no licensing cost for SQL Server."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing a seven out of ten."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
832,138 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
18%
Computer Software Company
10%
Financial Services Firm
9%
Energy/Utilities Company
8%
Educational Organization
52%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing 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.
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

SAP BW/4HANA
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

Information Not Available
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: February 2025.
832,138 professionals have used our research since 2012.