HL7 to Database

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

Open

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.

Open

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.