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