Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Configuring Informatica Server and Workflow Manager >

Configuring the Informatica Repository Server (in the Repository Administration Console)

After you restore the Informatica repository on the Administrator Workstation, you need to configure it. Set up and configure the repository connectivity, and then set up the client to point to the correct Informatica Server machine.

Before you configure the Informatica Repository Server, make sure that the Informatica Server is not running and the Informatica Repository Server is running.

To start the Informatica Repository Server

After you have started the Informatica Repository Server, use the PowerMart Repository Server Administration Console for this configuration procedure.

To configure the Informatica Repository Server

  1. Navigate to Start > Programs > Informatica PowerMart 6.1 OEM for Siebel—Client. Click the Repository Server Administration Console to open it.
  2. In the main menu, click Action >Add a new Server Registration.
    1. Enter the host name (the machine that has the repository).
    2. Accept the default port number 5001.
    3. Right-click the server name and choose Connect.
    4. In the Connect to Repository section, Username and Password fields, enter Administrator.
  3. Click on the Repository menu and select Add repository > Siebel_DW_Rep.
  4. Right-click Siebel_DW_Rep and select Edit Connection.
    1. If your repository server is on an English UNIX machine, set the Code Page to ISO 8859-1 Western European.
    2. To connect to the Siebel Data Warehouse repository, fill in the fields with this information:
      Field
      Enter
      Database Type
      DB2, Oracle, or MS SQL
      Database user
      OLAP user name
      Database password
      OLAP table password
      Connect String
      OLAP database alias name. The Informatica repository is usually stored in the data warehouse database folder.

      Click OK.

  5. Make sure that the Server is running.
    1. Under Windows, check the Windows Services.
    2. Under UNIX, check the log file.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 11 March 2004