Bookshelf Home | Contents | Index | PDF     

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

Siebel Data Warehouse Installation and Configuration Process on UNIX

The Siebel Data Warehouse installation and configuration process on UNIX consists of the following steps. Complete each of the following tasks in the order listed below.

Table 27.  UNIX Installation and Configuration Process
Task
Instructions
Environment
  1. Install the DAC server on UNIX.

    Use the Siebel Data Warehouse option of Siebel Analytics.

Siebel Analytics Installation and Configuration Guide

UNIX
  1. Install and Configure the Informatica Server and Repository Server on UNIX.

Installing and Configuring the Informatica Server and Repository Server on UNIX.

UNIX
  1. For Teradata databases, install the Teradata patch.

Installing the Teradata Patch on UNIX.

UNIX
  1. Set Informatica Data Code Pages Validation.

Setting Informatica Data Code Pages Validation.

Windows
  1. Install the Java SDK on the machines where both the DAC client and DAC server are installed.

Installing the Java SDK.
  • Windows (DAC client)
  • UNIX (DAC server)
  1. Configure the DAC config.bat file.

Configuring the DAC Config.bat File.

Windows
  1. Create the DAC Metadata Repository.

Creating the DAC Metadata Repository.

Windows
  1. Configure the DAC Metadata Repository.

 

Setting Up DAC System Properties.

Windows

Creating ODBC Database Connections.

Windows

Creating Database Connections for Teradata Installations.

UNIX

Registering Informatica Servers on the DAC Client.

Windows

Configuring Email Recipients on the DAC Client.

Windows

Activating Join Indices for Teradata Databases.

Windows
  1. Configure the Siebel Data Warehouse.

Creating the SSE Role.

Windows

Creating Data Warehouse Tables.

Windows
  1. Set environment variables for the Informatica Server.

Setting Environment Variables for the Informatica Server on UNIX.

UNIX
  1. Set the Windows PATH environment variable for the Informatica Server.

Setting Environment Variables on Windows.

Windows
  1. Copy database parameter files.

Copying Database Parameter Files.

Windows
  1. Copy Teradata Loader Control Files.

Copying Teradata Loader Control Files.

Windows
  1. Start the Informatica Repository Server.

Starting the Informatica Repository Server on UNIX.

UNIX
  1. Create or restore and configure the Informatica repository.

Creating or Restoring the Informatica Repository.

Windows

Dropping the Informatica Repository (Optional).

Windows

Registering the Informatica Repository Server in Repository Server Administration Console.

Windows

Pointing to the Informatica Repository.

Windows

Configuring the Informatica Repository in the DAC.

Windows

Configuring the Informatica Repository in Workflow Manager.

Windows
  1. Set the Code Page File Property for Unicode Environments on Teradata Databases

Setting the Code Page File Property for Unicode Environments on Teradata Databases

Windows
  1. Set Up the HOSTS File for Teradata Installations

Setting Up the HOSTS File for Teradata Installations on UNIX.

UNIX
  1. Verify the Informatica Repository configuration.

Verifying the Informatica Repository Configuration.

Windows

 
  1. Start the Informatica Server.

Starting the Informatica Server on UNIX.

UNIX
  1. Set the DAC ETL Preferences.

Setting DAC ETL Preferences.

Windows
  1. Configure the DAC server.

Configuring the DAC Server on UNIX.

UNIX
  1. Update the Siebel transactional database schema definition.

Backing Up the Siebel Repository.

Windows

Importing the SIF File into the Siebel Transactional Database.

Windows

Verifying the SIF Patch Application.

Windows

Creating Delete Triggers.

Windows

    
Siebel Data Warehouse Installation and Administration Guide