Configuring Multiple Language Support for Data Matching

When using Oracle Data Quality Matching Server for data matching, you can configure different match rules for different languages. This is useful when you have multiple geographical implementations, and for each implementation, you want to use country-specific match rules.

The solution involves creating multiple systems in Informatica Identity Resolution, where each system corresponds to a specific country or language. Records with a specific language or country are routed to the corresponding system. Because each system is linked to a population, the respective country-specific population rules are used for matching the records. To use this feature, add the Append BC Record Type Field x vendor parameter for UI entry and the Batch Append BC Record Type Field x vendor parameter for batch mode. This vendor parameters is used to specify a field in the BC, which has the country or language information. The BC name can be Account, Contact, or Prospect where x represents the sequence number. For example: Batch Append Account Record Type Field 1.

You must add similar vendor parameters to the Business Service User Property of the ISS System Services business service to represent the IDT number corresponding to the Language. When you create multiple systems in Informatica Identity Resolution, you must specify a unique database number for each system which is used as part of the unique IDT table name in Informatica Identity Resolution. You must enter this same number into the Business Service User Property of the ISS System Services business service for each system. The name of the user property is the same as the name of the system created in Informatica Identity Resolution, and the value of the user property is the database number (for example, see the following figure).

Note: In order to pick up all the records that belong to the same country when running a data quality batch processing task, it is mandatory to define a search specification (to pick up the records belonging to the same country). You can define a search specification by navigating to the Administration - Server Management screen, then the Jobs view.

This feature can be extended as follows:

• Extended to have different match rules depending on the source of data (for example the Siebel application or other application).

• Extended to have different match rules depending on the mode of data entry (for example, real-time or batch processing mode). The procedure below describes how to configure multiple mode support for data matching when using the Oracle Data Quality Matching Server for data matching.

Use the following procedure to configure multiple language support for data matching when using the Oracle Data Quality Matching Server for data matching.

To configure the Siebel Server for Informatica Identity Resolution multiple language support

1. Create systems on the Informatica Identity Resolution server.

   1. Create separate SDF files for each Country (Population). Informatica provides Standard Populations for most of the countries. Standard Populations are distributed as part of SSA-NAME3 installation and can be copied separately if not selected when installing NAME3 server.

   2. Once all populations are in place, check and note the filename of each population, as this is the same name that is used in the SDF file.

      You can change System Name and System ID within the system definition file as follows:

      system-definition
      *=================
      NAME= siebeldq_XXXX
      ID= sYY
      

      Replace XXXX with Country, and YY with any number between and including 02 and 99. System ID 01 is reserved for Default System. For example, for Japanese population:

      filename : siebeldq_Japan.sdf
      Population files :
      japan.ysp
      

      Changes to SDF file:

      system-definition
      *=================
      NAME= siebeldq_Japan
      ID= s05
      

      System ID 01 is reserved for Default System

      Replace all occurrences of Population(usa) to Population(japan).

      Similar changes are required for each sdf file.

2. Configure the ssadq_cfg.xml configuration file in the <siebsrvr>/SDQConnector folder.

   For example, add the following parameter to the ssadq_cfg.xml file:

   <Parameter>
       <Record_Type>
           <Name>Account_Japan</Name>
           <System>siebeldq_Japan</System>
           <Search>search-org</Search>
           <no_of_sessions>25</no_of_sessions>
       </Record_Type>
   </Parameter>
   

3. In your Siebel application, navigate to the Administration - Data Quality screen, then the Data Quality Settings view and in the value field for the parameter shown in the following table, specify the following setting:

   Parameter Name	Value
   Enable DQ Multiple Languages	Yes

4. Enable multiple language support for real-time flow:

   1. Navigate to Administration - Data Quality screen, then Third Party Administration view in your Siebel application.

   2. Select ISS as the third party vendor.

   3. Add the vendor parameters shown in the following table:

      Name	Value
      Append Account Record Type Field 1	Primary Account Country
      Append Contact Record Type Field 1	Primary Personal Country

5. Enable multiple language support for batch flow:

   1. Navigate to Administration - Data Quality screen, then Third Party Administration view in your Siebel application.

   2. Select ISS as the third-party vendor.

   3. Add the vendor parameters shown in the following table:

      Name	Value
      Batch Append Account Record Type Field 1	Country
      Batch Append Contact Record Type Field 1	Primary Personal Country

6. Add the user property to the ISS System Services business service.

   The user property that you add must correspond to the system name created in Informatica Identity Resolution for the respective country. For example, if the system created for Japan is siebeldq_Japan and the ID is set to 5, then the user property name must be siebeldq_Japan and the value 05, as shown in the following table.

   User Property Name	Value
   siebeldq_Japan	05