Installation and Configuration Guide

10.5 HotFix 2 SP 1

Back Next

Localizing Lookup Table

A lookup table is a reference table that contains a list of supported values for a column in a base object table. You can localize the lookup tables in any language you want. To localize the lookup tables, create a properties file with the localized values, and then import the localized file into the database.

Go to the following directory:

<MDM Installation Directory>/app/tcr/lookuplocalization/resources

Save a copy of the

lookup.properties

file with the language code and country code for the language you want to use.

For example, to create the Canadian French version, save the file as

Lookup_fr_CA.properties

In a text editor, open the localized file you create.

For each lookup table value, add the localized value in the following format:

Save the file.

Go to the following directory:

<MDM Installation Directory>/server/lib

Copy the following files:

log4j-1.2.16.jar

ojdbc7.jar

. If you use Oracle database.

db2jcc.jar

. If you use IBM DB2 database.

sqljdbc4.jar

. If you use Microsoft SQL Server database.

Paste the copied files into the following directory:

<MDM Installation Directory>/app/tcr/lookuplocalization/lib

Open a command prompt, and go to the following directory:

<MDM Installation Directory>/app/tcr/lookuplocalization/bin

Run the following command:

On UNIX.

lookup_localization.sh

On Windows.

lookup_localization.bat

At the prompts, enter the following parameters:

Parameter	Description
Database type	Type of database that you use. Use one of the following values: Oracle DB2 MSSQL
User name	User name to access the Operational Reference Store database.
Password	Password for the user name.
Operational Reference Store database host name	Name of the host that runs the Operational Reference Store database.
Operational Reference Store database port number	Port number that the database listener uses.
Database name	For IBM DB2 and Oracle only. Name of the IBM DB2 database or Oracle service.