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 Informatica Server Database Connection
From the menu bar, click Server Configuration and select Database Connections. When this process is completed, proceed to build the Siebel Data Warehouse.
To configure the Informatica Server database connection
- For both OLTP and OLAP, use the default value for the Code Page field.
- Start Informatica Server Service.
- At the Informatica Server root directory, enter
pmserver
to start the service.- Check pmserver.log file to see if it has started successfully. It has started successfully if it says Server initialization completed successfully.
- To stop the server, enter
./pmcmd stopserver <repository username> <repository password> <port #>.
For example:
./pmcmd stopserver Administrator Administrator 4001
- Check whether Informatica server is running by entering the command
ps -elf |grep pmserver.
If it lists pmserver process, the server is running. If it lists grep pmserver, that is the process of the ps command.
- Set Environment for Unicode.
- Add the environment following variables.
- For Oracle, enter:
setenv NLS_LANG american_america.UTF8
- For DB2, enter:
setenv DB2CODEPAGE 1208
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.
- For all UNIX platforms, add the following line to pmserver.cfg:
SiebelUnicodeDB=<oltp_tableowner>@<oltp_connectstring> <olap_tableowner>@<olap_connectstring>
NOTE: There should be a space between <oltp_connectstring> and <olap_tableowner>.
For example:
SiebelUnicodeDB=siebel@DB204166 siebel@DB204167
- In Informatica Server Manager, right-click SIEBEL_DW_SERVER and select Edit.
- Click on Advanced. In Code Page field, select ISO 8859-1 Western European.
This code page is for UNIX environment, not Unicode specific.
- Click Server Configuration from menu bar and select Database Connections.
- If you are using Oracle Unicode database, select UTF-8 encoding of Unicode in Code Page field, for both OLTP and OLAP databases. For other Unicode databases, use the default Code Page.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |