Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create XML file from CLOB field in SQL Server

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 

Labels (4)
0 Replies