Skip to Content
0

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

Mar 09 at 02:08 PM

36

avatar image
Former Member

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.

Thanks!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Mar 09 at 04:19 PM
1

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Evgeniy,

Thanks for the response.

Is it possible for PI to execute an SP in a JDBC Lookup? I thought it was only able to do SQL statements.

0

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.

0