New post
Question
· Jun 15, 2023

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

#DTL #HL7 #Object Data Model #SQL #InterSystems IRIS

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
Luis Angel Pére... · Jun 16, 2023

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:

1 0