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.
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
- 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.
- In the Login... dialog box, select Configure.
- In the Configuring... dialog box, select Create Connection, and then click Next.
- Enter the appropriate connection details.
|
|
Name |
A unique database name. |
Connection Type |
Type of database. |
Connection String |
If you are using...
|
Database Host |
Machine name where the database resides. |
Database Port |
The port number where the database listens. |
- 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.
- (Optional for Oracle or DB2 databases) Specify a tablespace.
- (Optional for MSSQL or DB2 databases) Check the Unicode check box if the environment is Unicode.
- 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
- From the DAC menu bar, choose Tools > DAC Repository Management > Import.
- Select the appropriate import option, and click OK.
|
|
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. |
- 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.
|