JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Developing Oracle Java CAPS Master Indexes (Repository)     Java CAPS Documentation
search filter icon
search icon

Document Information

Developing Oracle Java CAPS Master Indexes (Repository)

Related Topics

Oracle Java CAPS Master Index Overview

About Oracle Java CAPS Master Index

Oracle Java CAPS Master Index Features

Master Index Repository Components

Wizard Editor

Editors

Project Components

Configuration Files

Database Scripts

Custom Plug-ins

Match Engine Configuration Files

Outbound Object Type Definition (OTD)

Dynamic Java API

Connectivity Components

Deployment Profile

Environment Components

Learning about the Master Index Runtime Environment

Functions of the Runtime Environment

Features of the Runtime Environment

Master Index Runtime Components

Matching Service

Manager Service

Query Builder

Query Manager

Update Manager

Object Persistence Service (OPS)

Database

Enterprise Data Manager

Enterprise Records

System Records

The Single Best Record

Objects in an Enterprise Record

Working with Project Components

Version Control

Copying, Cutting, and Pasting Files

Master Index Development Process Overview (Repository)

The Master Index Framework and the Runtime Environment (Repository)

Before You Begin Developing a Master Index (Repository)

Preliminary Data Analysis for a Master Index (Repository)

Planning a Master Index Project (Repository)

Master Index Project Initiation Checklist (Repository)

Creating a Master Index Application (Repository)

Step 1: Create a Project and Start the Wizard (Repository)

To Create a Project

Step 2: Name the Master Index Application (Repository)

To Name the Master Index Application

Step 3: Define Source Systems (Repository)

To Define Source Systems

Step 4: Define the Deployment Environment (Repository)

To Define the Deployment Environment

Step 5: Define Parent and Child Objects (Repository)

Creating Undefined Objects

Creating Objects from a Template

Deleting an Object from the Structure

Step 6: Define the Fields for Each Object (Repository)

Adding a Field

Configuring Field Properties

Deleting a Field

Step 7: Generate the Project Files (Repository)

To Generate the Configuration Files

Step 8: Review the Configuration Files (Repository)

Master Index Wizard Field Properties and Name Restrictions (Repository)

Master Index Wizard Field Name Restrictions (Repository)

Master Index Wizard General Field Properties (Repository)

Master Index Wizard EDM Field Properties (Repository)

Custom Plug-ins for Master Index Custom Transaction Processing (Repository)

Master Index Update Policy Plug-ins (Repository)

Enterprise Merge Policy

Enterprise Unmerge Policy

Enterprise Update Policy

Enterprise Create Policy

System Merge Policy

System Unmerge Policy

Undo Assumed Match Policy

Master Index Field Validation Plug-ins (Repository)

Master Index Field Masking Plug-ins (Repository)

Master Index Match Processing Logic Plug-ins (Repository)

Custom Match Processing Logic Methods

Custom Match Processing Logic Plug-in Requirements

Custom Match Processing Configuration (Repository)

Master Index Custom Plug-in Exception Processing (Repository)

Custom Plug-Ins for Master Index Custom Components (Repository)

Master Index Survivor Calculator Plug-ins (Repository)

Master Index Query Builder Plug-ins (Repository)

Master Index Block Picker Plug-ins (Repository)

Master Index Pass Controller Plug-ins (Repository)

Match Engine Plug-ins (Repository)

Standardization Engine Plug-ins (Repository)

Phonetic Encoders Plug-ins for a Master Index (Repository)

Implementing Master Index Custom Plug-ins (Repository)

Creating Master Index Custom Plug-ins (Repository)

To Create Custom Plug-ins

Building Master Index Custom Plug-ins (Repository)

To Build Custom Plug-ins

Generating the Master Index Application (Repository)

To Generate the Application for the First Time

To Regenerate the Application

Master Index Database Scripts and Design (Repository)

Master Index Database Scripts (Repository)

Master Index Database Requirements (Repository)

Database Platform Requirements

Operating System Requirements

Hardware Requirements

Oracle Database

Microsoft SQL Server

Master Index Database Structure (Repository)

Designing the Master Index Database (Repository)

Designing for Performance Optimization

Data Structure Analysis

Common Table Data

User Code Data

Database Considerations

Database Sizing

Database Distribution

Database Indexes

Creating the Master Index Database (Repository)

Step 1: Analyze the Master Index Database Requirements (Repository)

Step 2: Create a Master Index Database and User (Repository)

Step 3: Define Master Index Database Indexes (Repository)

To Define an Index

Step 4: Define Master Index External Systems (Repository)

To Define an External System

Master Index Database Table Description for sbyn_systems (Repository)

Step 5: Define Master Index Code Lists (Repository)

To Customize Common Table Data for Oracle

To Customize Common Table Data for SQL Server

Step 6: Define Master Index User Code Lists (Repository)

To Define a User Code List

Master Index Database Table Description for sbyn_user_code (Repository)

Step 7: Create Custom Master Index Database Scripts (Repository)

To Create a Custom Script

Step 8: Create the Master Index Database Structure (Repository)

To Create the Database Structure

Step 9: Specify a Starting EUID for a Master Index (Repository)

Deleting Master Index Database Tables (Repository)

To Delete Database Tables (Repository)

Defining a Database Connection Pool Through the Application Server

Step 1: Add the Oracle Driver to the Application Server

Step 2: Create the JDBC Connection Pools

To Create the JDBC Connection Pools

Step 3: Create the JDBC Resources

To Create the JDBC Resources

Generating the Master Index Application (Repository)

Before you generate the application, review the configuration files and make any necessary modifications (see Configuring Oracle Java CAPS Master Indexes (Repository) for more information). Once all modifications to the configuration files are complete and any custom plug-ins are built, generate the master index application to create or update the application components. If you modify any of the configuration files, match and standardization engine files, or custom plug-ins after you generate the application, you need to regenerate the application to update the custom components.


Note - If any errors occur while compiling the application, they appear in the output panel in the bottom of the window. This window also displays the status of the generate process.


To Generate the Application for the First Time

  1. Save any configuration changes to the master index project.
  2. Right-click the master index application in the Projects window.
  3. Select Generate.

    The project components are generated. This might take a few minutes.

  4. On the NetBeans toolbar, click Save.
  5. If you are using command line reports, do the following:
    1. Export the generated Application_stc_eindex_client.jar and Application_stc_eindex_util.jar files to the /lib subdirectory in the reports home directory.
    2. In the /lib subdirectory, rename Application_stc_eindex_client.jarto stc_eindex_client.jar and rename Applicationstc_eindex_util.jar to stc_eindex_util.jar.

To Regenerate the Application

  1. Save any configuration changes to the master index project.
  2. Right-click the master index application in the Projects window.
  3. Select Generate, and then click Yes on the dialog box that appears.

    The application components are regenerated. This might take a few minutes. The output panel displays the status and any errors that occur.

  4. On the NetBeans toolbar, click Save.
  5. If there are any client projects with Collaborations that reference the master index server project, refresh those Collaborations.
  6. If there were any changes to how incoming data is processed (such as changes to the output OTD), re-import the .jar files.
    1. Open the Collaboration in the Collaboration Editor and click Import JAR Files.

      The Add/Remove Jar Files dialog box appears.

    2. For each master index application .jar file, highlight the filename on the Add/Remove Jar Files dialog box, and then click Remove.
    3. For each file to re-import, click Add, double-click the master index server project, select the .jar file, and then click Import.
  7. If you are using command line reports, do the following:
    1. Export the regeneratedApplication_stc_eindex_client.jar and Application_stc_eindex_util.jar files to the /lib subdirectory in the reports home directory.
    2. In the /lib subdirectory, rename Application_stc_eindex_client.jarto stc_eindex_client.jar and rename Applicationstc_eindex_util.jar to stc_eindex_util.jar.