Forum Discussion
SharePoint List sync with SQL Server Database
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.
Richard Bourke & the original poster of question or anyone?
Did you figure out a way to accomplish this? I have the exact same situation where I want to connect some of the lists in the SP online site to tables in our local SQL Database (not on azure or cloud hosted)
Use Case: for one example the 'Branch managers' list with Manger Name & Employee ID should be in sync with the 'Branch Managers' table in the SQL DB. The purpose of doing so is when we fill out a request form in Sharepoint, the Branch manager dropdown looks up branch managers list which should have the branch manager information as per SQL table (which is the golden copy of data)
