Installation Guide for Microsoft SQL Server with IBM WebSphere

Back Next

Enabling Match Population

You must enable the match population to use for the match rules.

Copy the

<population>.ysp

files to the following location:

On UNIX.

<infamdm_install_directory>/hub/cleanse/resources/match

On Windows.

<infamdm_install_directory>\hub\cleanse\resources\match

In the C_REPOS_SSA_POPULATION metadata table, verify that the population is registered.

The seed database for the MDM Hub installation has some populations registered in the C_REPOS_SSA_POPULATION table, but not enabled.

If the C_REPOS_SSA_POPULATION table does not contain the population, add it to the table and enable it.

The population name is the same as the ysp file name. For example, if the ysp file name is

US.ysp

, the population name is US.

To add the population to an Operational Reference Store, use the following steps:

Run the

add_std_ssa_population.bat

script in the following directory:

<infamdm_install_directory>\server\resources\database\custom_scripts\MSSQL

Answer the prompts described in the following table:

Prompt	Description
Host name with Microsoft SQL Server instance for CMX_ORS database ("localhost")	Host name of the Microsoft SQL Server instance.
cmx_ors user name ("cmx_ors")	User name of the Operational Reference Store.
cmx_ors user password	Password of the Operational Reference Store.
Enter the population name (Note: If you use Person_Name_Kanji for the Japan population or Japan_i population, add the suffix '_Kanji' to the end of the name) DEFAULT (" ")	Name of the population.
Enter a value for ROWID_SSA_POP (example: INFA.0001) DEFAULT (INFA.0001)	Unique value for the ROWID_SSA_POP column of the C_REPOS_SSA_POPULATION metadata table.

The population is registered in the C_REPOS_SSA_POPULATION table.

Run the following command to enable the population:

USE <Operational Reference Store user>
GO
UPDATE [dbo].[C_REPOS_SSA_POPULATION] SET ENABLED_IND = 1 WHERE POPULATION_NAME = '<Your Population>'

Restart the

Process Server

after you enable populations.

The population appears in the

Match/Merge Setup

user interface for base objects.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.