Forum Discussion
SharePoint List sync with SQL Server Database
Is it possible to establish a sync with a SQL Table and SharePoint list without using third party tool?
- Use Microsoft Flow To Read Data From SQL And Write To SharePoint List - https://www.c-sharpcorner.com/blogs/microsoft-flow-to-read-data-from-sql-and-write-to-sharepoint-list
Yes very much so with the free tool Fusion from NoCodeSolution.com
Rashid Mohammed : Let me know if you figured out a solution for this.
- Hi Rashid,
You can do it elegantly with the free tool Fusion from NoCodeSolution.com
A real sync (two-way) including conflict management, authentications, logging, notifications etc. isn't easy to setup in a few minutes. Try 3rd party products = to start quickly with SQL (any vendor supported) and SharePoint (any version or plan).
Hope that helps.
Thanks, Frank
Take a look at this : http://www.axioworks.com/sqlist
- I was looking something which can be done within SPO without any external app
Have you looked to see if BCS would do what you need? Its for surfacing database content in SharePoint lists. Its more complicated in SharePoint online, particularly if your database is on premise, but there are a lot of great resources out there with guidance on setting up an external content type etc. This link can get you started: https://msdn.microsoft.com/en-us/library/office/hh418045%28v=office.14%29.aspx?f=255&MSPPError=-2147217396
Another possible approach, if you could publish restful service in front of your database, it would be possible to do something with JSLink to grab the choice data for the column.
- Power BI? Let me know your Ideas.
I would like to have a Choice column with options beeing pulled from a sql table. I was thinking of making the a lookup column where the lookup list will be in sync with sql database.
