In this step we'll setup the dataflows from the SAP System and Cosmos DB towards the Synapse DB. Sales OrderHeaders will be extracted via the first Synapse pipeline using the SAP ODP connector (Optionally you can use the SAP Table Connector), Sales Order Items will be extracted via a second Synapse Pipeline using the SAP ECC (oData) connector. Payment data will be extracted from CosmosDB using a third pipeline.
Please follow the sections beneath to setup the dataflows.
See Extracting Sales Order Headers using ODP Adapter
Note: you can also use the SAP Table Adapter to extract the Sales Order Header, see Extracting Sales Order Headers using the SAP Table Adapter
See Extracting Sales Order Line items
After setting up the Dataflows and extracting the data, you can continue with the PowerBi Visualisation