Bookshelf Home | Contents | Index | Search | PDF

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 Hardware Configuration

Planning the Installation

The Siebel Data Warehouse Administrator Workstation

The Data Warehouse Server

The Siebel Server

The Web Server

Creating Multiple Instances of Siebel Data Warehouse

Requirements for Server Components

Additional Data Warehouse Server Requirements for Windows 2000

Installing Informatica Documentation

Deploying Informatica and Siebel Data Warehouse in Non-English Environments

Configuring Code Page to Unicode Environments

Siebel Data Warehouse Database Requirements

IBM DB2 UDB-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

Siebel Data Warehouse Installation Overview

Installing Informatica Software

Installing Informatica Repository Server

Installing the Informatica Server

Changing Informatica Database .dll Files

Installing Informatica Client

Data Code Pages Validation

Prerequisites to Setting Up the Siebel Data Warehouse

Installing the Siebel Data Warehouse

Installing the Siebel Data Warehouse

Post-Installation Wizard Tasks

Creating Database Connections

Configuring the Informatica Servers

Configuring the Informatica Service

Configuring the Repository Server Using the Repository Administration Console

Configuring Informatica Client Console for Host Server

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

Siebel Data Warehouse Data Code Pages Validation

Applying the .SIF File

Upgrading the Informatica Platform

Upgrading the Data Warehouse Schema Using upgrep_dw

Back to top

---

Setting System Preferences and Using Exception Reports

Using ETL Alignment Version System Preferences

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 Workflows

Performing a Refresh Load of the Siebel Data Warehouse

Modifying Workflow Processes for Industry Applications

Optional Customization Procedures

Improving Performance of Full_Load_Siebel_DW

Linking Workflows

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 Data Warehouse 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

---

The Siebel 6.3 to 7.5 Analytics Bridges

Installation Process

Begin the Standard Installation of Siebel Analytics 7.5

Pause the Installation of Siebel Analytics

Replace the Informatica Repository File

Continue the 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

Localize the Siebel Analytics Bridge

Siebel Analytics 6.3 Bridge Files

Configuration Considerations

Creating Siebel Analytics Users in Siebel 6.3 eBusiness Applications

Creating Database Tables for the Siebel Delivers Scheduler

Viewing Analytics Content

Back to top

---

The Siebel 7.0.4 to 7.5 Analytics Bridges

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 Installation of Siebel Analytics

Replace the Siebel Analytics Repository File

Import New Siebel OLTP Schema Definitions

Apply Schema Definitions to the Physical Database

Enable Siebel Analytics Screens

Import Language-Independent Siebel Seed Data

Localize the Siebel Analytics Bridge

Siebel Analytics 7.0.4 Bridge Files

Configuration Considerations

Creating Siebel Analytics Users in Siebel 7.0.4 eBusiness Applications

Creating Database Tables for the 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

---

Applying SIF Patches

Applying SIF Files to the Database

Backing Up the Repository

Importing the SIF File

Verifying the Patch Application

Applying the SIF Contents to the Schema

Verifying the Physical OLTP Schema Modification

Back to top

---

Capturing Row Deletion Changes

Delete Change Capture

Delete Propagation

Back to top

Bookshelf Home | Contents | Index | Search | PDF