Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Deploying Informatica and Siebel Data Warehouse in Unicode and Non-English Environments >

Siebel Data Warehouse Unicode and Code Page Procedures

---

This section provides the following procedures related to configuring Unicode and code pages.

• To determine the NLS_LANG value
• To determine the DB2CODEPAGE
• To set SiebelUnicodeDB for Windows
• To set NLS_LANG value on Windows
• To set the NLS_LANG value on UNIX
• To set SiebelUnicodeDB on Informatica Server if source and target databases are Unicode on UNIX

To determine the NLS_LANG value

• 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

To determine the DB2CODEPAGE

• In the data warehouse database, run the command
     SELECT CODEPAGE FROM SYSCAT.DATATYPES
WHERE TYPENAME = 'VARCHAR'

  Example result: 1208

To set SiebelUnicodeDB for Windows

1. Navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Services > PowerMart > Parameters > MiscInfo.
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].

     NOTE:  You must enter the user names and connect strings in the same case as you used in the Workflow Manager > Connections > Relational settings.

To set NLS_LANG value on Windows

1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
2. In System variables section, click New.
3. Create the system variable name.
   • For Oracle databases:
     • In the Variable Name field, enter NLS_LANG.
     • In the Variable Value field, enter x_x.UTF8.

       where x_x is the character set.

       For example: American_America.UTF8.

   • For DB2 databases:
     • In Variable Name field, enter DB2CODEPAGE.
     • In Variable Value field, enter 1208.
4. Click OK to close.
5. Reboot the machine after creating the variables.

To set the NLS_LANG value on UNIX

1. Determine the NLS_LANG value.
2. Enter the following at the prompt:

   setenv NLS_LANG <NLS_LANG value>

   For example: setenv NLS_LANG American_America.UTF8.

CAUTION:  Do not put these setenv commands in the .cshrc file. Other machines and usernames also use this file, and this command will corrupt their non-Unicode environments.

To set SiebelUnicodeDB on Informatica Server if source and target databases are Unicode on UNIX

• For all UNIX platforms, if both the transactional and data warehouse data sources are Unicode, add the following line in /export/home/informatica/pm/pmserver.cfg file.

  SiebelUnicodeDB=<OLTP_TBO>@<OLTP_connectionString> <OLAP_TBO>@<OLAP_ConnectionString>

  For example:

  SiebelUnicodeDB=ora16221@sdcdl580i016_qa16b ora16222@sdcdl580i016_qa16b (Refer to instructions)

Bookshelf Home | Contents | Index | Search | PDF