What is SAP's answer for enterprise data warehousing software?
First, what is data warehousing? It is a discipline centered around managing and integrating data over long periods of time, across multiple business areas, from many sources and with multiple users. There is no one way to do data warehousing, and every methodology will have ways of handling problems like integration, data quality, access control, time dependency and data volume in a consistent way. You can read about some of these challenges in greater detail in this article laying out a framework for choosing between HANA and SAP Business Warehouse (BW).
There are two ways to come to an answer about software for SAP data warehousing because there are two major approaches to data warehousing in the SAP world at this time: using a data warehousing modeling application and using individual tools.
BW is SAP's data warehousing modeling and management application. But it is also reasonable to architect, build and manage a data warehouse using other tools of your own choosing. If we were to use only SAP tools for this, we would probably use HANA and/or Sybase IQ as databases, SAP Data Services for transformation and loading, and SAP BusinessObjects (BOBJ) business intelligence software for managing a business semantics layer and reporting. Then we could layer on SAP Information Steward to manage data lineage and metadata, maybe the SAP Data Quality Management tool as well, plus Sybase PowerDesigner for modeling. Or we could use third-party tools for many of these tasks.
That list may seem intimidating, but, then again, data warehousing is a complex and difficult discipline. Many of these tools (or third-party equivalents) can be found filling roles even in BW-centric environments. SAP data warehousing is a discipline, and SAP provides tools ranging from the more integrated (like SAP BW) to the more platform and methodology agnostic (like SAP Data Services).
Dig deeper on SAP business warehouse
Related Q&A from Ethan Jewett
While many have criticized SAP's cloud strategy for being unclear and erratic in the past, it's beginning to fall into place, writes Ethan Jewett.continue reading
Do you need an SAP data mart, or a data warehouse? It depends if you need to deploy data across an enterprise, or need something more focused.continue reading
BI expert Ethan Jewett explains how running SAP Business Warehouse, or BW, on the SAP HANA database works, and what the advantages are.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.