We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and External list.
My question is: how can I trigger a workflow or external event receiver when the system/application creates/logs an entry in the database? We use the external list to view the data only, we don't create or update items residing in the external list. How can I notify the user when there is a change in the SQL database (table) which is used in the BCS to view the data only.