title: Using HL7 message to insert data in my SQL Server
body: <p>I'm using mirth for sending and receiving HL7 message.</p>
  
  <p>Is it possible to insert custom data (char datatype) in my SQL Server database by picking up a HL7 message (file type) mapping it with my columns of my database using transformer and inserting to my database. </p>
  
  <p>And is there any option of generating status in a outbound HL7 message in mirth ?   </p>