Some searches yielded... Database: Event Enable any Database Table
Event Based DB integration
But, I'm guessing that you are looking for a dialog instead of reading threads.
Well, in my case, it is not allowed to have our Oracle and SQL Server servers make a webapi call. This meant, I could not have a trigger/or stored procedure call a web service on Boomi atom to initiate/execute a process.
My solution was to create some custom triggers (on those db servers) that would populate a custom (queue) table with identifier data. Then, have Boomi atom make a call to those custom tables every 1 minute to query if there was any work for Boomi processes... (Since the primary tables were >million records, I could not query them every minute)
Retrieving data ...