How to build an outbound thread for a database connection

This topic has 8 replies, 5 voices, and was last updated 6 years ago by Robert Kersemakers.

Creator

Topic
January 5, 2015 at 4:02 pm #54514

Lynn Rice
Participant

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.
Creator

Topic

Viewing 7 reply threads

Author

Replies
- January 5, 2015 at 5:09 pm #81792
  
  Max Drown (Infor)
  Keymaster
  
  Hi, Lynn. What version of Cloverleaf are you using?
  
  -- Max Drown (Infor)
- January 5, 2015 at 6:05 pm #81793
  
  Max Drown (Infor)
  Keymaster
  
  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)
- September 13, 2018 at 1:06 pm #81794
  
  Lawrence Williams
  Participant
  
  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.
- September 13, 2018 at 1:17 pm #81795
  
  Lawrence Williams
  Participant
  
  last attachment showing no value passed
- September 14, 2018 at 3:59 pm #81796
  
  Robert Kersemakers
  Participant
  
  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
- September 14, 2018 at 5:18 pm #81797
  
  Lawrence Williams
  Participant
  
  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 😉
- September 17, 2018 at 3:02 pm #81798
  
  Robert Milfajt
  Participant
  
  It’s not about blame here. It’s about finding answers, which you did indeed.
  
  💡
  
  Robert Milfajt
  Northwestern Medicine
  Chicago, IL
- September 17, 2018 at 3:21 pm #81799
  
  Robert Kersemakers
  Participant
  
  True that.
  
  Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands
Author

Replies

Viewing 7 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.

How to build an outbound thread for a database connection

Forums

Forum Statistics