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

Configuring Informatica Repository Manager

To configure Informatica Repository Manager

  1. Navigate to Start > Programs > PowerMart Client > Repository Manager.
  2. Highlight the repository named Siebel_DW_Rep.

    3. NOTE:  If the repository name does not exist, click the Repository menu bar and select Add repository.

  3. Click Repository menu and select Edit Connection Information.

    4. NOTE:  Make sure that the name of the repository (for example, SIEBEL_DW_REP) matches the name of the repository you entered in the section Setting Up the Siebel Data Warehouse. Do not change the name of the Administrator account (Administrator). There are predefined components that rely upon these names.

  4. In the Edit Connection Information window, Connect to Repository section, for Username and Password fields, enter "Administrator."
  5. In Connect to Database section, fill out the fields using the following table as a guide.

    6. Field
    Description
    ODBC data source
    Pull down the menu and choose the ODBC data source you set up in Table 3.
    Database username
    Use the information you set up in Table 3.
    Database password
    Native connect string

    NOTE:  For Oracle, Informatica client uses MERANT ODBC driver.

  6. Click Connect.

    7. If the connection information was entered correctly, you see a message, "Connection Information Changed Successfully."

    If the connection is not successful, troubleshoot the ODBC connection to the Siebel Data Warehouse and resume at Step 5 of this procedure.

  7. Exit from the Informatica Repository Manager.

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