How to build an outbound thread for a database connection

[Lynn Rice]

I need to send HL7 ADT data to a SQL server database and am stuck on how to build the outbound thread.  I was able to set up a database configuration and connect to the database.  I used the Database Schema Configurator to build a schema and then I created an xlate from HL7 to the database schema.  Now I guess i need to build an outbound thread with a database outbound protocol.  Unfortuantely I habe no idea what to put in each of the fields and I can’t seem to find any concise instructions in “help”.  Any suggestions/pointers would be greatly appreciated.

Topic

[Max Drown (Infor)]

Hi, Lynn. What version of Cloverleaf are you using?

-- Max Drown (Infor)

[Max Drown (Infor)]

Here’s an example for CIS 6.1.

Content:

Code:

INSERT INTO test (
   acct_num,
   admit_date,
   bed,
   date_time,
   discharge_date,
   dob,
   fname,
   gender,
   id_num,
   lname,
   location,
   mname,
   room,
   ssn,
   visit_num
)
VALUES (
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   ,
   
)

-- Max Drown (Infor)

[Lawrence Williams]

I realize this is an older thread, but it looks relevant to my current issue..

Cloverleaf 6.1.1 running on Windows server

Trying to create an HL7 to database interface, the XLT I have setup seems to work as expected (I see the HL7 values in the related database field I defined in the XLT), when running the tester for Database Protocol I cannot get the Value in the “Executed SQL” statement.   If I check “whole message” then I can get the entire message as a value…but that does me no good here..

Attaching a couple screenshots.

[Lawrence Williams]

last attachment showing no value passed

[Robert Kersemakers]

I think you first need to translate the HL7 message. The resulting message (the db message) should be the input for the db-connection.

Right now you are trying to feed the HL7 message itself into the db-connection.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Lawrence Williams]

Thanks for the feedback.

I ended up discovering that just running the test data through the threads populated the database on the other end…

So yes, if I would have run the test file through the XLT tester, write that to file, then pull that into the database tester then it probably would have worked as expected.

I’ll take the blame for not understanding the tester fully  😉

[Robert Milfajt]

It’s not about blame here.  It’s about finding answers, which you did indeed.

💡

Robert Milfajt
Northwestern Medicine
Chicago, IL

[Robert Kersemakers]

True that.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Author]

Replies