Forum Discussion
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 Created a External content type external list in SharePoint.
Now I need to conform this requirement is possible for me.
there are two list in SharePoint 1. custom List and 2. external list
User will add and edit rows in custom SharePoint list, that same data will be created to external List (this was connected to Azure SQL).
can anyone help me to resolve this.
Thanks
- 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
7 Replies
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.
- 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 FunctionsThanks Juan Carlos,
i have created a tigger flow in sharepoint List, if any Items added or modified in Sharepoint List the Microsoft Flow will add or update the items in Azure SQL..
Its working good..
thanks again.
- Glad to help!
What is the problem you are trying to solve? What is the business case for needing two separate data sources with the same content? Perhaps there is a better way...
i need Read only access to the sharepoint custome list from desktop application, so direcly accessing sharepoint list through MS Access creating performance & networkng issue...
so i have idea to create duplicate data from sharepoint list to external list (Azure SQL) then access desktop Application from Azure SQL table.
- Why not have the desktop application pull the data directly from the SharePoint list using REST/ODATA?
