Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications >

Upgrading the Informatica Repository

Follow this procedure to upgrade the Informatica Repository.

To upgrade the Informatica Repository

1. Back up your current Informatica Repository.

   For instructions, see the Informatica documentation on the Siebel Business Applications Third-Party Bookshelf.

2. Create the Informatica Repository:
   1. From the DAC menu bar, choose Tools > ETL Management > Configure.
   2. Select the database platforms for the following:
      • Target data warehouse
      • Source transactional database
      • Informatica repository
   3. In the Data Warehouse Configuration wizard, select the Create Informatica Repository check box, and then click Next.

      The Informatica Repository tab is active.

   4. Enter the following information.

      Field	Description
      Database Type	Type of database.
      Database Connection String	If you are using one of the following: 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.
      Host	Applicable only to an SQL Server. Indicates the machine host name where the server resides.
      Database Table Owner	Name of the table owner.
      Database Password	Password for the table owner.
      MSSQL Database Name	Applicable to an SQL Server only. Indicate the database name where you want to restore the repository.
      Informatica Repository name	A logical name for the Informatica repository.
      Informatica Administrator Login	Not applicable while creating the repository. Used only to configure the repository.
      Informatica Administrator Password	Not applicable while creating the repository. Used only to configure the repository.
      Repository Server	Name of the machine hosting the Informatica Repository Server.
      Repository Server Port	Port number used by Informatica Repository Server to listen to requests.
      Email Address	Not applicable while creating the repository. Used only to configure the repository.

      A message box informs you that the repository was created successfully.

3. Copy the Custom folder from your previous Informatica repository to the newly created Informatica repository:
   1. Launch the Informatica Repository Manager, and connect to both your previous and newly created Informatica repositories.
   2. Select the Custom folder in your previous repository and copy it (Edit > Copy).
   3. Select the newly created Informatica Repository and paste it (Edit > Paste). Rename the folder if necessary to paste it to this location.

      This action creates the Custom folder and all its contents (mappings, workflows, and so on).

   4. Create an individual workflow for each of the mappings in the Custom folder.
   5. Register the mappings in the DAC.

      You will verify your customized mappings in the procedure Verifying ETL Customizations, which you perform after the data migration.