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

Configuring the Informatica Server Under Windows

NOTE:  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 the Informatica Server under Windows

  1. Go to Start > Programs > Informatica Server > Informatica Server Setup.
  2. Select Configure Informatica Service and click Configure.
  3. In the Keys tab, enter the Platform Key, Oracle Key, Microsoft SQL Server Key, DB2 Key, and ODBC Key. Click Apply.
  4. In the Network tab, in TCP/IP Host Address field, enter the machine name where Informatica Server is installed.
  5. Oracle only:
    Navigate to Compatibility tab. In Oracle Version field, select Oracle 8.
  6. Navigate to Repository tab. In the Repository Name field, enter the name that you entered for your repository. (The example used Siebel_DW_Rep.) In the Repository user and Repository password fields, enter "Administrator."
  7. To connect to the Siebel Data Warehouse repository, fill in the fields with this information:

    8. Field
    Enter
    Database Type
    DB2, Oracle, or MS SQL
    Database user
    OLAP user name
    Database password
    OLAP password
    Connect String
    OLAP database alias name. The Informatica repository is usually stored in OLAP folder.

  8. Navigate to Miscellaneous tab. In the Data Movement Mode: option, select UNICODE. Click OK.

    9. NOTE:  Run Informatica Server in Unicode mode when the source data supports multibyte or ISO 8859-1 (8 bit ASCII) code pages or when the source and target database is Unicode.
    If not using a Unicode database, select the ASCII option.

  9. In Miscellaneous tab, check only Perform Event Logging and Disable Recovery.
  10. Click OK, then click Exit to close the Informatica Server Setup.

 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003