XML as in put to JDBC Adapter please advise

[Former Member]

Hi

SCENARIO:SQL SERVER TO PI 7.1 TO SAP

We are facing a situation that while executing stored procedures at (inbound side of XI ) from an sql server it returns XML instead of standard resultset.This storedprocedures Resultset in XML format and this are hardcoded is given as input to JDBC adapter which is suppose to convert this into XML which refuses to accept it as input data is already in XML.

Is there a way out.???? please also send any reference or code snippet.

[Former Member]

Hi

Is there any way where u can run the stored procedure and make this xml file get dumped in some folder.

From here u can use FTP (File) -- XI -- SAP

XI Sender JDBC Adapter only accepts resultset

regards

srini