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.
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.
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.
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.