How to send data from SQL Server Store Procedure to XI?

[Former Member]

Hello,

Until now we've seen examples that shows how to connect XI to SQL Server using the JDBC Adapter.

What about the reverse way: SQL Server to XI? We'd like to now if it's possible to invoke a sentence inside a Stored Procedure that sends data to XI in XML format so XI receives the data and then process it to send it to a R3 for example. Could anyone provide some feedback? Thanks in advance.

[Former Member · Accepted solution]

Hi Elias,

There are many ways you could push data from SQLServer to XI.

let us say you have an interface defined in Xi adn have exposed that as a webservice. You could then consume this webservice from SQLServer in a stored procedure or Use DTS package (Webservice Task) for calling a webservice from SQLServer to XI.

cheers,

naveen

[udo_martens]

Hi Elias,

you have some alternatives:

Using JDBC receiver adapter: XI triggers the call of stored procedure.

JDBC sender adaper: Use a execute statement.

(both described in documentation:

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

HTTP adapter: Use XI host, port 8000 plus Sys No, Path: /sap/xi/adapter_plain?service=<myService>&interface=<myInterface>&namespace=<myNamespace>&QOS=EO

Regards,

Udo

[Former Member]

Hello Udo,

But what I need is to execute a statement inside a Stored Procedure that could call perhaps a web service method in order to send data from SQL Server to XI, so SQL Server triggers the call not XI.

Regards.

[udo_martens]

Elias,

for this case use the third alternative.

Udo

[Former Member]

Hi Elias,

we have something similiar, we have an trigger (update) on our DB and if it's fired we send an http request to XI BPM so XI knows there are some data to fetch and starts a query -> mapping -> R3.

May this could also helps you.

Regards Matt