Calling a BLS to execute from a SQLserver Stored procedure

[Former Member]

Hi,

I am using MII 14 and am wondering if there was additional functionality added in MII that allows me to call a BLS to execute from a SQLServer stored procedure.

Thanks

Andy

[former_member202228]

Hi Andy,

Did you see this:: http://www.codeproject.com/Articles/428200/How-to-invoke-a-Web-Service-from-a-Stored-Procedure?? Then you have the /Runner option available

[former_member185280]

In the past I have been able to call a blt from sql server by making an http post to the runner in a stored procedure. Google for something like 'sql server stored procedure http post' and you will get a lot of examples.

[salvatore_castro]

The answer above by Christian is the correct approach...

There are a lot of options for the REST HTTP URL calls to MII, direct to the Runner engine can be synchronously or asynchronously triggered; documentation for this interface is located here:

Transaction Calls Using URLs - SAP Manufacturing Integration and Intelligence - SAP Library  

You can also call into the HTTP Message Services listener layer which can allow you to batch requests or trigger the transactions immediately.  It's an additional layer of monitoring but will enable routing based on a URL parameter or message contents along with message processing status tracking; documentation for this interface is located here:

Message Listeners - SAP Manufacturing Integration and Intelligence - SAP Library

Sam

PS: Generic help documentation for MII is here: SAP Manufacturing Integration and Intelligence 15.0 – SAP Help Portal Page