Tag Archive: SAP

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

The Data Warehouse Revolution Is Coming

Winding Boardwalk through Forest, Pohara, Golden Bay District, Nelson Region, South Island, New ZealandModernizing the data warehouse is no longer just a passing thought in most major enterprises, but is increasingly becoming the imperative. A centralized structure for all our data that took shape in the 90’s is increasingly appearing to be outdated and incomplete as the sole architecture for business analytics.

Why is this?

Three trends are working strongly against the centralized, single-database approach to the data warehouse. First, is business is becoming increasingly transacted through web and digital interfaces. Just as the ATM displaced human interactions for banking transactions, now business are interacting with the customers, employees, partners, and even machines through digital interaction. And that interaction is creating a wealth of data, if we can leverage it.

Second, but strongly correlated with the first is the proliferation of data sources and the amount of data with which business professionals want and need to engage. It is becoming increasingly difficult or impractical to move such vast amounts of data. In some cases, it might even make sense that the data be treated as impermanent stream of time-sensitive content. The practicality of dealing with big data and its consequences begs for new solutions over centralized of reservoirs of storage.

The third trend is continuation of increasing pace of digital transactions. The demand is always to conduct business more quickly and efficiently. This pressure, usually spawned by competition places increasing strain to make decisions and analysis ever more quickly. Business problems like fraud detection, real-time web interactions, customer service, and customized consumer offers all become increasingly part of this his speed decision making process.

SAP customers already are reaping the fruits of this trend towards more powerful computing. Leveraging power of SAP HANA, SAP’s business suite S/4HANA powerfully combines core business applications and operations with in-memory computing. This enables real-time operations. By extending this idea to warehouse, real-time business operations.

What is needed is a new approach to the data warehouse. We need an approach that combines the power of an in-memory data engine with access across a range of data sources and stores. A new system for managing the data warehouse would need to understand multiple temperatures of data (that is, how important and urgent data is) as well as be able to work with vast distributed technologies such as Hadoop. Of course such an engine would need to understand streams and other forms of temporal data. And most importantly, we would need a warehouse that with our applications and BI tools.

Sound like too much?

Well, at SAP we’ve been revolutionizing the platform for data analysis. We invite you to find out more about a data warehouse system that can do all this and more: a revolution in data warehouse management is coming this September.

Follow the conversation on Twitter at #TheFutureOfDW

I’ll be at TechEd 2015 in Las Vegas

550x305_VenetianPalazzoI’ll be attending TechEd 2015 in Las Vegas this October.   While my schedule isn’t finalized, I’ll spend much of free time in the product showcase discussing data warehousing.and SAP’s latest technology HANA Vora.  The event is going to be held in the Venetian and Palazzo Hotel on the Las Vegas strip October 19-23.  If you’re at the event, drop by and say hello!




Back From Sapphire


SAP SapphireNOW Orlando is over and I’m back at my California home.  We had great traffic at the data warehousing booth and it was fun to meet many of you in person.   Lots of in-depth conversations about how one goes about architecting the idea business warehouse for specialized applications.

A question I was asked a lot was about the future of SAP Business Warehouse.   Don’t worry, Business Warehouse is very much a part of SAP’s future plans.   While we are always looking for ways to eliminate copies of data, that it not the true power of Business Warehouse.  Business Warehouse provides the toolset to design the complex hierarchies of data warehouse as well as key process automation and monitoring.  It is a core modeler for an efficient data warehouse for its entire lifestyle, not simply loading data.  And Business warehouse provides the services to integrate data from many sources and manage the underlying data bases in ways far more sophisticated than basic SQL.   While these services will continue to be ever more closely tied with SAP HANA, our in-memory application platform and database, they are still distinct needs of the complex data warehouse.

Other customers asked me about our commitment to Hadoop and what was the difference between Hadoop, and our disk-based, HANA Dynamic Tiering.    Well, SAP is very into both.   Hadoop is, of course, an open source product of the Apache foundation.   Dynamic Tiering is underlied by the columnar database design and legacy of SAP IQ.  At its heart, Dynamic Tiering is a very powerful relational database.   When data is already well structured, it is an ideal store for large quantities of business data, video, and text.   Hadoop is, at its heart, a key-value pair on a distributed file system.   This makes it fantastic for the acquisition of fast moving, unstructured data in a cost-effective way.   Both are highly relevant for the future of data warehousing and SAP is committed to providing all the tools customers need to build data warehouses for the source data you will likely encounter in the future.