| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Data Warehouse Installation and Administration Guide
Introduction to Siebel Data Warehouse Installation and Administration Guide
What's New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7, Rev. A
Overview of Siebel Data Warehouse
Siebel Data Warehouse Architecture
Siebel Data Warehouse Architecture Components
About the Data Warehouse Application Console
About the DAC Process Life Cycle
Installing and Configuring Siebel Data Warehouse
Siebel Data Warehouse Installation and Configuration Process
Siebel Data Warehouse Deployment Configuration
Operating System, Driver, and Connectivity Requirements for Siebel Data Warehouse
Database Parameters and Requirements for Siebel Data Warehouse
IBM DB2 UDB Windows 2000-Specific Database Requirements for Siebel Data Warehouse
IBM DB2 UDB zOS and OS/390-Specific Database Requirements for Siebel Data Warehouse
Oracle-Specific Database Requirements for Siebel Data Warehouse
Additional Suggestions for Optimizing Oracle Performance in Siebel Data Warehouse
SQL Server-Specific Database Requirements for Siebel Data Warehouse
Informatica Server Requirements for Windows 2000
Deploying Informatica and Siebel Data Warehouse in Unicode and Non-English Environments
Unicode to Unicode Parameter Settings for Siebel Data Warehouse
Code Page (Multibyte/Single-Byte) to Unicode Parameter Settings for Siebel Data Warehouse
Code Page (Multibyte/Single-Byte) to Code Page (Multibyte/Single-Byte) Parameter Settings for Siebel Data Warehouse
Siebel Data Warehouse Unicode and Code Page Procedures
Installing Siebel Data Warehouse-Related Software on Windows
Installing Siebel Analytics (Data Warehouse Option) on Windows
Installing the Informatica Server and Repository Server on Windows
Installing Informatica Client Software on Windows
Siebel Data Warehouse Data Code Pages Validation
Installing Java SDK and Drivers
Creating ODBC Database Connections
Configuring the DAC Config.bat File
Starting the DAC Client and Importing Seed Data
Using the DAC's Data Warehouse Configurator Wizard
Creating the Informatica Repository (in the DAC)
Configuring the Informatica Repository (in Repository Server Administration Console)
Dropping the Informatica Repository
Configuring the Informatica Repository (in DAC's Data Warehouse Configurator)
Creating Data Warehouse Tables
Dropping Data Warehouse Tables
Configuring Informatica Server and Workflow Manager
Configuring the Informatica Service
Configuring the Informatica Repository Server (in the Repository Administration Console)
Verifying the Informatica Server Host Name
Configuring the Informatica Repository Using Workflow Manager
Starting the Informatica Service on Windows
Adding the PATH Environment Variable for the DAC Server
Configuring Database Parameter Files
Setting Up DAC System Properties and Resources
Setting Up DAC System Properties
Registering Informatica Servers
Installing and Configuring Siebel Data Warehouse on UNIX
Setting Up Environment Parameters on UNIX (Prerequisite)
Installing Informatica Software on UNIX
Setting the Environment Variables for Informatica Server on UNIX
Configuring Informatica Repository from Informatica Workflow Manager on UNIX
Configuring the DAC Client and Server on Solaris and AIX
Starting the Informatica Repository Server on UNIX
Starting and Stopping the Informatica Server on UNIX
Updating Siebel OLTP Schema Definitions
Backing Up the Siebel Repository
Importing the SIF File into the Siebel OLTP
Verifying the SIF Patch Application
Creating Siebel Stored Procedures for DB2-UDB
Navigating the DAC User Interface
DAC Toolbars and Right-Click Menu Commands
Tailoring Execution Plans for Your Needs
Pruning Execution Plans in the DAC
Pruning Subject Areas in the DAC
Pruning Table Groups in the DAC
Pruning Tasks and Dependencies in the DAC
Disabling DAC Repository Entities
Using the DAC Preview Functionality to View Tasks and Dependencies
Using the DAC Query Functionality
DAC Query Commands and Operators
Handling ETL Failures with the DAC
About the DAC Execution Plans Tab
About the DAC Subject Areas Tab
About the DAC Table Groups Tab
About the DAC Task Definitions Tab
Using SQL Files as an Execution Type in the DAC
About the DAC System Properties Tab
About the DAC Informatica Servers Tab
About the DAC Database Connections Tab
About the DAC Email Recipients Tab
About the DAC Execution Plans (Read Only) Tab
Customizing the Siebel Data Warehouse
Siebel Data Warehouse Customization Scenarios
Siebel Data Warehouse ETL Process Concepts
About Siebel Data Warehouse Extension Tables
About the Siebel Data Warehouse DATASRC_NUM_ID Column
Working with the Custom Folder of the Siebel Data Warehouse
Creating Custom Informatica Workflows
Important Notes About Siebel Data Warehouse Customizations
Standard Templates for Siebel Data Warehouse Customizations
Fact Templates for Siebel Data Warehouse Customizations
Customization Steps for Siebel Data
Adding a Column From a Main Source Table in the Siebel OLTP
Adding a Column From a Related Source Table in the Siebel OLTP
Modifying an Existing Column in the Siebel Data Warehouse
Adding a New Dimension in the Siebel Data Warehouse and Using It with an Existing Fact
Adding a New Fact Table in the Siebel Data Warehouse
Adding a New Dimension Table for a New Fact Table in the Siebel Data Warehouse
Siebel Data Warehouse Customization Steps for Non-Siebel Data
Adding New Data as a Whole Row into the Standard Dimension Table in Siebel Data Warehouse
Adding New Data as a Whole Row into the Standard Fact Table in Siebel Data Warehouse
Adding a Column in a Standard Dimension Table in Siebel Data Warehouse
Adding a Column for a Standard Fact Table in Siebel Data Warehouse
Building a Custom Dimension Table from External Sources in Siebel Data Warehouse
Linking the Custom Dimension to a Standard Fact Table in Siebel Data Warehouse
Building Custom Fact Tables from External Sources in Siebel Data Warehouse
Using Siebel Data Warehouse Exception Reports
Understanding Siebel Data Warehouse Exceptions
Executing Siebel Data Warehouse Exception Reports
Upgrading Siebel Data Warehouse
Upgrade Requirements for Siebel Data Warehouse 7.7
Siebel Data Warehouse 7.7 Product Changes and Customization Impacts
Siebel Data Warehouse Upgrade Paths
Approaches to Upgrading the Siebel Data Warehouse
Process of Siebel Data Warehouse Upgrade
Data Migration Workflows for Siebel Data Warehouse Data Upgrades
Running the Data Migration Workflow for Preconfigured Content in Siebel Data Warehouse
Siebel Data Warehouse Upgrade Customizations
Data Migration Workflows for Siebel Industry Applications Data Warehouse Upgrades
Running the Data Migration Workflow for Preconfigured Siebel Industry Applications Content
Troubleshooting the Siebel Data Warehouse
Siebel Data Warehouse Installation and Initial Configuration Issues
Informatica and Loading Issues
Unicode Issues with Informatica and the Siebel Data Warehouse
UNIX Installation Issues with the Siebel Data Warehouse
Siebel Data Warehouse Application Console (DAC) Issues
Siebel Data Warehouse for Life Sciences Data Considerations
Importing Syndicated Data into Siebel Data Warehouse
Siebel Analytics Data Loading Matrix for Syndicated Data
Data Source Values for Syndicated Data Attributes
Data Loading Issues with Siebel Data Warehouse
Supported Incremental Updates in the Siebel Data Warehouse LS Dimension Tables
| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Data Warehouse Installation and Administration Guide, Version 7.7, Rev. A Published: 11 March 2004 |