Overview

This course enables SAP BW/4HANA customers and consultants to provision (load, replicate) data into SAP BW/4HANA. It highlights the simplified data flow of BW/4HANA, and data provision techniques targeting the underlying SAP HANA database directly. The emphasis is on learning and practicing various technologies in support of data acquisition including Operational Data Provisioning, Smart Data Integration and CDS views. Special topics are enhanced master data upload, creating a Process Chain from a BW DataFlow, and error handling.

What you'll learn

Learn how to extract data from SAP source systems and another BW with Operational Data Provisioning (ODP) and how to manage delta data with ODP

Acquire data using different interfaces such as: SDI - Smart Data Integration, SDA - Smart Data Access, Flat File and CDS views

Design and maintain Data Flows with advanced techniques

Learn about advanced features of Streaming Process Chains

Integrate data from SAP HANA via BW Source Systems to BW/4HANA

Skills you'll gain

Business Warehouse (BW)

Content

SAP BW/4HANA Strategy and Overview
Data Acquisition into SAP BW/4HANA with Operational Data Provisioning (ODP_SAP)
Operational Data Provisioning Delta Management (ODP_SAP)
SAP BW/4HANA Data Extraction from SAP S/4HANA (ODP_CDS)
Other Types of Operational Data Provisioning in SAP BW/4HANA (ODP_SLT, ODP_BW, ODP_HANA)
Data Acquisition into SAP HANA and the HANA_LOCAL source system
Data Acquisition into BW/4HANA with the HANA_SDA source system
Manage and Optimize Data Flow Components in SAP BW/4HANA
Big Data Acquisition to SAP BW/4HANA and SAP Data Hub

Audience

Developer
Solution Architect
System Administrator
Technology Consultant
Trainer

Course Based on Software Release

SAP BW/4HANA 2023 SP00
SAP HANA 2.0 SPS07
SAP S/4HANA 2023
SAP HANA Studio 2.3.75
SAP BW Modeling Tools 1.25.33
SAP Web IDE for SAP HANA 2.0 SPS07
SAP Analysis for Microsoft Excel 2.8

Notes

This course provides you a very sound foundation of newer and existing BW data acquisition concepts and contains many references to additional documents and information sources.
This course now uses an S/4HANA source system and the HANA 2.0 database release, including the Web IDE for SAP HANA XSA calculation views.
This course has a very strong focus on hands-on experience.

Pre-requisite Learning

BW410-SAP BW/4HANA Data Warehousing

Hands-on experience with any version of SAP BW
BW430 (SAP BW/4HANA Modeling)
HA100 (SAP HANA Introduction)
HA300 (SAP HANA Implementation and Data Modeling)
HA550 (SAP HANA Data Provisioning)

SAP BW/4HANA Data Acquisition