Needed - ready-to-use database for HL7

[tmcc1]

Hello,

I need a sollution to store incoming HL7-feeds. I'd like to use Mirth as the entrance-point, because of its flexibility and scalability, but I need a database behind. Because I'm to treat my HL7 messages and the target-store-system as closed black-boxies I would need a ready-tu-use package so that I don't have to go in details. I've been googling the net for a few hours, but I have not found any out-of-the-box database sollution. Can you recommend me something or just give a hint? I don't want to do it from scratch, I'd like to install the free database and load the HL7-store-scheme from a script. I supposed it would be the most obvious way to do it... but unfortunately I cannot find anything...

Cheers,
tmcc1

[jbartels]

Re: Needed - ready-to-use database for HL7

I haven't seen an HL7 schema or script. When you make one I'd be really grateful if you share it here.

As for 'black-box' datbases you probably want to use something like Derby. Thats what Mirth uses as its own internal database and you'd never know it unless you dug around in the forums or the config files. It just works. The downside is that Derby can get really slow if you're shoving a lot of data through it.

I don't know if its possible, or even a good idea, to piggyback off of the Derby DB in Mirth and use it for your production needs.

You may be better off writing Mirth channels and schema-scripts for a few of the major databases, DB2, Postgres, MySQL, and SQL Server then finding out what server your customers already have installed and then just set your database and tables on their server.

If you and your customers are willing to just let you install whatever I'd use Postgres and make your installer unpack and configure it.

If you are able to, can you better describe what you mean by a 'black-box' install?

[tmcc1]

Re: Needed - ready-to-use database for HL7

Hi,

thanks for your comments and ideas.

With the "black-box-solution" I meant something that would be ready to use - I don't want to spend time analyzing the HL7-data model (in all its versions...) and building a database. So, recapitulating - I'd like to use some kind of a free database - as you mentioned like postgres, mysql, etc - and load on it a ready DB-schema from a SQL-script. Whereas the DB itself is not an issue, the problems beginns with the schema...

My task is just to store the HL7-message-flow, I don't even have to understand this data at this point, just to log it. But the next step will be to respond some requests, so I cannot just store it into a file or "as it is" to the DB... I thought I can find some freeware package with the ready database - there are so many HL7-tools, but there is just nothing on this field... Many programs serve with the DB-interfaces, but where can I get the DB itself?!

Cheers,
tmcc1

[nshaik]

Re: Needed - ready-to-use database for HL7

If I understand your requirement right I think you get this out-of-the-box from Mirth.

I know Mirth comes with postgres-database.sql which could be used to create the required schema in the Postgres database. You need to change the configuration to make Mirth use the database in Postgres (and not the default Derby DB). I haven't tried this but anyone who is using Mirth with Postgres database might be able to help.

You could then setup a channel with no filter/transformer like the File to file sample in the File Repository

http://www.mirthproject.org/index.php?option=com_docman&task=cat_view&gid=26&Itemid=43

You could set the channel to store the incoming messages and Mirth will save all the messages in the MESSAGE table (in the Mirth database in Postgres).

Hope it helps!

[chrisl]

Re: Needed - ready-to-use database for HL7

Following what Nazir said - it would be hard to find a data model that had the specifics for EVERY possible message type. Usually you are only after patient information, transcription data or lab results. If you need all the data in an easy to re-use and parse format, it is best to store the data as XML (transformed data in Mirth). Store the XML in the DB and you can later retrieve and parse as needed.

-Chris

[vishalpawar]

Please Help

Hello,

I need a sollution to store incoming HL7-feeds. I'd like to use Mirth as the entrance-point, because of its flexibility and scalability, but I need a database behind. Because I'm to treat my HL7 messages and the target-store-system as closed black-boxies I would need a ready-tu-use package so that I don't have to go in details. I've been googling the net for a few hours, but I have not found any out-of-the-box database sollution. Can you recommend me something or just give a hint? I don't want to do it from scratch, I'd like to install the free database and load the HL7-store-scheme from a script. I supposed it would be the most obvious way to do it... but unfortunately I cannot find anything...

Cheers,
tmcc1

I have developed a laboratoty module..It is based on asp.net MVC framework with sql 2012 as database..Now I want my module(software)to be hl7 complaince..can you please provide me detail steps to be followed to make a product hl7 complaint...

Like whta will be my first step in the process.
My database is sql how i will be able to create database for hl7 etc..

Please support..

Regards

[vishalpawar]

Please help

I haven't seen an HL7 schema or script. When you make one I'd be really grateful if you share it here.

As for 'black-box' datbases you probably want to use something like Derby. Thats what Mirth uses as its own internal database and you'd never know it unless you dug around in the forums or the config files. It just works. The downside is that Derby can get really slow if you're shoving a lot of data through it.

I don't know if its possible, or even a good idea, to piggyback off of the Derby DB in Mirth and use it for your production needs.

You may be better off writing Mirth channels and schema-scripts for a few of the major databases, DB2, Postgres, MySQL, and SQL Server then finding out what server your customers already have installed and then just set your database and tables on their server.

If you and your customers are willing to just let you install whatever I'd use Postgres and make your installer unpack and configure it.

If you are able to, can you better describe what you mean by a 'black-box' install?

I have developed a laboratoty module..It is based on asp.net MVC framework with sql 2012 as database..Now I want my module(software)to be hl7 complaince..can you please provide me detail steps to be followed to make a product hl7 complaint...

Like what will be my first step in the process.
My database is sql how i will be able to create database for hl7 etc..

Please support..

Regards

[Andrew]

Is there a reference database schema available in DDL for any Mirth supported database for HL7 v2 and CCD?

Thanks!

Andrew