How to use XML file as a source file

Gopalraja · Post by **Gopalraja** » Wed Apr 15, 2009 11:12 pm

Hi,
In my job XML file is used as a source. I want to know how to get the data from this XML file and load it to target table or csv file format.

Could you pls help me out...

Thanks in Advance...
Aswice

Gopalraja · Post by **Gopalraja** » Wed Apr 15, 2009 11:49 pm

Hi,

Anybody know how to use the XML file as a source...

Aswice

jhmckeever · Post by **jhmckeever** » Wed Apr 15, 2009 11:59 pm

Hi,

There are a number of ways, depending upon your requirements, although the easiest will almost certainly be to use the XML Input stage. <a href="search.php">Search</a> for it on dsxchange.

You can also read Ernie's excellent blog entry on the topic: http://dsrealtime.wordpress.com/2007/12 ... -a-source/

An alternative I have also used (for a variety of reasons) is to use an External Source stage and flatten the XML using an externally-defined XSL stylesheet. I'd stick with the XML Input stage.

John.

chulett · Post by **chulett** » Thu Apr 16, 2009 8:23 am

Gopalraja wrote:Anybody know how to use the XML file as a source...

Yes, of course. However, you need to learn patience - you bumped your post again after what - 30 minutes? Give me a break. You're lucky John was able to respond as quickly as he did, don't come to expect it though.

saqib · Post by **saqib** » Tue Jul 28, 2009 5:12 am

Gopalraja wrote:Hi,
In my job XML file is used as a source. I want to know how to get the data from this XML file and load it to target table or csv file format.

Could you pls help me out...

Thanks in Advance...
Aswice

As said by jhmckeever you need to look for the 'XML input' stage in DS8.0.
Import the table definition for respective xml file.
your parallel job will atleast have the following stages,

row generator-->xfm1-->xml input-->xfm2-->sequential fle

In xfm1 give the path of your xml file in derivation of the column that will be mapped from row generator stage.

In the xml input stg under input pg>xml source>column content select URL/file path.
Load the table definition in the output pg which was imported in the begining.

In the sequential file stg, set the field delimiter as 'comma' to get the o/p in csv format

Kindly let me know if i missed out anything

cheers!!

dspradeep · Post by **dspradeep** » Tue Nov 17, 2009 5:51 am

what u mean <B> xfm1 </B> in the below

row generator-->xfm1-->xml input-->xfm2-->sequential fle

ray.wurlod · Post by **ray.wurlod** » Tue Nov 17, 2009 6:23 am

Please strive for a professional standard of written English here on DSXchange; it makes life easier for those whose first language is not English, and shows respect for other posters.

chulett · Post by **chulett** » Tue Nov 17, 2009 6:23 am

"xfm" would mean a transformer stage.

dspradeep · Post by **dspradeep** » Tue Nov 17, 2009 7:54 am

can u tell me how to use

Rowgenerator--> Transaformer stage here

bcz i have developed the job like

seqfile-->xml input --> oraclestage

now i am facing one problem like if i got a file with above 7kb then job get aborted so i am looking other solution .

if my understanding is correct for your design is

Rowgenerator -->for dummy purpose
Transaformer -->you are passing path info

let me try whether it will solve my issue.

everyone said we have to use External source stage but my server is in windows so i am facing some issue in that stage. i believe we need to install 7.5x.2 ESS patch in my server mechine for ESS.

chulett · Post by **chulett** » Tue Nov 17, 2009 8:32 am

Please start your own post, and stop asking U for help.

DSXchange