Skip to Content
avatar image
Former Member

XML document convert into String and Insert into Database

Hello all,

In the FIle to File Scenario I want to send the data to the Reciever System in xml Document and convert into String and insert into Database.

Please can you tell me exact way how to send it.

Thanks & Regards,

Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 04, 2008 at 06:04 PM

    HI,

    As per my understanding your scenario is File to file where you will get output fiel in XML format.

    Now that XMl payload need to be passed as single string in the database via XI.

    You cauld do this but you need to imply some manipulations such as

    With the help of standard API you need to concatenate the XML tags and create the structre along with the data.

    For e.g. in your outpuf file the XML structre contain data as

    <field1>ABCD</field1>

    Then in mapping

    The source field will be mappeda s concat(<field1>) + value of Source field "ABCD" + concat(</field1>) to the target field.

    This is the way that you could achive the requirments else there is no direct way avaialble for it.

    thanks

    Swarup

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04, 2008 at 06:04 PM

    Rajesh,

    You can use either XSLT or Java Mapping.

    Refer Prakash's reply xml-payload-in-a-single-field

    Try out that.

    raj

    Add comment
    10|10000 characters needed characters exceeded