Siebel Data Warehouse Installation and Administration Guide


Introduction

Who Should Use This Guide

How This Guide Is Organized

Third-Party Products and Documentation

Revision History


Back to top


Overview of Siebel Data Warehouse

Data Flow into the Data Warehouse

Server and Client Configuration

Planning the Installation

The Administrator Workstation

The Data Warehouse Server

The Siebel Server

The Web Server

Creating Multiple Instances of Siebel Data Warehouse

Requirements for Server Components

Siebel Data Warehouse Requirements

DB2-Specific Database Requirements

Oracle-Specific Database Requirements

SQL Server-Specific Database Requirements

Overview of the Configuration Chapters


Back to top


Installing and Configuring the Siebel Data Warehouse

Installing Informatica Client Software

Creating Database Connections for OLAP and OLTP

Setting Up the Siebel Data Warehouse

Installing the Siebel Data Warehouse

Post-Installation Wizard Tasks

Changing the System Variables

Configuring Informatica Server and Repository

Configuring the Informatica Server Under Windows

Configuring Unicode Under Windows

Configuring Informatica Repository Manager

Changing the Informatica Server Host Name

Verifying the Informatica Server Host Name

Configuring the Informatica Repository

Starting the Informatica Service Under Windows

Setting the Environment Variables for Informatica Server Under UNIX

Configuring Informatica Server

Configuring Informatica Client

Configuring Informatica Server Database Connection


Back to top


Setting System Preferences and Using Exception Reports

Using the Exception Report and Diagnostic Views

Understanding Exceptions

Executing Exception Reports


Back to top


Administering and Troubleshooting the Siebel Data Warehouse

Populating the Initial Siebel Data Warehouse

Full Load Optimizer Settings in Oracle

Refresh Optimizer Settings in Oracle

Administering the Informatica Repository

Performing a Full Load of the Siebel Data Warehouse

Performing the ETL Process

Troubleshooting the ETL Process

Verifying Successful Loading of the Siebel Data Warehouse

Disabling Dimension, Fact, and SCD Batches

Performing a Refresh Load of the Siebel Data Warehouse

Modifying the Batch Processes for Industry Applications

Optional Customization Procedures

Improving Performance of Full_Load_Siebel_DW

Linking Batches

Importing Syndicated Data Into the Siebel Data Warehouse

Analytics Data Loading Matrix for Syndicated Data

Data Source Values for Syndicated Data Attributes

Informatica Metadata Reporter (IMR)

Siebel Analytics for Life Sciences Data Considerations

Data Loading Issues

Supported Incremental Updates in the LS Dimension Tables

Troubleshooting Siebel Data Warehouse

Installation and Initial Configuration Issues

Informatica and Loading Issues


Back to top


Extending the Siebel Data Warehouse

Common Methods to Extend Siebel Data Warehouse

Identify Fields

Design the ETL Process

Add Fields to Tables

Rebuild the Siebel Data Warehouse

ETL Process Description

Working With the Custom Folder

Custom Batches

Using Custom Templates

Description of Custom Templates


Back to top


The Siebel ePharma 6.3 to 7.5 Analytics Bridge

Installation Process

Analytics Bridge Installation

Siebel Application 6.3 OLTP Update Patch

Siebel Analytics 7.5 Repository Modification

Authentication Block Changes

Login Properties Block Changes

Authorization Properties Block Changes

Adding 7.5 Siebel Analytics Responsibilities to 6.3 Siebel ePharma Users

Using ETL Alignment Version System Preferences

Siebel ePharma 6.3 To 7.5 Star Matrix


Back to top


The Siebel eBusiness 6.3 to 7.5 Analytics Bridge

Installation Process

Begin the Standard Installation of Siebel Analytics 7.5

Pause the Standard Installation of Siebel Analytics

Replace the Informatica Repository File

Continue the Standard Installation of Siebel Analytics

Replace the Siebel Analytics Repository File

Import New Siebel OLTP Schema Definitions

Apply Schema Definitions to the Physical Database

Import Language-Independent Siebel Seed Data

Import Locale Seed Data

Siebel eBusiness Application 6.3 Analytics Bridge Files

Configuration Considerations

Creating Siebel Analytics Users in Siebel 6.3 eBusiness Applications

Creating Database Tables for Siebel Delivers/Scheduler


Back to top


Installing and Configuring the Siebel Data Warehouse in DB2 for OS/390

Prerequisites for Installing DB2 under OS/390

Installing Siebel Data Warehouse for DB2 under OS/390

Installing the Star Schema Tables on DB2 for OS/390

Back to top


 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003