Storing HL7 messages

[Gene Millard]

I am looking for a way to store HL7 scheduling messages on Cloverleaf so that I can modify and resend them when an ADT message comes through that matches certain items in the scheduling message.

Gene Millard

The Guthrie Clinic
Sayre, PA

Topic

[David Barr]

There are lots of ways to do it:

– flat file using an identifier as part of the filename

– Sqlite database

– gdbm database

– global variable

Take your pick.

[Marc Pleijers]

Using GDBM depends on the Cloverleaf version you are using.

GDMB is deprecated in Cloverleaf 5.8.1.0 or higher.

You need to migrate from GDBM to SQLite in 5.8.1.0 and there is an migration tool available for it. Have a look in the release notes of 5.8.1.0 for a description.

I would advice to use SQLite. We use SQLite quite often to solve issues.

Best regards

Marc Pleijers
Senior Integration Consultant
Enovation BV
The Netherlands

[Gene Millard]

We are on 5.7.

I am unfamiliar with SQLite.

The Guthrie Clinic
Sayre, PA

[Marc Pleijers]

Have a look on http://www.sqlite.org/

There is also a chapter on their website about the TCL interface.

That’s the interface you need within Cloverleaf.

Building your SQLite Database file is possible with free SQLite

Marc Pleijers
Senior Integration Consultant
Enovation BV
The Netherlands

[Gene Millard]

The database would be on the cloverleaf server so I would not need the ODBC component to get to it correct?

The Guthrie Clinic
Sayre, PA

[Jim Kosloskey]

If you decide to use SQLite be sure to read the limitations carefully in the doc before you make any design decisions.

Also don’t forget to figure out how you will handle the administrative tasks – like finding stale messages which never had a partner come through to pick up the information.

email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

[Charlie Bursell]

You post this Jim and people think that sqlite cannot perform the full functionality of a relational database.   It definately can!

Other than not having controlled access, what limitations are you referring to?

[Peter Heggie]

Correct – you do not need ODBC to connect to SQLite. There are many examples in Clovertech of SQLite code in TCL.

One advantage of SQLite over SQL Server or Oracle is that it is on the same server as Cloverleaf and therefore highly available.

It does not support stored procedures, but this is a design choice. SQLite is meant to be lean and fast.

Peter Heggie

[Author]

Replies