HL7 to Database
- Aryn Wiebe
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.
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.
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.