Skip to Content
0

SQL Server call Trigger to SP - SAP PI

Aug 30, 2017 at 02:34 PM

67

avatar image
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?

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

3 Answers

Evgeniy Kolmakov Aug 31, 2017 at 03:16 PM
3

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.

Share
10 |10000 characters needed characters left characters exceeded
Rudra Singh Aug 31, 2017 at 06:56 AM
0

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

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

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

0
avatar image
Former Member Aug 31, 2017 at 03:02 PM
0

Hi Rudra.

This option is for Oracle and I need for MSSQL-

Regards

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

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.

0