Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows >

Creating the DAC Metadata Repository

The DAC client can connect to multiple DAC metadata repositories but only one at a time. This procedure provides instructions for creating a repository connection and importing seed data.

NOTE:  Before you start this procedure, you need to create a database for the DAC metadata repository. This database can be the same as the data warehouse database.

To create the DAC metadata repository

1. Launch the DAC client by double-clicking the icon on your desktop or navigating to the SiebelAnalytics\DAC directory and double-clicking the startclient.bat file.
2. In the Login... dialog box, select Configure.
3. In the Configuring... dialog box, select Create Connection, and then click Next.
4. Enter the appropriate connection details.

   Field	Description
   Name	A unique database name.
   Connection Type	Type of database.
   Connection String	If you are using... Oracle (OCI8) use the tnsnames entry. Oracle (Thin) use the instance name. SQL server use the database name. DB2-UDB use the connect string as defined in the DB2 configuration.
   Database Host	Machine name where the database resides.
   Database Port	The port number where the database listens.

5. Test the connection to make sure it works.

   If the DAC repository schema does not exist in the database to which you are connecting, the schema will be automatically created. When a repository is created on Oracle or DB2 databases, you have the option of specifying a tablespace. For MSSQL and DB2 databases, you can indicate whether the environment is Unicode.

6. (Optional for Oracle or DB2 databases) Specify a tablespace.
7. (Optional for MSSQL or DB2 databases) Check the Unicode check box if the environment is Unicode.
8. Click Yes to have the repository created automatically.

   NOTE:  The DAC repository is not supported on DB2-390 databases. If your source or target database is DB2-390, you need to use a DB2-UDB, MSSQL, or Oracle database for both the DAC repository and the Informatica repository.

9. Import seed data.
   1. From the DAC menu bar, choose Tools > DAC Repository Management > Import.
   2. Select the appropriate import option, and click OK.

      Option	Description
      Import All Tables	Imports all database tables.
      Import Categories > Logical	Imports all information contained in the DAC Design view and database connection information.
      Import Categories > Run Time	Imports all information contained in the DAC Execute view.
      Import Categories > System	Imports all information contained in the DAC Setup view, except passwords for servers and database connections.
      Import Selected Tables	Allows you to select tables for importing.

   3. If your source or target database is a DB2-390 database, run DAC_DB2390_Source.sql or DAC_DB2390_Target.sql immediately after importing the seed data by connecting to the database where the DAC repository resides.