Forum Discussion
Solved
Connecting SQL On prem to SharePoint Online
Dean_Gross: To transfer or sync data from SQL Tables (onprem) to Sharepoint online list, is there a way to do that without using BCS and Hybrid?
- Or you could:
- Use BCS in SPO to create an external list that renders your SQL Data...but you would need to make your SQL Server accesible from the Internet directly or by means of a WCF Service.
- Write your custom code that read information from the SQL Database and write on the SharePoint list(s)
- Explore the possibility that PowerApps brings to integrate OnPremises data in SPO.
You could use the Enterprise Data Gateway and Microsoft Flow to do this.
Cheers
Thanks John White. This is something I was exploring but my concern is that MS Flow is still under preview and would not be advisable in a prod environment.
- Gilbert, I think you could start with the following blog: https://blogs.msdn.microsoft.com/steve_fox/2011/11/11/leveraging-windows-azure-wcf-services-to-connect-bcs-with-sharepoint-online/
- Thanks Juan