Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Setting Up the DAC Client >

Starting the DAC Client and Importing Seed Data

The DAC client can connect to multiple DAC repositories but only one at a time. This procedure provides instructions for connecting to a repository for the first time. It guides you through creating a repository connection and importing seed data.

To start the DAC Client

  1. Launch the DAC client by double-clicking the startclient.bat file in the DAC directory or by running startclient from a command prompt.
  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.
  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.

  6. (Optional for Oracle or DB2 databases) Specify a tablespace.
  7. 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.

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

NOTE:  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.


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