Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Creating, Restoring, and Configuring the Informatica Repository >

Creating or Restoring the Informatica Repository

If you are using an MSSQL, Oracle, or DB2 database, follow this procedure to create or restore the Informatica repository using the DAC.

If you are using a Teradata database, you need to create or restore the Informatica repository using the Informatica Repository Manager. You cannot create or restore the Informatica repository using the DAC. For instructions, see To create or restore the Informatica repository for Teradata installations.

NOTE:  Before you start this procedure, you need to create a database to contain the Informatica Repository. This database can be the same as the data warehouse database.

To create or restore the Informatica repository

1. From the DAC menu bar, click Tools > ETL Management > Configure.
2. Select the Create Informatica Repository check box.

   The Informatica Repository tab is active.

3. Enter the following information:

   Field	Description
   Database Type	Type of database.
   Table Owner	Valid database user.
   Database Connection String	If you are using... Oracle (OCI8) use the tnsnames entry. Oracle (Thin) use instance name. SQL Server use the database name. DB2-UDB/DB2-390 use the connect string as defined in the DB2 configuration. Teradata use the database name.
   Host	Applicable only to SQL Server. Machine host name where the server resides.
   Database Table Owner	Name of table owner.
   Database Password	Password for table owner.
   MSSQL Database Name	Applicable to SQL Server only. The database name where you want to restore the repository.
   Informatica Administrator Name/Password	Not applicable while restoring the repository. Used only to configure the repository. NOTE:  These values should match the values you entered in Step 5 of the procedure To configure the Informatica Server.
   Repository Server	Name of machine hosting the Informatica Repository Server. NOTE:  This value should match the value you entered in Step 5 of the procedure To configure the Informatica Server.
   Repository Server Port	Port number used by Informatica Repository Server to listen to requests. NOTE:  This value should match the value you entered in Step 5 of the procedure To configure the Informatica Server.
   Email Address	Not applicable while restoring the repository. Used only to configure the repository.

To create or restore the Informatica repository for Teradata installations

1. Launch the Informatica Repository Manager.
2. Register the Informatica Repository Server.
   1. In the left pane, select the Informatica Repository Servers node, which appears under Console Root.
   2. From the menu bar, select Action > New Server Registration.
   3. Enter the host name (the machine where the repository resides).
   4. Accept the default port number 5001 or enter the appropriate port number. Click OK.

      The Repository Server host name appears in the right pane under Hostname.

   5. Right-click the server name and choose Connect.
   6. In the Connection Information section, enter the Administrator password. Click OK.

      These values should match the values you entered in Step 5 of the procedure To configure the Informatica Server.

3. In the left pane, select the Repositories folder, which appears under the Repository Server name.
4. In the menu bar, click Action > Add Repository.
5. Add the repository to the cache.
   1. Enter the Database Type.
   2. Enter the Repository Name. This value should match the value you entered in Step 5 of the procedure To configure the Informatica Server.
   3. Enter the Connect String Name.
   4. Enter the Code Page based on the operating system platform.
   5. Enter a User and Password. These values should match the values you entered in Step 5 of the procedure To configure the Informatica Server. Click OK to save the information.

      A message box states the repository has been added to the Repository Server's cache, and asks if you want to create a repository using this connection information.

6. In the message box, click No.

   The repository will be restored from the .rpd file.

7. Copy the file Siebel_DW_Rep_Teradata.rep from the directory \SiebelAnalytics\dwrep\Informatica\Repository to the directory \Informatica Repository Server\bin\Backup.

   For UNIX installations, copy the file to the directory /Informatica Repository Server/Backup.

   NOTE:  You should now proceed to the procedure To configure the Informatica repository in the Workflow Manager for Teradata installations.

   You do not need to perform the procedures Registering the Informatica Repository Server in Repository Server Administration Console or Pointing to the Informatica Repository.