Skip to Content

PI 7.31 single stack 2 SP to html mail. Is it possible?

Hi Gurus,

I got a new requirement where I need to execute 2 different stored procedures (first one has data to be sent, second one has the recipients to send that information) and send a mail in HTML format.

I am wondering if there is a way I can have 2 sender JDBC communication channels to one receiver Mail CC. If so, do I have to add 2 message types in my message mapping? Then, how integration flow should work? I am assuming that if I have 2 MT then I need 2 different operations as in the service interface, but not sure how to match this.


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Mar 09, 2018 at 04:19 PM

    Hi Claudio!

    And how about using one ICo with JDBC lookup in request mapping? You poll the data you need to send and in message mapping you perform lookup to get recipients list for polled data.

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Claudio!

      It depends on stored procedure type and DB provider. For example, in MS SQL Server you can use table-type SP like: SELECT ... FROM SP_Name(). But such SP can't contain DML statements like INSERT or UPDATE.

      Regards, Evgeniy.