How to read a XML file from reomte server location and parsed it in the oracle table.

[Anonymous]

Hi,

I need to read the XML files from remote location server and parse and processed the data in a table on oracle database. How I can achieve it through Talend jobs ?

Thanks 

Prabodh

[JR1]

Sorry, but you will have to provide much more information than just that. Based on this alone, I would suggest looking at tFileList, tExtractXMLField, tMap, tDBOutput. If you provide more information, someone here might be able to help you.

[iamabhishek]

Talend can not read data on the fly from remote localtion. So, you have to first use FTP connectors (tFTPConnection, tFTPGet etc...) to get the files from remote location to local and then read the XML files (tFileInputXml) and load to Oracle using Oracle db connectors(tOracleConnection, tOracleOutput etc..)