Event Handling in JDBC sender adapter

[Former Member]

Hi,

please help me in this scenario.

Scenario is Third Party will update the Header and Item values in to Database table.

Once the update is done , a program will run in Thrid party system and it will update the Event Table with the primary key value of the DB table.

So my JDBC sender should be looking for the event table updation. Whenever there is an update in the event table the JDBC sender should automatically kicked off and it should select all the field in the DB table where the primary key = Event table.primary key and the values will be generated as an Idoc.

1.How will i achive this scenario.

2.How to configure the JDBC sender Adapter which gets triggered automatically when there is an updation in event table.

please advice.

Thanks,

Sujatha

[santhosh_kumarv]

Hi,

>>2.How to configure the JDBC sender Adapter which gets triggered automatically when there is an updation in event table.

There is way to control the Communciation Channel externally. Refer this help document http://help.sap.com/saphelp_nw04/helpdata/EN/45/0c86aab4d14dece10000000a11466f/content.htm.

Or alternately you can create a query that always queries only the updated record and configure the JDBC adapter which would periodiocally look the DB...

~SaNv...

[Former Member]

I'm not sure, but RemoteConfiguration (http://help.sap.com/saphelp_nwpi711/helpdata/en/7a/f935c6e131ae488628338b08188188/frameset.htm in EhP1 for PI) might just be what you're looking for