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.