Forum Discussion
Solved
Sync Data from Sharepoint Custom List to External List
Hi all., I am using Office 365 SharePoint online Plan 2, and Azure SQL database. I have successfully connected Business Connectivity Server for Both SharePoint & Azure SQL. I have Successfully Cre...
- Well, Indeed what you need to do is just write from your list into the SQL Azure database that is behind the scenes...there are some approaches you could use here:
(1) Since it seems you want to add the data in the SQL Azure database when a new item is added into the list, then you need to be able to react the event triggered by SharePoint when the item is added. To catch this event you have some options: a.) A Remote Event Receiver b.) a Web Hook c.) a SPO Workflow d.) a Flow
(2) Instead of adding the data to the SQL Azure database just at the moment is added to the list, poll the list for new items and add to the database. You could do this by means of a programmatic job implemented in an Azure WebJob / Azure Functions
Mohamed,
you can keep SharePoint lists in sync with almost any external data source, including SQL Azure, using the Layer2 Cloud Connector code-free. The tool runs as a Windows Service in your local network or your own Azure cloud. You will find connectivity settings, best-practices, known issues and workarounds for data integration and file synchronization with 100+ IT systems here:
https://www.layer2solutions.com/solutions/general-data-integration
Hope that helps, thanks Frank.