BPM design for trigger based file from Oracle

[former_member208113]

Hi

We have one requirement as follows:

1. We need to receive trigger file from Oracle.

2. As soon as we recieved trigger file, it needs to activate all other 10 JDBC adapter channels.

3. once reciever all 10 RFC channels completed, it needs to pass that trigger file.

Please suggest design.

Thanks

Siva

[Former Member]

Hi Siva,

1. We need to receive trigger file from Oracle.

define a sender CC (FILE) which polls a directory every N seconds.

The receiver of this message should be your BPM.

2. As soon as we recieved trigger file, it needs to activate all other 10 JDBC adapter channels.

in your BPM, trigger your 10 sender CC (JDBC). See sap help and blog to know how to trigger externally a CC. Easy to do.

3. once reciever all 10 RFC channels completed, it needs to pass that trigger file.

Then always in your BPM, you have to do a correlation on the 10 SQL responses (that's crazy!). Several blogs and threads on this subject.

And after that, in BPM what do you do of these 10 SQL responses (thats' crazy!) ? do you have to merge data ?

Welcome to the birthday of a future monster... for dev and maintenance... Sincerely simplify your flow!

Question: do you really need to have 10 SQL? for your needs, is it not possible to create a stored procedure in database which will do the 10 SQL (with Join tables)... if yes do it, by tis way you will have only one Sender CC (JDBC) to trigger, and no correlation in a BPM. That will greatly simplify your flow.

Regards

Mickael

[former_member208113]

Hi Mike

Thanks for your reply!!!

I have to post the 10 different SQL responses to 10 different BI RFC data sources. My scenario will be once XI recieved trigger file from oracle, all 10 channels needs to execute parallely and response needs to pass to SAP BI server. Please suggest the design structure,

Regards

Siva

[baskar_gopalakrishnan2]

You might want to go through the pattern BPMPatternSerializeMultipleTrigger. This design is preloaded with PI and available in the swcv SAP BASIS.

[rajasekhar_reddy14]

Hi,

Your requirement looks bit complex and maintaining relationship also bit difficult,may be you can achieve this using ccBPM,but i suggest you to divide interface in multiple(if business allowed) so that you can have more stability.

Regards,

Raj