topic Retrieve xml content in Talend Studio

Retrieve xml content

Anonymous — Mon, 15 Jul 2019 04:24:04 GMT

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?

Re: Retrieve xml content

Anonymous — Mon, 15 Jul 2019 15:05:21 GMT

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 🙂

Re: Retrieve xml content

Anonymous — Wed, 17 Jul 2019 03:09:36 GMT

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

Re: Retrieve xml content

Anonymous — Wed, 17 Jul 2019 03:15:15 GMT

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 🙂