2.0 Introduction
Welcome AWS Data Lakes Workshop
A walkthrough of data extraction patterns for SAP applications. The intent of this workshop is to educate about data extraction methods to extend your SAP data to AWS data lakes. For this Lab, We will focus on SAP ERP (S/4HANA, ECC, CRM, and others) and SAP BW applications as the source. This is where vast majority of AWS customer requirements in extracting the data to S3.
Prerequisites
- AWS Account
- SAP NetWeaver ABAP >=7.51 on HANA
Part 1: Presentations
Depending on how much knowledge and experience you already have about AWS, this part may come with the following presentations:
- Introduction of the team, some words about logistics
- Overview of AWS in general
- Overview of the AWS Extend Strategy for SAP Workloads
- Architecture of the workload you’re building today
Part 2: Hands-on Labs (subject of this site)
- Lab 1: Learn how to navigate in SAP Systems and execute transactions.
- Lab 2: Extract data from SAP using SAP Operational Data Provisioning (ODP)
- Lab 3: Extract data from SAP HANA Database using Python Library
- Lab 4: SAP Application Extraction using SAP IDoc Framework
- Lab 5: SAP Application Extraction using SAP Data Services with ODP
- Lab 6: SAP Application Extraction using SAP Data Services with SLT
- Lab 7: SAP Application Extraction using SAP BW Open Hub
Architecture Patterns for SAP DATA Extractions
End-to-end enterprise analytics:
A sample high-level architecture for end-to-end enterprise analytics is shown below. In this architecture, customers can extract data from SAP applications using the patterns to be discussed in this lab and combine it with non-SAP application using AWS services to build end-to-end enterprise analytic
High-level architecture can include Amazon S3, Amazon Redshift, Amazon Athena, Amazon Elasticsearch Service, and Amazon QuickSight. Other visualization solutions like Kibana and SAP Fiori Apps can also be a part of the solution:
Further information
Building data lakes with SAP on AWS Blog
Database-level extraction
Extracting data from SAP HANA using AWS Glue and JDBC
Application-level extraction
SAP IDoc integration with Amazon S3 by using Amazon API Gateway Blog
AWS Cloudformation Apigw Sap Idocs Githup page
Operational data provisioning–based extraction
Sample application for extracting data from SAP applications
File workloads data Extraction using SAP PI/PO and CPI