Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2005 at 07:59 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 17, 2005 at 06:55 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.