https://community.qlik.com/t5/Talend-Studio/How-to-consume-message-from-jms-server-and-transform-it-into-db/m-p/2308626#M79930 Hi, <BR />You have tJMSInput or tMOMInput component which give you the opportunity to connect to a QUEUE and retrieve the message to be parsed and load into a DB. <BR />If your message is an XML message; after the tMOMInput; you have to use a tExtractXMLFields and then map to your DatabaseOutput (maybe a tMap is require to perform data mapping and data transformation issues). <BR />If your message is a commaSeparated or whatever format; you have also tExtractDelimitedFields or tExtractPositionalFields to parse the right message format and load to your expected output. Fri, 12 Mar 2010 14:42:53 GMT Anonymous 2010-03-12T14:42:53Z https://community.qlik.com/t5/Talend-Studio/How-to-consume-message-from-jms-server-and-transform-it-into-db/m-p/2308625#M79929 Hi,<BR />I want to consume a message from my jms topic, the message content is xml format, how can I transform it and persist the data into db.<BR />e.g.: the topic is ems topic,<BR />1. I can use tJms component to connect the topic and get the message and output to tLogRow (fine)<BR />2. tMap do the mapping (Not sure)<BR />3. DBConnection and persist the mapped data into db. (fine)<BR />How can I transfer it before I persist it into db, if it's a xml file, we can define the mapping with tMap, but if I get the xml string from the topic, how can I do the mapping?<BR />Please advise.<BR />Thanks in advance. Sat, 16 Nov 2024 13:30:47 GMT https://community.qlik.com/t5/Talend-Studio/How-to-consume-message-from-jms-server-and-transform-it-into-db/m-p/2308625#M79929 Anonymous 2024-11-16T13:30:47Z https://community.qlik.com/t5/Talend-Studio/How-to-consume-message-from-jms-server-and-transform-it-into-db/m-p/2308626#M79930 Hi, <BR />You have tJMSInput or tMOMInput component which give you the opportunity to connect to a QUEUE and retrieve the message to be parsed and load into a DB. <BR />If your message is an XML message; after the tMOMInput; you have to use a tExtractXMLFields and then map to your DatabaseOutput (maybe a tMap is require to perform data mapping and data transformation issues). <BR />If your message is a commaSeparated or whatever format; you have also tExtractDelimitedFields or tExtractPositionalFields to parse the right message format and load to your expected output. Fri, 12 Mar 2010 14:42:53 GMT https://community.qlik.com/t5/Talend-Studio/How-to-consume-message-from-jms-server-and-transform-it-into-db/m-p/2308626#M79930 Anonymous 2010-03-12T14:42:53Z