Siebel Business Analytics Applications Installation and Administration Guide > Installing and Configuring Analytics Applications on Windows >

Creating the DAC Metadata Repository

This procedure provides instructions for creating a repository connection and importing seed data.

• To create the DAC metadata repository connection
• To import seed data into the DAC metadata repository

NOTE:  The DAC client can connect to only one DAC repository at a time.

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 connection

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. If you are using dynamic port allocation, see Connecting from DAC to SQL Server Using Dynamic Port Allocation. 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 when asked if you want 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.

To import seed data into the DAC metadata repository

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.