How to Bind sharepoint LIST to a Sql DB table

Question

Is there a way to Bind share point list to Sql Db tables to fetch the updates dynamically. Example: I have a share point list of 2 columns and, I have azure sql Db table with 2 columns. I would like to bind them together so when an update is happened in DB column, respective share point list column data will be updated.

I have tried write a sprint book job to do this but, it is lot of code to maintain. Also we need to manage the real time sync on our own.

I am expecting there might be some out of the box connecter in Microsoft flow, or azure logic app or something automation which will help me automate this.

Answer 1

I would suggest you check BCS so your db data could sync with SharePoint external list.

https://learn.microsoft.com/en-us/sharepoint/make-external-list

Another thread with demo.

https://www.c-sharpcorner.com/article/integrate-azure-sql-db-with-sharepoint-online-as-an-external-list-using-business/