To Create the Master Index Database

Before You Begin

The PIX/PDQ solution currently supports MySQL 5.1. Before you begin this process, be sure you have MySQL installed as a service with remote host access enabled.

• Copy the MySQL driver file (mysql-connector-java-5.1.7-bin.jar) to app-server-home/domains/domain-name/lib.

• Create a password for the root user.

• Run the following command against the root user:

  grant all privileges on *.* to 'root'@'%' with grant option;

1. Create a schema in your MySQL environment named midm.

2. Create a user for the Master Index tables by running the following command:

   grant create, alter, drop, delete, index, insert, select, trigger, update, create routine, alter routine, execute on midm.* to username identified by 'password';

   Substitute an actual user name and password for username and password in the above command. The default user name and password are both midm.

3. Navigate to the directory to which you downloaded the PIX/PDQ projects during installation, and then navigate to PIXPDQCORE/MDMPIXPDQ/src/DatabaseScript.

4. Open systems.sql in a text editor, and add the HL7 systems with which you will be sharing data.

   For more information about modifying this file, see Step 4: Define Master Index External Systems in Sun Master Index User’s Guide.

5. Open codelist.sql in a text editor, and add any common code information you need for the master index system.

   For more information about code lists and modifying this file, see Step 5: Define Master Index Code Lists in Sun Master Index User’s Guide.

   ---

   Note –

   This step is optional. The default configuration does not use common code tables. Adding this feature will cause additional validations to be performed against incoming data.

   ---

6. Log in to the midm schema as user you created above.

7. Run the following SQL files against the midm schema. The create.sql file must be run first.

   • create.sql

   • systems.sql

   • codelist.sql

8. Continue to To Create the PIX/PDQ Database Tables.