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)0
Comments
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:.png)
The destination in a class called RestTest.FirstRestObject with this definition:
Class RestTest.FirstRestObject Extends (%Persistent, %JSON.Adaptor, Ens.Util.MessageBodyMethods, Ens.Request)
{
/// DescriptionProperty Name As%String;/// DescriptionProperty LastName As%String;Property Childs As list Of NestedRestObject;
}This object has an SQL representation wich you could use later for your analysis:
.png)