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
To set SiebelUnicodeDB 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].
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
- Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
- In System variables section, click New.
- Create the system variable name.
- Click OK to close.
- Reboot the machine after creating the variables.
To set the NLS_LANG value on UNIX
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>
SiebelUnicodeDB=ora16221@sdcdl580i016_qa16b ora16222@sdcdl580i016_qa16b (Refer to instructions)
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |