topic Re: Process XML field from SQL Server Xform to PostgreSQL table in Talend Studio

Process XML field from SQL Server Xform to PostgreSQL table

Anonymous — Sat, 16 Nov 2024 10:58:19 GMT

Hi ,
We have XML field from SQL server for one of our tables with data look like ""<values><value>1182</value></values>"
But when we try to map to PostgreSQL tables to XML datatype , we didn't find any matching DB type neither in SQL server Input component(tMSSQLInput) nor in PostgreSQL output component(tPostgreSQLoutput).
We try to use "document" datatype but our source data is not in proper XML tree structure. so parsing is challenge
we can handle with String datatype-> VARCHAR .but Can someone please suggest some better way to handle as XML in Talend Big data Open Studio ??
thanks
Milan

Re: Process XML field from SQL Server Xform to PostgreSQL table

Anonymous — Wed, 04 Nov 2015 03:11:47 GMT

Hi Milan,

PostgreSQL cannot parse the XML content and therefore you have to save it as text content(String).
You can use

String.valueOf(row1.yourDocument)

to convert the document into a String.
Best regards
Sabrina

Re: Process XML field from SQL Server Xform to PostgreSQL table

Anonymous — Wed, 04 Nov 2015 03:18:41 GMT

Thanks Sabrina for confirmation! I read XML field as string and load data to table using TEXT.
either solution works for me ..but bad to hear we dont have XML datatype in DI