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