Business requirement - synchronize a table from external my sql database into SharePoint list.
What I have done. I have an external MySql database which as LOB data. I have created a BCS application which would read the data from the external database into Share Point using External Content types and list.
To keep data in sync, I tried to create a timer job which would access the external list and update another list in sharepoint when a item is added, modified or deleted. However, when doing so, it errors out with the message "ReadList" cannot access the mySql hosts. I tried assigning permissions to the account accessing the BCS service, but in vain. Does any one have a code sample?
Also, is there any other way I could synchronize the data from external database into SharePoint list? I would need to have the SharePoint list to sync automatically without any user input.