Parse XML from Google Drive Using Talend Open Studio

Rate this post

On this part we will see how we can load XML from Google Drive. I have below XML stored in my won Google Drive account, which is available for Download and view. So first of all please check you are able to download it. 

Required Things For Demo.
Sample XML (Download)
Talend Open Studio Installed

Here is our Sample XMl, you can Download it from above link. 


    
   <?xml version=”1.0″ encoding=”UTF-8″?>
<Itmes>
<item id=”111″ clientName=”SB”>
<details>
<detail child_id=”1″>
<name>Pen Drive</name>
<amount>2</amount>
</detail>
<detail child_id=”2″>
<name>Flash Drive</name>
<amount>20</amount>
</detail>
</details>
<tags>
<tag tag_id=”1″>
<name>CD</name>
</tag>
</tags>
</item>
<item id=”112″ clientName=”GJ”>
<details>
<detail child_id=”1″>
<name>Flopy</name>
<amount>1</amount>
</detail>
</details>
<tags>
<tag tag_id=”1″>
<name>USB Drive</name>
</tag>
<tag tag_id=”2″>
<name>USB 2.0</name>
</tag>
</tags>
</item>
</Itmes>

       
   

  • Create a new job named as “XML_From_GDrive_2_CSV“.
  • Create Metadata for above sample XML file using Metadata repository wizard see below screen.
XML Metdata
  • Once you Created Schema/ Mapping then Drop the tFileInputXML from metadata you created in the Job and make it as Built in.
  • Drop tFileFetch, tFileOutPutDelimited.
  • Configure tFileFetch property as below screen.
  • Set above XML download path in URI property.
  •  Now configure tFileInputXML with our Download Directory path with file name as below.
  • Drop tFileOutPutDelimited and configure as mention in below picture.
  • Your final job will be look like this run the application and check for result it will be shown you result we can see here.
  • Output 

About Umesh

I am Software consultant with approx 7 years of experience mainly in Business Intelligence and data warehousing assignments using Talend. Writing is not my passion but i am doing it to help others. if you have any special case where you want me to demonstrate then please post me.

Leave a Reply

Your email address will not be published. Required fields are marked *