Objective: Write csv file of updated data from sql table only after SQL table update, insert, delete.
I've read from the community that I should not do triggers to execute python. I should not run triggers to write to file from within sql. Also, my IT keeps the environment very very restricted and I can't use XP_cmdshell, or sqlcmd.
I have python in windows. This must be a very common task. Yet, surprisingly, it's hardly mentioned. Perhaps I'm using the wrong search terms. Please no expensive software suggestion. I can't ask the IT to buy it.
How can I execute python only after the sql table updates?