Create XML file from CLOB field in SQL Server

Anonymous — Sat, 16 Nov 2024 03:07:27 GMT

Hello Team,

We have an scenario where we need to read the data from the Table in SQL SERVER database. Table will contain 3 String field and 1 CLOB field, The CLOB field will contain the complete dump of XML. The table will contain ~1000 ie 1000 XML.

ID	Date	Name	DATA (CLOB)
1	1/1/2020	Policy1	<DATA> ……..</DATA>
2	1/1/2020	Policy2	<DATA> ……..</DATA>
3	1/1/2020	Policy3	<DATA> ……..</DATA>

We need to design a Talend Job to read the data from Table and create 1000 XML with name from NAME field dynamically using single Talend Job. Any suggestion/ Input is much appraciated.

@nthampi @skiran - Any suggestion /Input would help !! Thanks

topic Create XML file from CLOB field in SQL Server in Talend Studio

Create XML file from CLOB field in SQL Server