My requirement is File to Jdbc and Once the Record has been Successfully inserted into the Table we need to send a mail that the Data has inserted successfully.
How we can Do the Design whether using BPm or With BPM also we can do this?
Here the receiver side is RFC so there is Responce But. In My Scenario the Receiver is JDBC and Once the Data got inserted we need to send mail. Alos in JDBC there is no field for INTERFACE Status.
If i were you, i would have created two different interfaces, one is FILE - PI - JDBC(SP) and once message has been updated properly in DB then update one interface status table (that's the responsibility of SP).
Secondly, read data from that interface status table and eventually send mail.
The example the scenario is FILE - RFC - MAIL, the asyn/sync bridge that Gagandeep suggested has really two receivers, the middelone the RFC and the MAIL, but with the particularity that the MAIL takes the RFC asnwer and all the work without ccBPM. In JDBC receiver you get an answer with the number of row inserted, you can take this value to do or not the mail part.
Sorry, I dont understand what you want to mean with "Interface status field".
Simple option is to create File to JDBC and the Stored Procedure will take care of updating the records after PI fills up with the data. Create one more JDBC to Mail by giving the relevant Polling intervals for the JDBC channel to Pick up the data.....
The response documents described below can only be evaluated by the Integration Server/PCK if the call is synchronous because the content of the response document is not accessible if the call is asynchronous. The response is put in a separate element <StatementName_response> for each statement element.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.