The out-of-the-box Audit Message Receiver JDBC Delivery Plugin maps JSON fields to column values in an external database via a JDBC interface. The messages sent via the sendMessage interfaces for topics to which the plugin subscribes are assumed to be a stringified JSON structure (i.e., a JSON structure converted to a string). When the plugin receives a message, it will be converted back to a JSON structure and processed (in this case, written to a database via JDBC).
Below is an example output of audit messages sent to an external Oracle database table. Multiple target tables are supported. Mapping from the database tables within STEP to the external database is performed by JSON object Key:Value mapping to these database table columns.
