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
- At the prompt, enter
- Alter the pmconfig script.
+------------------------------------------+
+ Informatica Server Configuration Utility +
+ Copyright (c) Informatica Corp. 1996-2001+
* All Rights Reserved. +
+-------------------------------------------+Configuration file name [pmserver.cfg]:
RepositoryName[RepositoryName]: Siebel_DW_Rep
DBUser[DatabaseUser]: _________
DBPassword[************]: _________
LMStayConnectToRepositDuration[300]:
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]: _________
DateHandling40Compatibility[No]:
DateDisplayFormat[DY MON DD HH24:MI:SS YYYY]:
ValidateDataCodePages[Yes]: No
LoadManagerAllowDebugging[No]:
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |