Detect when table gets updated


We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes, or once every day.

We are looking for a real-time end result since the current implementation presents delays in synchronizing data.

Is there a way to trigger our code somehow when data in a specific table gets added, updated, or deleted?