Back to Pilotfish Home

Data Mapping From HL7 Message Template


    Data Mapping From HL7 Msg Template with PilotFish’s Integration Engine, eiConsole

    This is a demonstration of the eiConsole for Healthcare data map created from the HL7 message template. Using the eiConsole for Healthcare, it’s easy to map from any HL7 message to any other data format. Let’s show you how. Simply create a new route, define a source, and define a target and we’ll create a new source transformation.

    HL7 Message Translation

    We’ll call this Map from HL7 Message. First, we need to translate the HL7 message into XML using the HL7 2.x transformer. We select our desired HL7 version 2.4 and elect to use “Friendly Names”.

    HL7 Data Mapper

    Next, we’ll need to configure a mapping in the XSLT configuration by clicking edit and launching the Data Mapper. Here we need to load our source and target formats. Our source format will be loaded with the HL7 2.x format builder. Again, we’ll choose HL7 2.4 and to use “Friendly Names”. We’ll also elect to use a sample file. I’ll load a sample lab results message, click open, and read format.

    The structure of our source HL7 message will appear on the left-hand side of the screen. Now, I’ll load in my desired target format which will be a custom XML structure. I’ll use the XML format builder and select the custom lab results XML sample file and click read format.

    Now to map from one to the other, I’ll choose to create a target template using the sample data. The structure of my target data will appear in the center panel. Now, to map values from the HL7 message I’ll simply navigate to the appropriate segment, field or component and drag & drop.

    I’ll map the last name, the first name, and the date of birth for demonstration purposes. If we need to do any further manipulation of the data, the palliative structures above the mapping can be used to accommodate that.

    For instance, if we want to map the inbound date format onto an XML date format, we can use the date-time formatting tool. Drop it on the date of birth field, enter in the HL7 date format which is YYYYMMDD and our desired output format YYYY-MM-DD and click OK. And we can continue in this fashion until all the various fields are mapped. We then save our mapping and return to the eiConsole.

    Testing the Data Mapping

    We can now test the mapping in the eiConsole’s testing mode. First, I configure my test. We’ll select our sample file, click open, and as each stage completes the question mark will turn into a check mark.

    Now we can view the results. Here is our input HL7 message. Here is the result of its transformation to XML. And finally, the mapping onto the custom format where we see the three fields that we had mapped in the mapper, populated with the values from the HL7 feed.

    So, it’s just that easy! We use the HL7 transformation module to convert the HL7 message into XML. We perform a mapping using drag & drop in the Data Mapper and then we test, in the test mode. In minutes we built the transformation from any HL7 message to another format.

    Do You Have Any Questions?

    Read more about the eiConsole Integration Engine, our core software product.  Download a Free 90-Day Trial of the eiConsole.  Give it a Try!

    For more information, please call us at 813 864 8662 or click the link below to email us.

    HL7 is the registered trademark of Health Level Seven International. 

    This is a unique website which will require a more modern browser to work! Please upgrade today!