Page 1 of 1

how to read xml file in Datastage

Posted: Mon Aug 24, 2009 12:31 am
by tanmaya
Hi,

I have an xml file in my server which I need to use as a source for the input to the webservices transformer used in my job.

I need to ask that whether is there any stage in datstage to read the xml file. What I mean here is that for reading text files or csv files we have SEQUENTIALFILESTAGE, so please let me know if there is any stage using which I could read xml file.
It is urgent.

Please respond.

Thanks in advance

Tanmaya

Posted: Mon Aug 24, 2009 3:17 am
by sankar.td
Hi ,


There is XML Input and Out put stages are there in "REALTIME" Tab.

Using those stages we can retrive data from XML Sources.

these links may help ful to you.

http://download.boulder.ibm.com/ibmdl/p ... _0508I.pdf



http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

Posted: Mon Aug 24, 2009 5:10 am
by tanmaya
sankar.td wrote:Hi ,


There is XML Input and Out put stages are there in "REALTIME" Tab.

Using those stages we can retrive data from XML Sources.

these links may help ful to you.

http://download.boulder.ibm.com/ibmdl/p ... _0508I.pdf



http://www.ibm.com/developerworks/data/ ... 1&S_CMP=FP

Hi Sarkar,

Thanks for the help,but I dont need to convert xml to tabular data. It is that i just need to read an xml file as it is and then pass the exact file to the web service transformer. This is because the web service transformer needs the data in the xml format only not in the tabular format.

The xml input and output stages just covert from tabular to xml and vice versa respectively. i dont need any modification.

please let me know if you anything like this.

Tanmaya

Posted: Mon Aug 24, 2009 5:32 am
by chulett
Read it with the Folder stage.