Siebel Data Warehouse Installation and Administration Guide
What's New in This Release
Back to top
Overview of Siebel Data Warehouse
Siebel Data Warehouse Overview
Siebel Data Warehouse Architecture
Siebel Data Warehouse Architecture Components
About the Data Warehouse Application Console
About DAC Repository Objects
About the DAC Process Life Cycle
Back to top
Preinstallation Considerations for Siebel Data Warehouse
Siebel Data Warehouse Deployment Configuration
Operating System, Driver, and Connectivity Requirements for Siebel Data Warehouse
General Guidelines for Setting Up Siebel Data Warehouse
IBM DB2 UDB-Specific Database Guidelines for Siebel Data Warehouse
IBM DB2 UDB zOS and OS/390-Specific Database Guidelines for Siebel Data Warehouse
Oracle-Specific Database Guidelines for Siebel Data Warehouse
Additional Suggestions for Optimizing Oracle Performance in Siebel Data Warehouse
SQL Server-Specific Database Guidelines for Siebel Data Warehouse
Teradata-Specific Database Guidelines for Siebel Data Warehouse
Deploying Siebel Data Warehouse in Latin-1 General, Unicode and Non-English Environments
Code Page Overview
Source and Data Warehouse Code Pages for Latin-1 General (ASCII) to Latin-1 General (ASCII)
Source and Data Warehouse Code Pages for Unicode to Unicode
Source and Data Warehouse Code Pages for Code Page to Unicode
Source and Data Warehouse Code Pages for Code Page to Code Page
Back to top
Installing and Configuring Siebel Data Warehouse on Windows
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
Setting Informatica Data Code Pages Validation
Installing the Java SDK
Configuring the DAC Client
Configuring the DAC Config.bat File
Installing JDBC Drivers for DAC Database Connectivity
Creating the DAC Metadata Repository
Configuring the DAC Metadata Repository
Setting Up DAC System Properties
Creating ODBC Database Connections
Registering Informatica Servers on the DAC Client
Configuring Email Recipients on the DAC Client
Activating Join Indices for Teradata Databases
Configuring the Siebel Data Warehouse Database
Creating the SSE Role
Creating Data Warehouse Tables
Creating and Dropping Data Warehouse Tables on a Teradata Database
Configuring the Informatica Server
Setting Environment Variables on Windows
Copying Database Parameter Files
Copying Teradata Loader Control Files
Creating, Restoring, and Configuring the Informatica Repository
Starting the Informatica Repository Server
Creating or Restoring the Informatica Repository
Dropping the Informatica Repository (Optional)
Registering the Informatica Repository Server in Repository Server Administration Console
Pointing to the Informatica Repository
Configuring the Informatica Repository in the DAC
Configuring the Informatica Repository in Workflow Manager
Setting the Code Page File Property for Unicode Environments on Teradata Databases
Setting Up the HOSTS File for Teradata Installations on Windows
Verifying the Informatica Repository Configuration
Starting the Informatica Server
Setting DAC ETL Preferences
Configuring the DAC Server
Configuring the Connection between the DAC Server and DAC Repository
Configuring Email in the DAC Server (Optional)
Updating Siebel Transactional Database Schema Definitions
Backing Up the Siebel Repository
Importing the SIF File into the Siebel Transactional Database
Verifying the SIF Patch Application
Creating Delete Triggers
Creating Siebel Stored Procedures for DB2-UDB
Back to top
Installing and Configuring Siebel Data Warehouse on UNIX
Overview of Deploying Siebel Data Warehouse on UNIX
Siebel Data Warehouse Installation and Configuration Process on UNIX
Installing and Configuring the Informatica Server and Repository Server on UNIX
Installing the Teradata Patch on UNIX
Creating Database Connections for Teradata Installations
Setting Environment Variables for the Informatica Server on UNIX
Setting Up the HOSTS File for Teradata Installations on UNIX
Starting the Informatica Repository Server on UNIX
Configuring the DAC Server on UNIX
Starting the Informatica Server on UNIX
Stopping the Informatica Server on UNIX
Starting the DAC Server on UNIX
Stopping the DAC Server on UNIX
Back to top
Upgrading the DAC Platform to Release 7.7.1
Upgrading the DAC Platform to Release 7.7.1
Back to top
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 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
Upgrading the Siebel Data Warehouse from Version 7.7. to 7.7.1
Upgrading the Siebel Data Warehouse from Version 7.0.4 to 7.7.1
Back to top
DAC Quick Start
DAC Licensing Options in Siebel Data Warehouse 7.7.1
Navigating the DAC User Interface
Main Toolbar of the DAC
DAC Toolbars and Right-Click Menu Commands
DAC Tools Menu
DAC Server Monitor Icon
DAC Navigation Tree
DAC Editable Lists
Logging In to the DAC
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
Distributing DAC Metadata
Using the DAC Query Functionality
DAC Query Commands and Operators
DAC Query Examples
Common DAC Query Procedures
Executing an ETL with the DAC
Running the DAC Server Automatically
Overview of Command Line Access to the DAC Server
Setting Up Command Line Access to the DAC Server
Using the Command Line to Access the DAC Server
Replacing an Informatica Workflow with a Custom SQL File
Handling ETL Failures with the DAC
Using the Change Capture Filter
Back to top
DAC Functional Reference
About the DAC Design View
About the DAC Execution Plans Tab
About the DAC Subject Areas Tab
About the DAC Table Groups Tab
About the DAC Tables Tab
About the DAC Indices Tab
About the DAC Task Definitions Tab
Using SQL Files as an Execution Type in the DAC
About the DAC Setup View
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 Execute View
About the DAC Execution Plans (Read Only) Tab
About the DAC Current Run Tab
About the DAC Run History Tab
About the DAC Scheduler Tab
About the DAC Validation Tab
Back to top
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 Transactional Database
Adding a Column from a Related Source Table in the Siebel Transactional Database
Including a Source Table for Change Capture Process
Modifying an Existing Column in the Siebel Data Warehouse
Adding a New Dimension in the Siebel Data Warehouse
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
Back to top
Using Siebel Data Warehouse Exception Reports
Understanding Siebel Data Warehouse Exceptions
Executing Siebel Data Warehouse Exception Reports
Back to top
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 Upgrade Issues
Back to top
7.7 Analytics Bridges
Overview of the 7.7 Analytics Bridges
Installing the 7.7 Analytics Bridges
Setting Up the Siebel Transactional Database for the 7.7 Analytics Bridge
7.7 Analytics Bridge Files
7.7 Analytics Bridge Platform Support
Back to top
Installing the Usage Accelerator
Installing the Usage Accelerator
7.7 Usage Accelerator-Analytics Bridge Files
Back to top
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
Incremental Updates in the Siebel Data Warehouse LS Dimension Tables
Back to top
|