https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302529#M74502 Hi All,<BR />I want to read the patient specific information from the db(mysql) and send the same to HL7 component to create a HL7 structured message, but current components only supports with file to read and write data .<BR />So how can I handle with my scenario? Can any one help me regarding this?<BR /><BR /><BR />Thanks in advance.<BR />Sayagoud ravelly. Wed, 18 Jun 2014 07:25:34 GMT _AnonymousUser 2014-06-18T07:25:34Z https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302529#M74502 Hi All,<BR />I want to read the patient specific information from the db(mysql) and send the same to HL7 component to create a HL7 structured message, but current components only supports with file to read and write data .<BR />So how can I handle with my scenario? Can any one help me regarding this?<BR /><BR /><BR />Thanks in advance.<BR />Sayagoud ravelly. Wed, 18 Jun 2014 07:25:34 GMT https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302529#M74502 _AnonymousUser 2014-06-18T07:25:34Z https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302530#M74503 Can any one please suggest me on this? Wed, 18 Jun 2014 16:47:27 GMT https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302530#M74503 _AnonymousUser 2014-06-18T16:47:27Z https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302531#M74504 You can use the XML components to build an EHR message. Wed, 18 Jun 2014 19:10:03 GMT https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302531#M74504 Anonymous 2014-06-18T19:10:03Z https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302532#M74505 <BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD>You can use the XML components to build an EHR message.</TD></TR></TBODY></TABLE></BLOCKQUOTE><BR />Hi jholman,<BR />Thanks for your suggestion.I will try in this way.I will appreciate if you have any workarounds on this?<BR /><BR /><BR />--Thanks <BR />Sayagoud ravelly. Tue, 24 Jun 2014 10:14:22 GMT https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302532#M74505 _AnonymousUser 2014-06-24T10:14:22Z https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302533#M74506 I imagine you can go right from tMysqlInput to a tXMLMap or tWriteXMLField and map it to an EHR record and you are good to go. Tue, 24 Jun 2014 21:46:52 GMT https://community.qlik.com/t5/Talend-Studio/HL7-Component-to-read-and-write-the-data-from-flow-instead-of/m-p/2302533#M74506 Anonymous 2014-06-24T21:46:52Z