on 11-16-2005 6:21 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.