Does anyone know any reasons why you would use one over the other?
Other than the Adapter notification is used by adapters.
I have a scenario where I need to have something happen when a row is inserted into a table, a doc needs to be published and then the row needs to be written to an archive table and deleted from the source table…
Any thoughts on which way to use or is it more a preference thing not neccessarily a Best Practices thing?
Adapter Notification is automatically generated by the webemthods when a row is inserted in the database table(or any DML is performed in database table). Publishable document is published with your own data in the document.So it is different from the adapter notification document.
Can you tell the difference between archive table and source table.