Developing Sun Master Indexes (Repository)

Creating a Master Index Application (Repository)

The wizard provides a simple method for you to create the object definition and the runtime configuration files for your master index application. This section provides instructions for creating a new project and using the wizard to create the configuration files for the master index application. To create the initial master index framework, follow these steps.

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

Before you can access the wizard, you must create and name a new NetBeans project under the Java CAPS Repository.

ProcedureTo Create a Project

Before You Begin

Before you begin this step, make sure you are connected to the Java CAPS Repository in NetBeans.

  1. Right-click in the NetBeans Projects window, and then select New Project.

    The New Project wizard appears.

    Figure 3 Creating a New Project

    Figure shows the first page of the New Project wizard.

  2. Under Categories, select CAPS and then ESB.

  3. Under Projects, select CAPS Repository–Based Project.

    The Project Name window appears.

    Figure 4 Project Name and Location

    Figure shows the Project Name page of the New Project
wizard.

  4. On the Project Name window, enter a name for the project.

  5. Click Finish.

  6. Continue to Step 2: Name the Master Index Application (Repository).

Step 2: Name the Master Index Application (Repository)

Before you can configure the new master index application, you must give the master index application a unique name.

Figure 5 Name Application Window

Figure shows the window of the wizard where you name
the application.

ProcedureTo Name the Master Index Application

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

  2. In the Projects window, right-click the new project, point to New, and then select Master Index Application.

    The Master Index wizard appears.

  3. In the Application field of the Name Application window, enter a name for the new master index application, and then click Next.


    Note –

    The name you enter for the application should be the same name you will give to the parent object when you define the object structure.


    The Define Source Systems window appears.

  4. Continue to Step 3: Define Source Systems (Repository).

Step 3: Define Source Systems (Repository)

After you specify a name for the new master index application, you need to specify the processing codes for the source systems that will be integrated into the master index system.

Figure 6 Define Source Systems

Figure shows the window on the wizard where you define
source systems.

ProcedureTo Define Source Systems

  1. Complete Step 2: Name the Master Index Application (Repository).

  2. In the Name field of the Define Source Systems window, enter the processing code of one of the source systems that will share data in the master index system, and then click Add.

    You can enter any of the following characters:

    • ! _ ~ ( ) { } + \Q # $ % & : ; - /

    • a-z

    • A-Z

    • 0-9

    • þ ÿ Þ ß ’à-ö ø-ý À-Ö Ø-Ý

      The value you entered appears in the Systems box.


      Note –

      Be sure to enter the processing code of the system and not the name. This value is entered in the Best Record file for defining survivor strategies for the SBR.


  3. Do any of the following:

    • To define additional systems, repeat the above step for each source system that will share information with the master index application.

    • To remove a system from the list, highlight the name of that system in the Systems box, and then click Remove.

    • To remove all systems from the list, click Remove All.

  4. When you have defined all required source systems, click Next.

    The Define Deployment Environment window appears.

  5. Continue to Step 4: Define the Deployment Environment (Repository).

Step 4: Define the Deployment Environment (Repository)

Once you define systems, you must specify information about the deployment environment, including the database, match engine, and standardization engine vendors.

Figure 7 Define Deployment Environment

Figure shows the window on the wizard where you define
deployment information.

ProcedureTo Define the Deployment Environment

  1. Complete Step 3: Define Source Systems (Repository).

  2. On the Define Deployment Environment window, enter the following information:

    • Database – The type of database being used for the master index application. You can select Oracle or SQL Server.

    • Match Engine – The type of match and standardization engine to use for the implementation. Currently, the only option is “Sun Match Engine”.

    • Date Format – The date format for the master index system. This defines how dates should be entered and how they appear on the EDM. You can select MM/dd/yyyy, dd/MM/yyyy, or yyyy/MM/dd.

  3. When you have defined the deployment environment fields, click Next.

  4. Continue to Step 5: Define Parent and Child Objects (Repository).

Step 5: Define Parent and Child Objects (Repository)

After you define the deployment environment for the master index application, you can begin to define the structure of the object you want to index. The primary object will be the parent object for any other objects defined. Child objects are not required if all information is stored under the parent object.

You can create new undefined objects, create objects using predefined templates, or use a combination of both methods to create the objects in your enterprise object. Perform any of the following actions to define the objects in the enterprise object.

Complete Step 4: Define the Deployment Environment (Repository) before performing these procedures.


Note –

The names of database constraints are created based on the parent and child object names. Due to database naming restrictions, the length of the parent object name plus the length of any of the child object names must be 21 characters or less. Give the parent object the same name you gave to the application earlier in the wizard.


Creating Undefined Objects

When you create undefined objects, you create an empty object with no predefined fields or child objects.

Figure 8 Define Enterprise Object

Figure shows the window on the wizard where you define
the object structure.

ProcedureTo Create Undefined Parent and Child Objects

  1. On the Define Enterprise Object window, click Add Primary Object.

    The initial node appears on the tree. By default, the name of the field is the same as the name of the application you defined in Step 2: Name the Master Index Application (Repository).

  2. Accept the default name by pressing Enter, or type a new name and press Enter.

  3. To create a new child object, select the primary object created above and then click Add Sub Object.

    The new child node appears on the tree.

  4. Accept the default name by pressing Enter, or type a new name and press Enter.

  5. Repeat the previous two steps for each child object.

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

Creating Objects from a Template

When you create objects from a template, secondary objects and fields are predefined. You can modify the objects, fields, and field properties in a template to suit your processing needs.

Figure 9 Define Enterprise Object

Figure shows the Person template object structure on
the wizard.

ProcedureTo Create Parent and Child Objects From a Template

  1. To create a complete object structure from a template, click Templates on the Define Enterprise Object toolbar, and select the template you want to use.

    The objects and fields from the template appear in the tree-view panel in the center of the window.

  2. To create a child object from a template after creating the parent object, right-click the parent object, point to Template, and then select the name of the template you want to use.

    The new object and any defined fields appear in the object tree.

  3. If necessary, change the name of the new object by doing the following:

    1. Click twice on the name.

    2. Type the new name.

    3. Press Enter.

  4. Repeat steps 2 and 3 for each child object template you want to create.

  5. Continue to Step 6: Define the Fields for Each Object (Repository).

Deleting an Object from the Structure

If you add an object in error, or do not want to use one of the objects in a predefined template, you can delete the object from the structure.

ProcedureTo Delete an Object From the Structure

  1. On the Define Enterprise Object window, select the object you want to remove.

  2. Do any of the following:

    • Right-click in the object tree panel, and then select Delete.

    • Press the Delete key.

    • In the wizard toolbar, click Delete.

      The object and any fields associated with that object are deleted. If you remove the parent object, all child objects are deleted.

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

After you define all the parent and child objects for your enterprise object, you need to define the fields in each object. Every field has a set of properties that must be configured before creating the master index configuration files. If you chose a predefined template to create your objects, be sure to check the properties for all predefined fields to be sure they are configured correctly for your implementation.

After you define the parent and child objects, you can perform any of the following actions to define the fields for those objects.

Adding a Field

If you created an empty object in Step 5: Define Parent and Child Objects (Repository), you need to create each field that belongs to the object. If you created objects using a predefined template, you can add new fields to the object if needed.

ProcedureTo Add a Field

  1. Complete Step 5: Define Parent and Child Objects (Repository).

  2. In the object tree panel of the Define Enterprise Object window, do one of the following:

    • To add the field to the end of the object’s field list, select the name of the object to which you want to add a new field and then click Add Field.

    • To add the field immediately following an existing field, select the field after which you want to add the new field and then click Add Field.

      The tree expands and a new field is inserted.

  3. Do one of the following:

  4. Continue to Configuring Field Properties.

Configuring Field Properties

When you create a field, a set of default properties is defined for that field. You can modify the property configuration for each field to suit your data processing, storage, and display requirements. After you modify a property value, press Enter to apply the change.

ProcedureTo Configure Field Properties

  1. Complete the steps under Adding a Field.

  2. In the object tree panel of the Define Enterprise Object window, select the field you want to configure.

  3. On the Properties page in the right side of the window, modify the value of any of the properties listed in Master Index Wizard General Field Properties (Repository).

    Figure 10 Field Properties

    Figure shows the field Properties window.

  4. On the right side of the window, click the EDM tab, and then modify the value of any of the properties listed in Master Index Wizard EDM Field Properties (Repository).

    Figure 11 Field EDM Properties

    Figure shows the EDM Properties page.

  5. When you have created and configured all of the necessary fields for each object, click Next.

  6. Continue to Step 7: Generate the Project Files (Repository).

Deleting a Field

If you add a field in error, or do not need one of the predefined fields from a template, you can delete the field.

ProcedureTo Delete a Field

  1. In the object tree panel of the Define Enterprise Object window, select the field you want to delete.

  2. Right-click in the object tree panel.

  3. From the context menu, select Delete.

    The field is removed from the object tree.

Step 7: Generate the Project Files (Repository)

Once you have named the application and configured the source systems, deployment environment, objects, and fields for the master index application, you need to generate the configuration files and database scripts. You have the option to create all additional project files at this time (such as the JAR files and OTDs) or to wait until you have customized the configuration files for the master index application. Review the configuration files to be sure the application is set up correctly for your data processing environment.


Note –

Modifying the configuration files is not covered in this document. For instructions on configuring a master index application, see Configuring Sun Master Indexes (Repository).


Figure 12 Generate Project Files

Figure shows the final window of the wizard.

ProcedureTo Generate the Configuration Files

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

  2. Verify that all of the information you have entered is complete and correct.

  3. To generate all application files for the project, select the check box at the bottom of the window. To generate them later, after reviewing the configuration files, leave this check box unchecked.

  4. On the Generate Configuration Files window, click Finish.

    The configuration files are generated, and are stored in the eGate Repository.

  5. Continue to Step 8: Review the Configuration Files (Repository).

Step 8: Review the Configuration Files (Repository)

After the wizard is complete, several nodes representing the master index configuration files are placed in the project for the master index application. Verify that the configuration files are customized correctly for your implementation. If you need to modify the configuration files, see Configuring Sun Master Indexes (Repository) for information about configuration tasks. For information about the configuration files and configurable options, see Understanding Sun Master Index Configuration Options (Repository).