Bookshelf Home | Contents | Index | Search | PDF

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

Configuring Informatica Server

---

Depending on your platform, Informatica installations may require additional configuration steps. Three special cases are installing on UNIX operating systems, running native databases in Japanese or other double-byte code pages, and running Oracle and SQL Server together.

• 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.

• If you are using both SQL Server 2000 and Oracle (for example, Oracle for the Siebel transactional database and SQL Server 2000 for the Siebel Data Warehouse), then follow the procedural steps relating to odbcbcp.dll.

To configure Informatica Server

1. At the prompt, enter

   ./pmconfig

2. 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