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.
Gilbert,
yes, keeping local SQL data in sync with SharePoint is possible without any coding using 3rd party tools,
Here are the steps:
https://www.layer2solutions.com/support/cloud-connector-faqs/sql-sync-to-office365
It works for all kind of SQL databases, and also all SharePoint editions, including SharePoint Online.
Hope that helps. Thanks, Frank
I know this is an older post - but the landscape for connecting through a data gateway for PowerApps and Flow has changed - from 1 Feb 2019 using these methods will require additional licensing for with either Flow or PowerApps - min P1 max P2 so the cost to do this per user needing to connect could now be prohibitive and push people to move infrastructure up to Azure.
