Announcement

Collapse
No announcement yet.

DB Reader to HL7 message

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DB Reader to HL7 message

    Hi everyone,
    I am a newbie in using Mirth Connect. My DB reader channel didn't write
    out HL7 message in ADT^A04. Can someone take a look and let me know what I do wrong. The channel is keep looping even though I set update status = 1. My sa user should have proper permission to run update statement on the table. Please help
    Attached Files

  • #2
    is there anyone having any resolution? Please help

    Comment


    • #3
      Can you verify that you query is actually returning any results?

      Does the channel ever show any messages as received? any errors?

      Comment


      • #4
        The query returned raw data but the output doesn't have transformed data in HL7 format. There is no error. The channel just keep looping until I stop it.

        Comment


        • #5
          1) Change the source connecter type to database reader.
          2) Configure the database reader settings (driver,username,password).
          3) In source transformer use the javascript mapper to create a HL7 message.

          Use this function to create the hl7 message from the xml

          SerializerFactory.getSerializer('HL7V2').fromXML(m essage);


          You have to fill the outbound message template with following

          MSH|^~\&|||||

          Comment

          Working...
          X