Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse > Deploying Informatica and Siebel Data Warehouse in Non-English Environments >

Configuring Code Page to Unicode Environments

For installation on multibyte code page environments, the data warehouse setup requires two operating system environments: one on an English code page-based operating system and one on the multibyte language-based operating system. Examples of multibyte operating systems are Japanese (JPN) or Korean (KOR).

During To install the Siebel Data Warehouse using the Siebel Data Warehouse installer, when filling out the Setup Type page, the Installer screen option "Create Siebel Data Warehouse tables" must be run from the multibyte operating system. However, all the other installation steps must be run from the English-language operating system.

Table 9 shows the DBMS settings for an environment with a Japanese source database and a Unicode target Siebel Data Warehouse.

Table 9.  Japanese Code Page to Unicode Settings
Parameters
Oracle
IBM DB2 UDB
Source DB code page
JA16SJIS
943
Source DB connection
In Workflow Manager > Connections > Relational, set to MS Windows Japanese
In Workflow Manager > Connections > Relational, set to Shift_JIS
Operating system Locale for Informatica Server
English-American operating system with environment variable NLS_LANG=AMERICAN_AMERICA.JA16SJIS
English-American operating system
Informatica Server code page
Windows Latin 1
Windows Latin 1
Informatica Server (Unicode settings)
SIEBELUNICODEDB not set. Data movement mode set to Unicode
SIEBELUNICODEDB not set. Data movement mode set to Unicode
Target DB connection code page
In Workflow Manager > Connections > Relational), set to MS Windows Japanese
In Workflow Manager > Connections > Relational, set to Shift_JIS
Target DB code page
AL32UTF8 (Unicode)
1208 (Unicode)
Informatica Repository Server code page
AL32UTF8 (Unicode)
MS Windows Latin 1 (ANSI)
Operating system Locale for Informatica Repository Server
ENU with NLS_LANG =AMERICAN_AMERICA.AL32UTF8
ENU with DB2CODE PAGE set to 1208
Code page of Informatica Repository
Code page of the Informatica repository database.
1208 (Unicode)

Table 10 shows the DBMS settings for an environment with a German source database and a Unicode target Siebel Data Warehouse.

Table 10.  Single-Byte Code Page to Unicode Settings
Parameters
Oracle
IBM DB2 UDB
Source DB code page
WE8ISO8859P1
1252
Source DB connection
In Workflow Manager > Connections > Relational, set to MS Windows Latin 1
In Workflow Manager > Connections > Relational, set to MS Windows Latin 1
Operating system Locale for Informatica Server
English -American
English-American operating system
Informatica Server code page
Windows Latin 1
Windows Latin 1
Informatica Server (Unicode settings)
SIEBELUNICODEDB not set; data movement mode set to Unicode
SIEBELUNICODEDB not set. Data movement mode set to Unicode
Target DB connection code page
In Workflow Manager > Connections > Relational, set to MS Windows Latin 1
In Workflow Manager > Connections > Relational, set to MS Windows Latin 1
Target DB code page
AL32UTF8 (Unicode)
1208 (Unicode)
Informatica Repository Server code page
MS Windows Latin 1 (ANSI)
MS Windows Latin 1 (ANSI)
Operating system Locale for Informatica Repository Server
ENU with NLS_LANG =AMERICAN_AMERICA.AL32UTF8
ENU with DB2CODEPAGE set to 1208
Code page of Informatica Repository
Code page of the Informatica repository database
1208 (Unicode)

Configuring Unicode to Unicode Environments

Unicode requires the code page configuration, described in this section.

NOTE:  Run Informatica Server in Unicode mode when the source data supports multibyte or ISO 8859-1 (8 bit ASCII) code pages, or when the source and target database is Unicode. If you are not using a Unicode database, select the ASCII option.

To configure Unicode for Windows

  1. Navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Services > PowerMart > Parameters > Configuration.
  2. On the right window panel, right-click and select New > String Value.
  3. Rename the new string value SiebelUnicodeDB.
  4. Double-click SiebelUnicodeDB.
  5. In the Value data: field, enter your [user_OLTP]@[connectString_OLTP] [user_OLAP]@[ConnectString_OLAP].

    For example, siebel@db204007 siebel@db204008.

    • For Oracle and DB2, leave a space between siebel@db204007 and siebel@db204008.
    • For MSSQL, use system DNS name for [connectString_OLTP] and [connectString_OLAP].
  6. Navigate to Control Panel > System and click Advanced tab. Click Environment Variables.
  7. In System variables section, click New.
  8. Create the system variable name.
    • For Oracle databases:
      • In the data warehouse database, run the command
           SELECT * FROM V$NLS_PARAMETERS
      • Mark the NLS_LANG [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
           For example:
              American_America.UTF8
      • In the Variable Value field, enter American_America.UTF8.
    • For DB2 databases:
      • In Variable Name field, enter DB2CODEPAGE.
      • In Variable Value field, enter 1208.
  9. Click OK to close.
  10. Reboot the machine after creating the variables.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004