Interface scheduling

[Former Member]

Hi Experts,

Is there any way to run one interface after a particular interface run successfully without scheduling the sender channel In SAP PI.

Thanks,

Arthita

[Harish]

Hi Arthita,

you need to schedule the trigger for interface once the first interface is executed, this can be done in BPM.

Or other option is to trigger soap sender channel from first interface which will trigger the second interface.

regards,

Harish

[Former Member]

Hi Harish,

For me sweat able is second one.For first interface RFC to JDBC and second one is JDBC to RFC. How to trigger the sender channel of second one?

Thanks,

Arthita

[Former Member]

Hi Arthita,

In first interface Case- Create one addition column in DB (target JDBC side) to update the status of the message like if successful update as "S" or else keep null.

In second interface Case- Select the record where column value equals to "S" & then update the status  field with some value by writing the update query in Sender JDBC communication channel so that same record will not pickup again from the Database. The moment status is changed to "S" in the DB the second interface will run automatically based on the polling interval in second Sender JDBC Communication channel.

Regards,

Krupa