Data Acquisition, Extraction, Transformation and Process Chains
This topic provides the end-to-end learning path for SAP BW/BW4HANA data acquisition, extraction, transformation, loading and process orchestration. It covers how data moves from source systems into BW objects through DataSources, transformations and Data Transfer Processes (DTPs), how process chains automate and monitor these loads, and how the resulting models support queries and embedded analytics. It sets the architectural and sequencing context for the deeper child topics on modeling, transformation logic, source integration, load operations and BW/4HANA migration.
Overview
This topic provides the end-to-end learning path for SAP BW/BW4HANA data acquisition, extraction, transformation, loading and process orchestration. It covers how data moves from source systems into BW objects through DataSources, transformations and Data Transfer Processes (DTPs), how process chains automate and monitor these loads, and how the resulting models support queries and embedded analytics. It sets the architectural and sequencing context for the deeper child topics on modeling, transformation logic, source integration, load operations and BW/4HANA migration.
Lessons in this topic
- Mapping the End-to-End Architecture: Sequencing Modeling, Transformation, Source Integration and OrchestrationAn architecture-and-sequencing lesson connecting the child topics of modeling, transformation/DTP design, source and reporting integration, and process chain operations into one coherent implementation and support roadmap.
- The BW Data Journey: Why Acquisition, Extraction and Transformation MatterAn orientation lesson explaining why structured data acquisition and transformation exist in BW, the core objects involved, and how they fit into the broader reporting lifecycle.
Interview questions covered
- Explain how the ODP (Operational Data Provisioning) framework manages delta queues across different source system types (ODP_SAP, ODP_SLT, ODP_BW) and what happens when multiple subscribers consume the same delta queue.
- What is SAP SLT (SAP Landscape Transformation Replication Server) used for in a BW/4HANA or S/4HANA data acquisition landscape, and how does it differ from a traditional extractor-based load?
- In BW/4HANA, what are the main ADSO types and when would you use each?
- What is the fundamental architectural difference between BW on HANA and BW/4HANA, and why does this matter when planning a migration?
- What is the fundamental architectural difference between running BW on HANA versus BW/4HANA, and why does this matter for a migration project?
- What is the fundamental difference between 'BW on HANA' and 'BW/4HANA', and why does this distinction matter when planning a migration project?
- Explain how ODP (Operational Data Provisioning) manages delta queues across different source types, and what happens when multiple subscribers consume the same delta queue.
- What are the different ADSO types in BW/4HANA and when would you use each one?
- What is the fundamental architectural difference between classic BW on HANA and BW/4HANA that drives the need for a conversion project rather than a simple upgrade?
- What is the fundamental architectural difference between classic BW on HANA and BW/4HANA that drives the need for a migration project?
- What is SAP SLT (SAP Landscape Transformation Replication Server) used for in a BW/BW4HANA data acquisition landscape, and how does it differ from a standard extractor-based load?
- A BusinessObjects Web Intelligence report built on a BW query via a BICS connection needs to enforce row-level security based on cost center ownership, and a variable is used to pre-populate the user's default cost center range. How do analysis authorizations and this variable work together to enforce security?
- During an S/4HANA migration, you must decide whether to keep classic BW extractors or migrate to ODP-based extraction for the same business data. What factors drive this decision?
- Users report that a Datasphere space consuming data from BW/4HANA via a remote table shows stale figures compared to the BW/4HANA source after the nightly load. How would you troubleshoot this integration issue?
- During a global rollout, a customer-exit variable used across dozens of queries in SAP Analytics Cloud live connections suddenly returns incorrect default values for users in one region only, while direct BW query execution via RSRT works correctly. How would you architect a resolution that avoids region-specific side effects?
- Your S/4HANA source system extractor for sales orders is configured for delta loads, but after a support pack upgrade, the delta DTP suddenly pulls duplicate records already loaded previously. What would you investigate first?
- When configuring SLT (SAP Landscape Transformation Replication Server) as a source for BW real-time data acquisition, what are the key configuration steps and monitoring transactions you need to set up on the SLT side?
- Your organization is migrating InfoCube-based reporting models from BW 7.5 on ECC-sourced data to BW/4HANA. What HANA-optimized modeling pattern would you apply to replace the classic star-schema InfoCube approach?
- During hypercare after a BW/4HANA migration, users report that certain process chains are failing intermittently with authorization errors that did not occur in the legacy BW system. What configuration areas would you check first?
- Walk through how you would use the BW/4HANA Transfer Cockpit to plan and execute a phased migration of a large classic BW system with dependencies across multiple InfoAreas.