Can I store JDBC Adapter Notifications trigger query data on Buffer Tables in different database of different vendor than the DB they are monitoring?
Will appreciate a response ! Thanks !!
If the triggers used to populate the buffer tables from the source tables can access the tables of a remote DB then yes. But you’ll need to use Basic Notification only (which I recommend anyway).
That said, I think this is probably a bad idea as this will force the use of distributed transactions, which has a variety of implications.