Hello all,
I was searching online to find a way to retrieve data from SAP HANA to store to the Dataverse using Power Automate ( or any tool in the Power Platform), but I couldn't find anything besides using Power Automate Desktop Flows which are expensive and would like to avoid them.
Looking at cloud flows, all I could find was 2 SAP ERP connectors, but I'm not sure if the "Call SAP function" connector would be of any use. The same connector exists in Power Apps, but for updating some records in the Dataverse, Power Automate would be better.
See below image for reference:
I also saw the Dataverse Dataflows have the SAP BW Application Server, but I believe that is different. Here is a screenshot for reference:
If someone has investigated this in the past and knows if it's possible or not, their input would be hugely appreciated!

Report
All responses (
Answers (