Enable the integration between Power Platform and SAP to announce changes in SAP to Power Platform asynchronously and so not in realtime, without coupling the both systems. A good design will take in consideration the existing design related to SAP (see image below).
...
Context and Problem
Current architecture implying a front door (micro-service) is mandatory. Direct access to SAP is not allowed.
No current integration between Power Platform and SAP. Power Platform is a SAAS in the public Internet even if it’s in the backbone of Microsoft.
For now, there is only a one-way communication, from SAP to Power Platform. Data transfered from SAP is not considered as confidential.
Data volume is not substantial : about 2 thousand records could be affected in Power Platform. Not a case of intensive computing and long-running functions.
Hybrid scenario is highly recommended regarding the current architecture related to SAP and the willing to upgrade the latter to Hana.
...
Solutions
Technology choices
Information below is established according the context (data volume, etc.). We know that Azure provides a multitude of services (as IAAS & ad PAAS).
...
Regarding the fact that the Azure ecosystem is not ready, the privileged solution would be the service deployed in an on-premise server.
...
Daily schedule will trigger the service (executable with extension .exe) in the Windows Server.
The executable will initiate an FTP connection (ftps) to connect to the root folder in the file server.
The executable will extract the CSV files stored in a specific folder in the file server.
With the app registration in Azure Active Directory (AAD), the executable will connect to Power Platform.
The executable will push the data coming from SAP to Power Platform Database using the SDK Client (Software Development Kit).
During the process and at the end (failure or success), it will log the transaction in a file stored in the file server and in the server in which it has been deployed.
Different scenarios for the 2nd step of the integration
The integration between is not really complex because the system A (Power platform) sending data to system B (SAP) does not expect a response from the latter. And, vice versa, the system B (SAP) does not expect a response from system A (Power Platform).