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
NOTE: If you are using both SQL Server 2000 and Oracle (for example, Oracle for the Siebel Transaction Database and SQL Server 2000 for the Siebel Data Warehouse), then follow the procedural steps relating to odbcbcp.dll.
Notes on Special Cases of Informatica Installations
- For installations under UNIX, install the Informatica software directly from the CD-ROM.
NOTE: If you cannot install the software directly, you must use ftp in binary mode. Otherwise, the installation will fail.
- Informatica Server (Data Warehouse Server) must be run using Code Page 1252. For example, Japanese users need to run the ETL process from a machine that has an English-language version of Microsoft Windows installed. In addition, use a period (.) as the decimal delimiter for this server to function properly.
Although the Informatica server must be run on a Code Page 1252 operating system, the data source and target can be on any Siebel Systems-supported code page, including non-European and double-byte, provided that the data source and data target code pages are the same.
To configure Informatica Server
- At the prompt, enter
./pmconfig
- Alter the pmconfig script.
+------------------------------------------+
+ Informatica Server Configuration Utility +
+ Copyright (c) Informatica Corp. 1996-2001+
* All Rights Reserved. +
+-------------------------------------------+Configuration file name [pmserver.cfg]:
ServerPort[4001]:
RepositoryName[RepositoryName]: Siebel_DW_Rep
DBUser[DatabaseUser]: _________
DBPassword[************]: _________
PMUser[Administrator]:
PMPassword[*************]:
DatabaseType[Oracle]:
ConnectString[]: _________
ErrorLogFile[pmserver.err]:
EventLogFile[pmserver.log]:
PerformEventLogging[Yes]:
DataMovementMode[ASCII]:
MaxSessions[10]:
LMSharedMem[2000000]:
KeepRepeatSessionInShm[No]:
LMStayConnectToRepositDuration[300]:
PMCacheDir[.]:
PlatformKey[enter_unix_platform_key]: _________
OracleKey[enter_oracle_database_key]: _________
SybaseKey[enter_sybase_database_key]:
InformixKey[enter_informix_database_key]:
DB2Key[enter_db2_database_key]: _________
ODBCKey[enter_odbc_database_key]: _________
DisableRecovery[No]: Yes
DisableRecovery[No]: Yes
OverrideExecLocking[0]:
DateHandling40Compatibility[No]:
Pmserver3XCompatability[0]:
AggregateTreatNullAsZero[0]:
AggregateTreatRowAsInsert[0]:
OracleVersion[7]: 8
DateDisplayFormat[DY MON DD HH24:MI:SS YYYY]:
ValidateDataCodePages[Yes]: No
LoadManagerAllowDebugging[No]:
CreateIndicatorFiles[No]:
XMLWarnDupRows[No]:
MaxLookupSPDBConnections[0]:
MaxSybaseConnections[100]:
MaxMSSQLConnections[100]:
SybaseIQLocalToPmServer[No]:
NumOfDeadlockRetries[10]:
DeadlockSleep[0]:
ValidateDataCodePages[No]: <----existing>
SessionLogInUTF8[No]:
<end>
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |