Setting up the patient identifier database

The Healthcare: Medical devices to EMR pattern can optionally query a database for patient identifiers. Patient identification is important so that device measurements are associated with the correct patient. The database associates device identifiers with patient identifiers. The device identifiers are propagated in the messages from the MedicalDeviceInput Node. The patient identifier is added by the pattern instance to the HL7 v2 observation result messages (ORU R01) sent to the destination application.

You need a database with one table and an ODBC definition to lookup patient identifiers. To access the database the integration node must be configured with a user identifier and password.

Set up the database tables

Complete the following tasks to setup the database tables:

  1. Create the database

    Follow the instructions that are relevant to your database manager:

Set up the database environment for the integration node

Complete the following tasks to setup the database environment for the integration node:

  1. Create an ODBC definition for the PATSDB database with PATIENTSDSN as the data source name (DSN); see Enabling ODBC connections to the databases in the IBM Integration Bus documentation.
  2. Specify the user identifier and password that are associated with the data source name PATIENTSDSN .

    Use the mqsisetdbparms command to specify a user identifier and password that the integration node can use with the PATIENTSDSN data source. This user identifier must be the same user identifier that you used when you created the database in the previous step. The user identifier determines the database schema name, and the integration node must use the same user identifier when accessing the table. For example, if your user identifier is USERID , the fully-qualified name of the PATSDB table name is USERID.PATSDB .

    1. Open a command console window in which you can run IBM Integration Bus commands. Enter the following command to specify the user identifier and password: 
      mqsisetdbparms integration node -n PATIENTSDSN -u <user ID> -p <password>
    2. Enter the following command to reload the integration server: 
      mqsireload integration node -e integration server name
      where integration node is the name of your integration node, and where integration server name is the name of your integration server.

Back to the Healthcare: Medical devices to EMR pattern specification