Forum Discussion
Accessing Web Services and External Databases from SP Online
Hi, Part of a new development we want to address following scenarios 1. Create a client-side (SPFx) component where its logic contains of accessing SOAP web service deployed in on-premise server...
Would it make more sense to use (Power BI) On-premises Gateways to access the data, then use Power BI, PowerApps, Azure Logic Apps, Microsoft Flow to do what you need to do, including SPFX.
- Totally agree with Ali here, what you need to think is in the best way to expose your OnPremises data to easily consume in SPO
Basically, what I read in the Net is that we can use Data Gateways to get the data from on-premise to Azure/power BI store and then use the data for other types of apps like SPFx parts, Power Apps, Logic apps etc. Which seems working for scenarios which we will have to do POC to make sure. Thanks for the feedback to get here for us.
Also additional question, what would be the option for schedule tasks in SP Online (other words, How to substitute the timer-jobs we used on-premise) ?
- I'd look for Scheduling in Azure Automation. https://docs.microsoft.com/en-us/azure/automation/automation-schedules or Scheduled functions with Azure Functions. https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-scheduled-function
