I once worked on a db where for security reasons no third party connections were allowed. No Apple Events or similar connections.
We create a folder for receiving and one for sending data.
We would look at the receiving folder and see if new files were in it and if so we would import them. These particular files could be blobs, a record with data for many tables that a script would look at the record and determine what tables fields etc to use.
It was an interesting project where photographs, text, etc from various tables where contained in one text file rather than one text file containing many records from one table.