Bookshelf Home | Contents | Index | Search | PDF |
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
- Navigate to Start > Programs > PowerMart Client > Repository Manager.
- Highlight the repository named Siebel_DW_Rep.
NOTE: If the repository name does not exist, click the Repository menu bar and select Add repository.
- Click Repository menu and select Edit Connection Information.
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.
- In the Edit Connection Information window, Connect to Repository section, for Username and Password fields, enter "Administrator."
- In Connect to Database section, fill out the fields using the following table as a guide.
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 stringNOTE: For Oracle, Informatica client uses MERANT ODBC driver.
- Click Connect.
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.
- Exit from the Informatica Repository Manager.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |