SAP BW Architecture – Overview

SAP BW Architecture : The graphic shows a physical and logical division between data staging in the source systems, data storage and management, and analysis. A source system is a system that provides the SAP BW Architecture system with data. SAP BW distinguishes between four kinds of source systems: 

Databases: SAP BW allows data to be loaded from external relational database systems. A DataSource is generated based on the external table structure, enabling table content to be loaded quickly and consistently into SAP BW.


SAP BW Architecture

Non-SAP systems: A big advantage of SAP BW lies in the fact that is has an open architecture vis-a-vis external OLTP providers and other legacy systems. Particularly in a heterogenous system landscape, it is thus possible to use SAP BW as a consolidated data basis for reporting that covers the entire organization. SAP delivers various tools which allow these interfaces to be implemented quickly and efficiently. These are looked at next. 

Data providers: As well being able to obtain data from a variety of available systems, SAP BW can also be supplied with target-orientated data from providers. For example, the organizations AC Nielsen US or Dun & Bradstreet provide market research data, which can be loaded into SAP BW for benchmarking and then measured against your own operative data. The interface for the transfer of data supplied by the data providers is already available in SAP BW. This means the data import can run smoothly. 

You can send data from SAP and non-SAP sources to SAP BW using SAP Exchange Infrastructure (SAP XI). In SAP BW the data is placed in the delta queue and is available there for further integration and consolidation.Data transfer using SAP XI is SOAP-based.

SAP XI is based on general standards so as to enable external systems to be integrated. At the center of the infrastructure is an XML-based communication that uses HTTP (Hyper Text Transfer Protocol). The application-specific contents are transferred in messages in user-defined XML (eXtensible Markup Language) schema from the sender to the receiver using the Integration Server.

mySAP Business Suite components: SAP BW is fully integrated into the mySAP Business Suite . It functions as a central data warehousing tool. Predefined extraction structures and programs are delivered by SAP. These allow source data from mySAP Business Suite components to be loaded directly into the SAP BW system. Complex organizational structures in which data from individual systems is collected, create a need for a system architecture consisting of several BW systems.

These temporarily store data in the detailed form of an organizational unit, before they can then be transferred to a central SAP BW for carrying out comprehensive reporting.

Recommended Reading For You

  • What is SAP Landscape?What is SAP Landscape?Just try to understand the system sap landscape, Every company follows their own landscape as a standard you will have three servers like development, quality assurance and production […]
  • What is Business Intelligence?What is Business Intelligence?Business Intelligence: The Purpose of Business Intelligence, During all business activities, companies create data. In all departments of the company, employees at all levels use this data […]
  • What is SAP BW Monitoring Tool?What is SAP BW Monitoring Tool?SAP BW Monitoring Tool: The Process Chains context contains all of the process chains that have run since the BW system was last started.By setting the transfer parameter for method […]
  • To Make Settings for SAP BW 3.5 and SAP EP 6.0To Make Settings for SAP BW 3.5 and SAP EP 6.0Making Settings for SAP BW 3.5 and SAP EP 6.0 Purpose A number of settings need to be made in the BW system for the Integration of SAP BW 3.5 and SAP EP 6.0. Some settings in SAP BW and […]
  • SAP BW transport errors and Fixes for TransportsSAP BW transport errors and Fixes for TransportsCommon Transport Errors in Transformations/Update Rules SAP BW Transport Errors Log 1:Error: Syntax Error in routine.Reason: This error occurs if the transformation is not […]

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: