SAP Business Warehouse Reviews

Vendor: SAP

3.9 out of 5

25 reviews
89% willing to recommend

377 followers

What is SAP Business Warehouse?

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

Get the SAP Business Warehouse Buyer's Guide and find out what your peers are saying about SAP Business Warehouse, Snowflake, Teradata and more!

SAP Business Warehouse is the #13 ranked solution in top Cloud Data Warehouse solutions. PeerSpot users give SAP Business Warehouse an average rating of 7.8 out of 10. SAP Business Warehouse is most commonly compared to Snowflake: SAP Business Warehouse vs Snowflake. SAP Business Warehouse is popular among the large enterprise segment, accounting for 66% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a manufacturing company, accounting for 11% of all views.

Buyer's Guide

SAP Business Warehouse

October 2024

Get the report

Helped 814,325 peers since 2012

Featured reviews

JavedKhan1

SAP Security/GRC Manager at Tata Consultancy

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.

Read full review

Srini-Dhanaraj

Founder & CEO at imfine.club

Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process. People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

Read full review

Rodolfo Bermúdez Neubauer

Consulting Manager at Intellego BI

SAP Business Warehouse excels as a corporate data warehouse, providing integrated ETL, warehousing, and reporting capabilities. While other solutions may offer more flexibility, SAP BW stands out as an all-in-one solution, especially for clients using SAP's backend systems like ERP and CRM. It is a logical choice for organizations seeking a comprehensive data warehousing solution tailored to their SAP ecosystem. Before HANA, SAP Business Warehouse's ETL functions were basic compared to competitors, fulfilling their job but lacking sophistication. However, with HANA technology, there has been a significant improvement. Now, we can work with real-time data warehousing, breaking the traditional paradigm of nightly data updates. HANA enables real-time data integration, a substantial advancement in SAP's data warehousing capabilities. By using online database replication, SAP Business Warehouse provides real-time integration of data from multiple sources into the data warehouse. With BW's modeling and transformation features, raw data becomes actionable insights, presented in user-friendly formats, aiding informed decision-making. SAP Business Warehouse's data modeling capabilities have significantly improved our decision-making processes. By leveraging features like Core Data Services and HANA graphical calculation views, we can model data closely to SQL standards and transform it effectively for reporting needs. This enables us to have real-time data in a structured environment optimized for reporting, providing insights that were previously difficult to obtain from transactional systems. If you are considering using SAP Business Warehouse, my advice would be to let the business lead the project, not IT. Overall, I would rate SAP Business Warehouse as an eight out of ten.

Read full review

SAP Business Warehouse mindshare

As of October 2024, the mindshare of SAP Business Warehouse in the Cloud Data Warehouse category stands at 1.4%, down from 1.6% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Cloud Data Warehouse

Key learnings from peers

Valuable Features

"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"Out-of-the-box reports are very useful."
"The product is very stable."

Room for Improvement

"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."
"I get all the information quickly, but it is one day old."
"They should reduce the product’s installation package size for easier downloading."

Pricing

"The solution is quite expensive."
"I would not recommend it to small-scale companies. The price is too much."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our SAP Business Warehouse Buyer's Guide for additional reliable information.