HL7 to Database

Owned by Aryn Wiebe
Last updated: Apr 18, 2024
2 min read

HL7 to Database is an example component for mapping HL7 messages to a database table. This component is designed as a sink (destination) component which will read in HL7 messages from a queue and insert them into a database.

How to set it up:

On the Dashboard, click +COMPONENT and search for HL7 to Database.

Screen Shot 2024-01-12 at 3.26.44 PM.png

Familiarize yourself with the what the script is doing. Step by step comments are included to help walk through each line.

To summarize:

  • HL7 inbound messages are parsed using a VMD - adt.vmd.

  • A VDB file is used to create a staging table mirroring the database.

  • The Lua file, mapping.vmd, includes the logic to map the HL7 fields to the database table fields.

  • Iguana connects to the database and the staging table is merged with the database table to insert a new row of HL7 data.

Screen Shot 2024-01-12 at 3.30.53 PM.png

HL7 to Database is a sink component which is designed to receive queued messages. Link a component like the HL7 Server to HL7 to Database and use the Simulator to generate a stream of HL7 messages to be inserted into the database.

Once linked, run your components! Your integration may look like this:

See Edit Connections.

Â