With this example scenario you can learn how to extract, store, transform and analyse data from several SAP applications using SAP Data Hub. Goal of this scenario is to provide a 360° view on the customer, therefore selected data from SAP Cloud for Customer, SAP Marketing Cloud and SAP S/4HANA is used.
The following picture provides a technical overview of the example scenario:
OData is extracted from various SAP systems via SAP Data Hub pipelines.
The extracted data is directly stored in SAP HANA or the landing zone of a data lake. The example includes pipelines for both options.
The stored data can be cleansed, joined and otherwise transformed either directly in SAP HANA, using SAP Data Hub Data Transform functionality or with the SQL-on-File feature of the SAP Vora database included in SAP Data Hub.
Finally, the data can be used for visualization in reports, analytics or further processing in machine learning scenarios.
You will find detailed information about all these steps and possibilities in the GitHub.
This example can be used free of charge on SAP Data Hub Version 2.7 / SAP Data Intelligence Version 1909 and newer.
Download it. Try it. Give us Feedback about it.