Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Process of Configuring and Managing the Informatica Repository >

Process of Loading the Pre-Built Repository Into Informatica

You use the Restore option in the Informatica Repository Administration Tool to load the pre-built Oracle_BI_DW_Base.rep repository into Informatica.

NOTE:  When you install Oracle BI Applications in a Teradata environment, you must load the pre-built Informatica repository file \dwrep\Oracle_BI_DW_Teradata.rep.

Before you start this procedure, you need to create a database to contain the Informatica Repository. You can use the same database as the data warehouse database. For more information, see Creating the Required Databases.

To load the pre-built Oracle_BI_DW_Base.rep repository into Informatica

1. Copy the Oracle_BI_DW_Base.rep from the OracleBI\dwrep\Informatica\Repository folder to the \Informatica PowerCenter 7.1.4\RepositoryServer\bin\Backup folder.
2. Launch the Repository Server Administration Console and connect to the Informatica Repository machine.
3. Click Backups to display available backup files in the right hand pane.
   
4. Right click on Oracle_BI_DW_Base.rep and click Restore to display the Restore Repository dialog.
   
5. Click the 'Create a new Repository and associate the restored information with it' check box.
6. Click OK to start the Restore procedure and display the New Repository dialog.
7. In the General tab, in the Repository Name field, enter the name for the Informatica repository (for example, Oracle_BI_DW_Base).

   NOTE:  This value should match the value you entered in Setting Up the Informatica Server and Informatica Repository Server (for example, Oracle_BI_DW_Base).

   
8. In the Database Connection tab, enter the following information:

   Field	Description
   DatabaseType	The type of database storing the repository.
   CodePage	The code page based on the operating system platform.
   ConnectString	The native connect string of the database that stores the data warehouse. For MSSQL Server databases, use <SERVERNAME@DATABASENAME>.
   DBUser	The account used to access the DAC repository (for example, DAC).
   DBPassword	The password for the DAC repository user (for example, DAC).

9. Click the Licenses tab.

   You may see a message stating the license file is empty.

10. Click OK to close the message dialog box.
11. In the License Key field, enter the Product license key, and then click Update.

    The license key information appears in the lower window of the Licenses tab.

12. Repeat the step above for the Option and Connectivity license keys.
13. Click OK to save the repository details and create the repository.
14. Select the repository, right-click and then click Start to start the repository.

NOTE:  The Informatica repository tables need to be analyzed for better performance. This procedure must be done manually by the database administrator.