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 to retrieve some data needed
2. Create a client-side (SPFx) component where its logic contains of accessing SQL and MS Access databases deployed in on-premise server to retrieve some data needed
How would you recommend above to be implemented? any links appreciated if someone else already implemented above
Also, for the 2nd scenario, if we migrate SQL and access data to Azure, would it be better approach aligned with office 365/Online?
5 Replies
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) ?
