Skip to Content
avatar image
Former Member

BPM design for trigger based file from Oracle

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 14, 2011 at 09:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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