Tag Archive: SAP BW

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

Back From Sapphire

1429793761239

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.