Hello Mark,
I was just reading your response and I found out that you were also addressing an issue that I am currently trying to solve. Could you say more on this 'external tool' if possible with some examples, please? I mean what you said below.
"You'll then need an external tool that can connect to both Moodle and the external database to call the web service function and make the required database updates."
Thanks