Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows >

Configuring the Informatica Server


Follow this procedure to configure the Informatica Server.

To configure the Informatica Server

  1. Navigate to Programs > Informatica Server > Informatica Server Setup.
  2. In the Informatica Server Setup Application - Options window, select Configure Informatica Service, and then click Continue.
  3. In the Keys tab of the Configure Informatica Service dialog box, enter the Platform Key and the appropriate database server key.
  4. In the Server tab, enter the following:
    Field
    Description

    Server Name

    A logical name for the Informatica Server. It is recommended that you enter SIEBEL_DW_SERVER.

    TCP/IP Host Address

    The IP address or name of the machine on which you plan to run the Informatica Server.

    Max no. of concurrent sessions

    From 1 to 15 sessions but not greater than 15.

    Shared Memory

    A number not greater than 3000000.

  5. In the Repository tab, enter the following:
    Field
    Description

    Repository Name

    A logical name for the Informatica repository. It is recommended that you enter SIEBEL_DW_REP. For Teradata databases, it is recommended that you enter SIEBEL_DW_Rep_Teradata.

    Repository User

    It is recommended that you use Administrator as the username.

    Repository Password

    The password you use to connect to the Repository Server from the Repository Manager. It is recommended that you use Administrator as the password.

    NOTE:  This value should match the value you entered in Step 6 of the procedure To install the Informatica Repository Server on Windows.

    Repository Server Host Name

    The host machine name where the Informatica Repository Server is installed.

    Repository Port Number

    The port number the Repository Server uses to connect to repository client applications. By default, this value is 5001. It is recommended that you use the default value.

    NOTE:  This value should match the value you entered in Step 6 of the procedure To install the Informatica Repository Server on Windows.

  6. In the Configuration tab, set the Data Movement Mode.
    1. Select the ASCII or UNICODE option.
    2. If you select the UNICODE option, remove the check from the Validate Data Codepages check box, and check the Output Session Log in UTF8 check box.
    3. Leave the default values in the remaining fields.
  7. In the Compatibility and Database tab:
    1. Make sure the "Treat Char as Char on read" option is selected.
    2. Make sure the maximum number of database connections is 100.
  8. In the JavaSdk tab, leave the default values in all fields.
  9. Click OK in the Configure Informatica Service dialog box to complete the configuration of the Informatica Server service.

NOTE:  You cannot start the Informatica Server until you have completed the procedures in the section Creating, Restoring, and Configuring the Informatica Repository.

Siebel Data Warehouse Installation and Administration Guide