XML document convert into String and Insert into Database

[Former Member]

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

[justin_santhanam]

Rajesh,

You can use either XSLT or Java Mapping.

Refer Prakash's reply

Try out that.

raj

[Former Member]

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