Hi,
The case is: We have a custom Fiori app built in BTP CF and available in the Launchpad Service. The application contains a list, which should display aggregated data from many ECC/S4HANA systems. Each on-premise system exposes the same OData Service. Becasue of the security and overall architecture, we cannot have a central OData (on-premise) aggregating the data from all systems and exposing it to the UI. It means we need aggregate the data in BTP.
What's the recommendation to achieve that? We need to request the data using OData Services from all required systems, then merge the results and expose to the Fiori app. The way we expose it is not that important (it might be some kind of central OData, or anything else).
Is CAP designed for this kind of scenarios? Or custom Node.js module would be required? Is ABAP environment in Cloud another option?
I would be grateful for any hints, recommendations or examples.
BR,
Adrian