Tag Archive: SAP BW4HANA

SAP BW/4HANA: The Next-Generation Data Warehouse, Delivered

modern libraryFrom its earliest deployments some three decades ago, the data warehouse has been a disruptive technology. As data has become more central to every aspect of what businesses do and ultimately what they are, the data warehouse has become an increasingly critical part of the enterprise data landscape – spinning off a series of subsequent disruptions in its own right (data marts, data warehouse appliances) and playing a central role in the emergence of many others (business intelligence, big data, data science.) Throughout this time, although data warehouses have handled a wide range of workloads in service a of a vast number of use cases, their core value proposition has remained fairly consistent.

In general, any data warehouse solution fulfills five basic requirements[1]Vincent Rainardi identifies these traits in his own blog  and with some additional annotation I concur.:

  1. An integrated view of the business’ data for strategic analysis
  2. A consistent view of the company’s data resources with data that has been cleared of anomalies which can lead to a false impression of the business’ function
  3. A consolidation of the company’s data history beyond what is retained by current operations for deep analysis of the business’ functions over time
  4. A tested and verified environment for analysts to access data so that each new draw of data doesn’t become a “science experiment” in and of itself
  5. A performant environment for doing data analysis that does not interfere with day-to-day activity of the business

Since its introduction, SAP Business Warehouse (BW) has served as the foundation for data warehousing solutions that meet all of these requirements. Now SAP BW/4HANA, merging the power of the SAP HANA in-memory platform with the business process expertise of SAP BW, takes that value proposition to a new level.  Compared with SAP BW environments running on on a traditional database (such as Oracle or IBM DB2), SAP BW/4HANA presents a whole new paradigm for data warehousing, delivering next-generation data warehouse capability for organizations facing unprecedented business and technical challenges.

Integrated View

As a true data warehousing solution, SAP BW/4HANA fully integrates data as required from multiple applications. But businesses today must integrate data from a wide variety of sources beyond the traditional operational business systems. Using SAP HANA Smart Data Access, SAP BW/4HANA can rapidly access live data in remote systems including other data warehouses, business systems, operational data stores, data marts, dynamic tiers of analytic storage (such as SAP IQ), and even Hadoop systems with big data.  A solution that brings all of these disparate sources together in real time into a single virtual repository is called a logical data warehouse. Designed from the ground-up as an in-memory solution, SAP BW4/HANA uniquely delivers this much-needed model.

Clean and Consistent View of Data Resources

Uniting the diverse data sources that today’s businesses rely on is an important first step, but it is only half the battle. A business must be confident that its data has been appropriately prepared and cleansed  to provide reliable results. Not only does SAP BW/4HANA support the logical data warehouse concept, it adds the necessary management and control over these data sources to provide consistent views of data where it is – avoiding the traditional requirement for an ETL  process that physically moves that data into local storage.

Consolidation of Data History

In keeping with core data warehousing requirements, SAP BW/4HANA provides a consistent view of data history for  the business. But when incorporated with technologies such as SAP HANA Streams for streaming data and SAP HANA Vora for data managed by big data technologies (Hadoop, Spark), SAP BW/4HANA provides a much more complete and up-to-the-minute picture of data history, including Internet of Things data from sources such as consumer devices, RFID, smart meters, and portable monitoring devices.

Tested and Verified Environment

SAP BW/4HANA organizes not only the data, but the metadata of the logical data warehouse. This creates a comfortable and logical environment in which an analyst, a data scientist, or an end user can access this data in a consistent and reliable fashion – such as with SAP BusinessObjects Cloud.

High-Performance Environment

Because SAP BW4/HANA is exclusively tuned to leverage the SAP HANA infrastructure, which was built from the ground up to solve business analytics data problems, it can deliver outstanding performance far beyond BW on traditional databases. For example, SAP BW4/HANA can resolve in seconds data inquiries that used to take hours.  With this vastly enhanced performance, companies with SAP BW/4HANA can operationalize real-time solutions, such as real-time customer sentiment analysis and retail offers, self-adjusting marketing campaigns, and in-clinic health solutions. Where previously the sheer volume of data and complexity of relationships within it stretched the capability of traditional environments to the breaking point, SAP BW/4HANA delivers real-time results.

Although data warehousing has changed significantly over the years, at a fundamental level what businesses need a data warehouse to do has remained much the same. The real challenge has been delivering those same core capabilities in the face of fundamentally transformed data environments and business processes. Designed  from day one to address the requirements of a new business and technological landscape, SAP BW/4HANA delivers true next-generation data warehousing capability, while helping businesses to ready themselves for the inevitable next wave of disruptive change.

Follow the conversation on Twitter at #TheFutureOfDW AND #BW4HANA

References   [ + ]

1. Vincent Rainardi identifies these traits in his own blog  and with some additional annotation I concur.

More than a Database

Old wooden card catalog with open box in the archive library

The modern data warehouse calls for capabilities that go far beyond what a traditional database can provide. SAP BW/4HANA fills that gap.

There was a time, not long ago, when even the stickiest data management problems for business had a simple solution.

You need to keep track of day-to-day business operations?

Get a database.

You need to do some quick reporting on some of that data?

You’d get a database for that, too.

You need to do more advanced analysis on all that transactional data?

Hey, what do you know—that sounds like another database problem.


Over the years there has been a steady progression from online transaction processing to operational reporting to online analytics processing. As the need for more powerful and sophisticated data warehousing solutions has grown, databases have been reoriented from rows to columns and have been optimized for massively parallel processing. But the basic underlying technology has remained much the same. Even in the era of big data, we’ve seen oversize repositories of semistructured and unstructured data evolving new features that push them in a more and more database-like direction.

It’s a formula that has worked for a long time: Got a data problem? Get a database.

But today your business faces an unprecedented sets of challenges. Bigger data volumes. New data types. A deluge of machine data from the Internet of things.  Digital business models that require real-time performance all the time drive the need for zero-latency reporting. Data-driven businesses need more complex, more extensive, and yet paradoxically faster and more easily accessed analytics. To succeed, you  need a deeper understanding of the Why behind what your customers, your competitors, and the market as a whole is up to. These are the challenges of the modern data warehouse. And to meet these challenges, you need something more than just a database.

Time for a New Formula

SAP BW/4HANA is more than a database. BW/4HANA merges the power of the SAP HANA in-memory platform with the unmatched business savvy of SAP Business Warehouse.

BW/4HANA provides a single version of the truth. It’s is the only data warehouse system built from the ground up to enable real-time analytics and real-time transactions on the same data and the same time. Traditional databases still require you to split analytics and transaction processing and to copy data from place to place throughout the organization.

BW/4HANA lets you solve in seconds analytics problems that take other systems days. It’s the only data warehouse system built from the ground up for extreme performance by using such techniques as  memory-first, column-based calculation. Traditional databases, by contrast, continue  to plod along with column-based caching.

BW4/HANA saves you time with a pre-delivered structure. It’s the only data warehouse system with pre-built data objects for SAP applications (and other systems)  as well as with industry-oriented templates.Traditional databases typically leave it to the user to develop governance and schema techniques, making implementations slower and much more complex.

BW/4HANA is ready for the Internet of things at petabyte scale. It is the only data warehouse with integration for streams (HANA Streams), Hadoop computation (through SAP HANA Vora), and multi-temperate data (Dynamic Tiering/NLS)

Perhaps most importantly, only BW/4HANA is backed by SAP, the world leader in business application technology—ensuring that your business can run smarter, better and faster.

Differences that Make all the Difference

In a world where “get a database” is no longer a sufficient answer, SAP BW/4HANA brings all of your data together and makes it actionable. A data warehouse solution built on BW/4HANA can  accelerate your business into real-time—eliminating the boundaries between operations and analysis, putting data into the hands of decision-makers throughout your organization.

Follow the conversation on Twitter at #TheFutureOfDW AND #BW4HANA