SmartConnect can be used to integrate documents into your system (I use Dynamics GP and Business Central, it works with both)
If possible, I'd like the source table to be SQL, so that I can mark the records as having succeeded or failed.
This tutorial will detail how to use the before/after document tasks to run a SQL task.
*** if I've not provided enough information, please leave a comment and I'll clarify it.