Use Case: Trying to get changes from our Microsoft SQL Server to automatically trigger Web Service request to an external endpoint using CA Live API Creator.
We have already configured LAC with a working connection to our MSSQL database. We can make changes to the database and it will appear on LAC as well as vise versa from LAC to our database.
Any advice on the workflow and configurations we should make to be able to detect/listen for these changes (new entries, removed, updated, etc) and automatically trigger the web service request to be sent out?
What are some things to consider? I am trying to avoid using the API Gateway because the client does not have this product implemented in their environment.