How to poll an Oracle Database for inserts/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?

2

Please don’t cross post. It is unnecessary.

3

Please give more details as whaich version of webMethods components you using, the database etc. In webMethods 6.0 you can configure notification for the above operations using templates provided by JDBC Adapter.