SQL Server call Trigger to SP - SAP PI

[Former Member]

Hi Dear Experts.I had a new escenario JDBC(SQL→ to ECC). My client now needs to send data to PI when a new record have been recorded in table then a trigger will call an store procedure and then call to PI.

Its possible?

[former_member190293 · Accepted solution]

Hi Luis!

If you need the push mechanism from DB side the one of the ways to achieve this is to use web service call from within stored procedure.

Regards, Evgeniy.

[former_member303454]

Hi Rudra.

This option is for Oracle and I need for MSSQL-

Regards

[weberpat]

Anyway this won't help you getting the notification you want. You'll need something along the lines of what Evgeniy suggested, i.e. a notification sent to PI in response to a database trigger. If you google "call web service from mssql stored procedure" you'll find a series or articles that will get you started.

[Former Member]

Hi Luis,

Yes, you can write a stored procedure and call in sender JDBC channel.

Please find the link below.

https://blogs.sap.com/2013/03/06/executing-stored-procedure-from-sender-adapter-in-sap-pi-71/

Warm Regards,

Rudra

[weberpat]

I think this is not going to cut it. The OP needs a trigger mechanism from database side.