Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Using the DAC's Data Warehouse Configurator Wizard >

Creating the Informatica Repository (in the DAC)

To create 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.
    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.
    Repository Server
    Name of 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 restoring the repository. Used only to configure the repository.

 Siebel Data Warehouse Installation and Administration Guide
 Published: 11 March 2004