How to trigger an ADF based on any data changes within a table in database

Hello @Nandan Hegde
Thanks for the ask and using the forum .

I think we can always have a trigger run scheduled which can check all the tables in MDS and then update the the sink tables .
When there is no update or insert the trigger runs and does nothing . We can also implement this using change tracking ( I am assuming that you have SQL based MDS ) . I
Lets say that you have the trigger scheduled every 15 mins and it runs at 9:00 AM , 9:15 AM ... .

-----------
Comment 1/2 ------------------------

-----------
Comment 2/2 ------------------------

Best case scenario : We update the data at 9:14 AM and the very next minute ADF triggers the pipeline and start the sync .
Worst case scenario : We update the data at 9:01 AM and now we need to wait for 14 mins before the trigger to fire and updates to complete .
The ask is can you guys wait for 15 mins ? If yes then all ADF / Logic apps / and ASA can solve the problem ,
if not then we can think to call the ADF REST API for every update/ Insert . I dont know if any service does this unless we write something oif our known .

https://video2.skills-academy.com/en-us/rest/api/datafactory/pipelines/createrun

Thanks
Himanshu

Hello @Nandan Hegde ,
We have not heard back from you on this and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu

Hello @Nandan Hegde ,
We have not heard back from you on this yet and was just following up .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .
Thanks
Himanshu

I have a similar requirement as follows- I have enabled Change Data Capture on Azure SQL tables and want to trigger ADF pipeline as soon as there is an entry into CDC table. Can you please help how this can be achieved in Data Factory.