Extract Data from SQL DB Stored Procedure

[Former Member]

Hi Team,

I have a requirement with extracting the data from SQL DB Stored Procedure to SAP PI System. I need a help while writing the Query SQL Statement and Update SQL Statement.

And also I have used the following SQL Query for executed the stored procedure in SQL DB System.

DECLARE @XML NVARCHAR (max) EXECUTE dbo.Stored_Procedure @XML OUT SELECT "@XML" = @XML

once the Stored procedure executed in SQL DB, the Data Displaying as XML file.

Could you please me to write the Query SQL Statement and Update SQL Statement in SAP PI System.

Best regards,

Chandra

[former_member181985]

Select Query: EXECUTE dbo.Stored_Procedure

Update: <test>

[Former Member]

Hi Praveen,

Thanks for your Inputs.

I have a more question is how the source and target data structure look like.

My scenario is JDBC -> SAP PI> Proxy.

Could you please suggest with some example.

Best regards,

Chandra

[baskar_gopalakrishnan2]

You are doing jdbc as sender.. So your source data structure is something similar as below

<resultset>
<row>
<field1>value1</ field1>
<field2>value2</ field2>
<field3>value3</ field3>
</row>
</resultset>

Decide target structure as per your business need and create. You could do as you wish. Also refer this link

http://help.sap.com/saphelp_nwpi711/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm