I'm new to SharePoint and trying to get BCS working with external content. I need to "replicate" native list to an external SQL DB for my project. So I use the crated/changed workflow start options to propagate insert/update to external data store, however this didn't work when deleting items in SharePoint list as I see no delete activities on the external data source to "sync" with SharePoint native list. We would like to use SharePoint native list for workflow/task features while "replicate" the transactions to an external SQL DB for data manipulation.
Does anyone know a better (efficient) way to push out and synchronize external data? Is it possible to use the built-in delete (icon within list item ribbon) and trigger external delete as well? I have SharePoint 2013 site (on-premise) and designer as my resource.