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 the Repository Server Using 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 (Data Warehouse Server) machine.

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

To stop the Informatica server and repository

1. Start the Informatica Repository Server.
2. If you are installing under Windows, proceed to step 2a.

   If you are installing under UNIX, skip step 2a and proceed to step 2b.

   1. In Windows Services, start the Informatica Repository Server.

      Always check the log file in the Informatica directory.

   2. In UNIX, start the repository server.
      • Navigate to /export/home/informatica/repositoryserver.
      • Type pmrepserver.
      • Check the pmrepserver.log file.

Once you have stopped the servers, 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.

   NOTE:  Informatica Server (Data Warehouse Server) must be run using Code Page 1252.

   1. For Windows machines, set Code Page to MS Windows Latin 1 (ANSI).
   2. For UNIX machines, set Code Page to ISO 8859-1 Western European.
   3. 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 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.

Bookshelf Home | Contents | Index | Search | PDF