The following integration has to be implemented in my Integration Server (IS):
Every time an insert or update operation is performed in an Oracle Database, the changes have to be reflected in an Oracle Applications v11. I have the Oracle Applications and Oracle Database Adapters already installed in the IS.
Is there any way to monitor the oracle database in order to notify (i.e., the IServer got to know that some change occurred in the Orac DB) that an insert or update operation was performed without using a Publishing-and-Subscribe Model?
If I decide to use the Publishing-and-Subscribe Model, is a JDBC adapter required to do so?
The Publishing-and-Subscribe Model is the best way to implement this notification service?
Thanks & Regards.