XML files in BODS

[vinaya_hg]

Hi Experts ,

I have few dumb questions on using XML files in BODS .

1)Can we load XML files to flat file ?

2)Can we load a IDOC data to a single table or file?

3)What is the use of loading IDOC to XML file?

Please clear me with the concepts.

Regards,

Vinaya

[former_member442248]

Hi.

1)Can we load XML files to flat file ? - You can do that but why you want to do it using DS as the source from where you are getting XML can perform this conversion.

2)Can we load a IDOC data to a single table or file ? - Yes

3)What is the use of loading IDOC to XML file? - Let us say you want to integrate SAP and a non SAP application. You can extract data real time (also in batch mode) in iDOC and integrate it with let me assume Salesforce (or any other app) buy loading as an XML via a webservice

Curious to know how you got these questions. 🙂

Regards. S

[vinaya_hg]

Hi Shazin ,

Thanks for responding.

I already mentioned it as dumb questions.

In the IDOC scenario ,should I use XML pipeline to deal with NRDM before loading it to flatfile or temporary table.

Regards,

Vinaya

[former_member442248]

Hi.

I believe you can un-nest and flatten the hierarchy before loading it in a flat file. Using XML pipeline will be in case you want to extract a specific node within the hierarchy.

Regards. S