Skip to Content
avatar image
Former Member

SQL Server call Trigger to SP - SAP PI

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 31, 2017 at 03:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 31, 2017 at 06:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    Hi Rudra.

    This option is for Oracle and I need for MSSQL-

    Regards

    Add comment
    10|10000 characters needed 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.