This repository contains the material for the SAP TechEd 2022 session called DA281 - Hands-On Session for SAP Data Intelligence: Connectivity and Integration.
SAP Data Intelligence is our leading solution for data integration, management, processing, and orchestration across different data environments. Through hands-on experience focused on connectivity and system interoperability with ABAP systems, see how to use corresponding built-in operators in the SAP Data Intelligence solution to integrate with SAP S/4HANA, SAP Business Suite software, and the SAP BW/4HANA solution, or with technologies such as SAP Landscape Transformation Replication Server.
The requirements to follow the exercises in this repository are:
- Basic knowhow about the usage and scope of S/4HANA
- General understanding of Enterprise Data Management and ETL (Extraction, Transformation, Load)
- Basic programming skills in ABAP are of advantage
The main use cases behind this workshop are:
- The extraction the Business Partner master data in S/4HANA's demo application Enterprise Procurement Model (EPM) and making the records available for the corporate Data Analysts in SAP HANA Cloud database.
- Also persist the transactional data in HANA Cloud, i.e for EPM Sales Order objects which are built from joins over multiple EPM tables.
- In both cases, any single change of these data sources in the S/4HANA system has to be instantly and automatically replicated to the related tables in HANA.
- Additionally, the Sales Order data have to be enriched with Customer master data, for the initial load and then on every change committed to the EPM Sales Order data in S/4HANA.
- In order to create test changes on the EPM Sales Order data without having access to the SAP GUI in the S/4HANA system, (a variant of) the EPM Data Generator reports needs to be executed as an ABAP Function Modul call from a Data Intelligence Pipeline.
- The possibility of Replication Management System with the replication of CDS Views into a HANA Cloud target system
The Deep Dive live demos and the hands-on Exercise contents reflect the above scenarios and provide a consecutive approach for their realization. But other than during the on-site TechEd events in the past years, it was not feasible to provide the Eclipse based ABAP Development Tools (ADT) and the SAP GUI to our participants in the this year's virtual version of the TechEd.
Since it is a goal of this workshop to show and get the hands on the complete end-to-end implementation processes of ABAP integration with SAP Data Intelligence, all parts of this session that require these (local) applications will be presented as live Deep Dive demos, conducted in ADT and in SAP S/4HANA by the trainer, the Exercises - in opposite - are then performed by the participants in SAP Data Intelligence and will leverage those artifacts in S/4HANA that got created during the Deep Dive demos.
- Overview and Getting Started
- Deep Dive demos vs. Exercises
- Short introduction to the Enterprise Procurement Model (EPM) in ABAP systems
- Access to the exercises' Data Intelligence environment (see also slide 26 in DA281_Hands-On SAP Data Intelligence Connectivity & Integration - ver02.pdf)
In case of issues with the credentials for the DI system or other exercise related issues, please reach out to the following e-mail address: sapdataintelligence@sap.com
-
Deep Dive 1 - ABAP CDS View based data extraction in SAP Data Intelligence
-
Deep Dive 3- Technical Background for Replication Flows in SAP Data Intelligence
-
Exercise 1 - Replicating data from S/4HANA ABAP CDS Views in SAP Data Intelligence
- Exercise 1.1 - Consume the EPM Business Partner ABAP CDS Views in SAP Data Intelligence
- Exercise 1.2 - Extend the Pipeline to transfer the Customer data into a HANA Cloud Database with Initial Load mode
- Exercise 1.3 - Implement a Pipeline for delta transfer of enhanced EPM Sales Order data from S/4HANA to an S3 Object Store
- Exercise 1.4 - Extend the Pipeline for joining Sales Order with Customer data for each change in Sales Orders and persist results in S3
- Exercise 1.5 - Using a custom ABAP Operator to verify your Delta Replication of EPM Sales Orders
-
Exercise 2 - Integrate ABAP CDS Views in SAP Data Intelligence Replication Management Flow
Here is an overview about the topics and processes that we will focus on during this hands-on workshop and how they relate to each other.
Support for the content in this repository is available during the actual time of the online session for which this content has been designed. Otherwise, you may request support via the Issues tab.
Copyright (c) 2022 SAP SE or an SAP affiliate company. All rights reserved. This project is licensed under the Apache Software License, version 2.0 except as noted otherwise in the LICENSE file.