Forum Discussion
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.
10 Replies
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.
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/
How much data? there are always ways :)
A poor mans approach would be to create an Access database with linked tables to each location and update/append/delete queries as necessary.
Layer2 has some tools that do this http://www.layer2solutions.com/en/products/Pages/CC-SharePoint-Features-and-Benefits.aspx
Thanks Dean_Gross for the suggestions.
I am aware of the Layer2 solution though would not be applicable in this case.
Gilbert
- 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.Thanks jcgonzalezmartin. I would like to explore the WCF option. Will look it up or do you have some references you've used before?
