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.
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
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.
- 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?
