Creating the Master Index Database

Note - MySQL is only supported in Java CAPS 6 Update 1.

Once you have customized the configuration files and generated the master index application, you can create the master index database. Before you begin, make sure you have MySQL, Oracle or SQL Server installed on the database server.

During this process you can define custom startup data, such as code lists and source systems. The wizard defines SQL statements in the Code List and Systems SQL files (codelist.sql and system.sql) to insert startup data into the database based on information you specify, and you can customize the statements to insert the data relevant to your object structure. The code lists you define are used to translate processing codes from incoming messages into descriptions for the MIDM fields and to create drop-down lists for MIDM fields. System information is required in order to add records to the master index application.

Follow these steps to create the database.

• Step 1: Analyze the Master Index Database Requirements

• Step 2: Create a Master Index Database and User

• Step 3: Define Master Index Database Indexes

• Step 4: Define Master Index External Systems

• Step 5: Define Master Index Code Lists

• Step 6: Define Master Index User Code Lists

• Step 7: Create Custom Master Index Database Scripts

• Step 8: Create the Master Index Database Structure

• Step 9: Specify a Starting EUID for a Master Index

You can also delete the database for testing purposes using the supplied script. See Dropping Master Index Database Tables for more information.