How to pool an Oracle Database for insert/updates?

, ,
1

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.
Claudio Diogenes

2

The JDBC adapter will allow you to easily configure insert/update notifications. This is the standard approach for database notifications in IS (If you don�t have the JDBC adapter then we can explore other alternatives for achieving the same).
Are there any concerns/special requirements that prevent you from using this approach?

3

It seems we have (the Company) not purchased the JDBC adapter…so, could you please tell us about the alternatives you mentioned in your e-mail (below)?

Currently we just have the Orac App (R11) Adapter
and the Orac DB Adapter.

Best regards
Claudio