Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse > Configuring Informatica Server and Repository >

Configuring Unicode Under Windows

---

Unicode requires a different code page configuration, described in this section.

To configure Unicode for Windows

Navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Services > PowerMart > Parameters > MiscInfo.
On the right window panel, right-click and select New > String Value.
Rename the new string value SiebelUnicodeDB.
Double-click SiebelUnicodeDB.
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].
Navigate to Control Panel > System and click Advanced tab. Click Environment Variables.
In System variables section, click New.
Create the system variable name.
For Oracle databases:
In the OLAP, 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 NLS_LANG.
For DB2 databases:
In Variable Name field, enter DB2CODEPAGE.
In Variable Value field, enter 1208.
Click OK to close.
Reboot the machine after creating the variables.

Bookshelf Home | Contents | Index | Search | PDF