Retrieve xml content

[Anonymous]

I have tFileList in my job and in the folder, there are xml files. I want to insert xml's content into database. How to retrieve xml's contents?

[Anonymous]

Hi,

    Please connect a tFileInputXML to tFileList and read the data in iterative fashion. I would recommend to create the schema of XML in repository metadata section first so that schema management will be easy.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

No. I wanna copy the content of xml file and save as backup.

[Anonymous · Accepted solution]

Hi,

    In that case, do the same stuff but read the full file using tFileInputRaw and change the datatype later to String using tConvertType. Then you can pass this value (preferably with an id value also in an additional field) to any DB you want.

    But please have an eye on the size of the data too as it should not cross the DB datatype upper limit.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂