conversion of XML data into RDBMS data

[Former Member]

Hi,

i want some information regarding the conversion of XML data into RDBMS data

Thanks,

Rajendra

[Former Member]

Hi Rajendra,

Conversion Agent is a third party tool from Item Field. It is basically used to convert EDI, Excel, PDF etc.. documents into XML format and makes simple to integrate in XI.

/people/paul.medaille/blog/2005/11/17/more-on-the-sap-conversion-agent-by-itemfield

/people/alexander.bundschuh/blog/2006/03/14/integrate-sap-conversion-agent-by-itemfield-with-sap-xi

/people/paul.medaille/blog/2005/11/18/conversion-agent-a-free-lunch

/people/william.li/blog/2006/03/17/how-to-get-started-using-conversion-agent-from-itemfield

All you need to know about conversion agaent can be found here:

https://websmp102.sap-ag.de/~sapdownload/011000358700001090982006E/ConvAgentDocSP16.zip

https://websmp102.sap-ag.de/~sapdownload/011000358700004921152005E/ConversionAgent.pdf

/people/sap.user72/blog/2005/07/27/xi-generate-pdf-file-out-of-file-adapter

/people/sap.user72/blog/2005/07/31/xi-read-data-from-pdf-file-in-sender-adapter

/people/alessandro.guarneri/blog/2007/02/21/sap-xi-acting-as-a-huge-file-mover

Regards,

Sarvesh

***Reward Points if found helpfull.

[Former Member]

Hi Rajendra,

I guess ur scenario should FILE->XI->JDBC.

The file adapter will pick up the XML file from the File server and ity will be transformed into db format and pass into SQL server.

u can have a look @ this link.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regrads

Biplab

<b>**reward if it helps u!!</b>

[former_member189387]

Hi ,

<b><i> i want some information regarding the conversion of XML data into RDBMS data</i></b>

Means , you need to know the XML Structure for RDBMS right ?

Please go through this links

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

/people/prasadbabu.nemalikanti3/blog/2006/02/27/collecting-and-bundling-vendor-records-from-different-multiple-interfaces-file-systempeoplesoft-and-sending-to-sap-r3-system-part-2

Regards.,

V.Rangarajan