Introduction

One of the key questions on S/4 implementation projects is how to build a Cloud Data Platform which will federate SAP and non-SAP data. 

The main topic here is always the different options to extract the SAP S/4 data to an external Data Platform. 

This article will provide an overview to integrate with Snowflake, Databricks and Azure DWH. It is focusing on an Azure PaaS environment to host the target Data Platform.

Also, we are looking on the use case of  AI solution to boost the data modelling in the Data Platform.

The illustration below provide an initial comparison of different extraction and modelling options:

The second option can be  quick win for lot of organization to replicated SAP data to a Cloud Platform with. Here the biggest challenge is, how to remodel the complex SAP data model (table dependencies, select statements) in the target Data Platform?   

In this case, it can be a high value added to leverage the code generation possibilities on an AI solution

More details on the AI solution for SQL code generations are explained in this article