Best Way to store recieved hl7 message from customer in database

Question

Hi All i am new in mirth.

i want to know the best way to store hl7 message in mysql database in a table where it store only one column as hl7 message or in row and columns like sending application column ,receiving application column etc..

I am unable to find a suitable answer so help me.

Thanks in advance.

Answer 1

Parsing the HL7 and storing each HL7 segment in an individual field would be an overkill for the database (HL7 has a hierachical structure and changes from each version to the other).

I would recommend to store really just the attributes you need (IDs, Sending Applications, Timestamp, ...) and put the original HL7 as text(or xml) in one field. You can then take the HL7 and parse it again when you need it.