• Advanced ETL Processor has now an HL7 transformation engine that enables healthcare organizations to easily transform electronic information

    A powerful Data transformation engine
    1. Works with 28 data sources and 22 data targets
    2. 500 + transformation functions
    3. Advanced highly customisable logging
    4. What you see is what you load principle
    5. Faster time to production

    Advanced ETL Processor's data preview functionality was designed to make development easier by showing what is happening with the data at every step of HL7 Transformation

    Achieve faster time to production by:
    • Testing transformations with live data to know exactly how they will perform in production.
    • Using Log Redirect: Log detailed messages into any database/file then use it for reporting or audit Identifying the problems:
    • Load troublesome data directly into the transformation designer to see the source of the problem.
    Protect your investment with integrated version control.
    1. Save milestones, review changes and roll-back errors
    2. Trace who/when/why
    3. Cut time by using Undo and Redo functionality


    Download Free Trial Learn More About Our ETL Software
  • Our partner Albatross Financial Solutions uses Advanced ETL Processor Enterprise as part of iPARS – Integrated Patient Acuity Recording System

    iPARS is designed to provide on-line real-time recording of Patient Acuity information by nursing staff onwards. The system architecture consists of the following 7 main elements:

    HL7 Processing

    1 Data Sources

    iPARS is designed with the ability to extract Patient Ward Stay information from a variety of data sources. It can interface with text files, receive messages from HL7 and link to SQL\Oracle databases. The basic requirement to these data sources is the availability of the up to date Patient Ward Stay information.

    2 iPARS ETL Tool

    The iPARS ETL Tool is based on the Advanced ETL Processor (AETL) software application supplied by DB Software Laboratory (http://www.etl-tools.com/etl-tools/advanced-etl-processor-enterprise/overview.html ). This system is configured to extract information from the ward stay text file. It is scheduled to run automatically every night at 4 o’clock. The information is loaded from the text file directly into the iPARS SQL database.  The same application is used to receive and process all the HL7 messages.

    Advanced ETL Processor Package example

    Advanced ETL Processor Exporting All Tables From Act

    3 SQL Database

    The iPARS SQL database stores all the Patient Ward Stay information into DS_WARDSTAY table. The information is saved with Patient ID, Ward Code and Date as the primary keys. In addition to the Patient Ward Stay table, the SQL database contains the main WARD_STATS and BED_STATS table which holds Acuity data for each patient – ward -date-shift (3 shifts per day) combination. In addition to these main tables, the iPARS SQL database also holds a variety of lookup tables including Ward Lookup, Acuity Levels description, etc. Another very important part of the database is the security table USERS It holds user name and password. Each user can access information only for a specific number of wards. The link between user name and ward is stored in USERS table as well.

    4 System Administrator Unit

    The iPARS System Administrator unit is based on the Active Table Editor (ATE) software application supplied by DB Software Laboratory (

    5 Web Form

    The iPARS Web form is designed using ASP .NET technology and is split into two separate parts. Part 1 is a user login facility which filters ward lists based on the user name. Part 2 enables the user to record Acuity information, ward data (number of admissions, absence, transfers, etc), patient notes,  etc. At present, the form is designed and tested for PC technology, but in the future, the plan is to create additional versions for iPAD's and tablet PC's.

    6 iPARS Reports

    this element of the iPARS solution is still in the design stage. At present all the acuity reports and analysis are delivered using QlikView. This platform provides literally unlimited flexibility in designing analysis and will bring the system in line with the overall front end reporting technology to be deployed across the NHS Trusts.

    7 PLICS Interface

    Brings Patient Acuity information into the existing cost allocation process

  • Configuring Advanced ETL Processor for HL7 Processing
    General settings



    IP Address

    IP address of data reader must be the same as the computer it is being run on.
    Use ipconfig to get IP Address


    Executing transformation

    Click plus
    Select transformation to run
    Enter the correct computer name
    Select how often -> once



    To run HL7 Transformation Press green arrow.

    Note: Only one HL7 transformation can listen to the port at the same time.

    Checking if the transformation is running.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies