· Jun 15

Extract HL7 data and put it into the columns of IRIS SQL table.

Looking to pull out HL7 Fields data to put into columns in a SQL table. How to handle the repeated fields & segments data  to SQL. 

Operations over the extracted data in SQL server  can help for Analysis.


Appreciate your Help!!

Product version: IRIS 2019.1
$ZV: IRIS for windows(x86-64) 2019.1.1 Health 1.1.2
Discussion (1)1
Log in or sign up to continue

If you want something low-code you can create a Data Transformation with a HL7 message as source and as destination a class created ad-hoc with the structure that you need. Take a look to this example:

The destination in a class called RestTest.FirstRestObject with this definition:

Class RestTest.FirstRestObject Extends (%Persistent, %JSON.Adaptor, Ens.Util.MessageBodyMethods, Ens.Request)

/// Description
Property Name As %String;
/// Description
Property LastName As %String;
Property Childs As list Of NestedRestObject;

This object has an SQL representation wich you could use later for your analysis: