none
Namespace issue in xml generated from SAP using BTS 2013 R2 RRS feed

  • Question

  • Dear All,

    I am facing issue in consuming xml in SQL using OPENXML which is generated using SAP WCF adapter .

    Here I don't see namespace as xmlns:xsi=http://microosft.LobServices.Sap/2007/03/Rfc

    instead I see without :xsi  as   xmlns=http://microosft.LobServices.Sap/2007/03/Rfc

    due to which I cannot able to consume xml in SQL db using below query

    EXEC

    sp_xml_preparedocument@DocHandleOUTPUT,@XmlDocument 

    -- Execute a SELECT statement using OPENXML rowset provider. 


    SELECT

    * 


    FROM

    OPENXML (@DocHandle,'/Data_Domestic_WRT_SALES/Warranty_Item',2) 

         

    WITH (MATERIAL  nvarchar(20)) 


    EXEC

    sp_xml_removedocument@DocHandle




    -- Regards Sandeep





    Wednesday, November 23, 2016 11:57 AM

All replies

  • Well...I would say your first problem is using OPENXML to begin with.  I can't think of any reason why OPENXML is a better pattern then standard BizTalk tools, Maps, SQL Adapter, etc.

    Can we help you develop an app the doesn't use OPENXML?

    Wednesday, November 23, 2016 3:43 PM
  • Dear Johns,

    Thanks for your reply.

    We use OPENXML when BizTalk gets xml from SAP and give to destination system which only consumes xml.

    They consume data in SQL database using Stored Procedure where they use OPEN XML to read xml and push to SQL table.

    We are getting header tag from SAP as,

    '<Data_Domestic_WRT_SALES xmlns="http://www.w3.org/2001/XMLSchema-instance">

    instead of

    '<Data_Domestic_WRT_SALES xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">


    -- Regards Sandeep




    Thursday, November 24, 2016 7:14 AM