Siebel Data Warehouse Installation And Administration Guide - Oracle
Siebel Data Warehouse Installationand Administration GuideVersion 7.7.1, Rev. EDecember 2004
Siebel Systems, Inc., 2207 Bridgepointe Parkway, San Mateo, CA 94404Copyright 2004 Siebel Systems, Inc.All rights reserved.Printed in the United States of AmericaNo part of this publication may be stored in a retrieval system, transmitted, or reproduced in any way,including but not limited to photocopy, photographic, magnetic, or other record, without the prioragreement and written permission of Siebel Systems, Inc.Siebel, the Siebel logo, TrickleSync, Universal Agent, and other Siebel names referenced herein aretrademarks of Siebel Systems, Inc., and may be registered in certain jurisdictions.Other product names, designations, logos, and symbols may be trademarks or registered trademarks oftheir respective owners.PRODUCT MODULES AND OPTIONS. This guide contains descriptions of modules that are optional andfor which you may not have purchased a license. Siebel’s Sample Database also includes data related tothese optional modules. As a result, your software implementation may differ from descriptions in thisguide. To find out more about the modules your organization has purchased, see your corporatepurchasing agent or your Siebel sales representative.U.S. GOVERNMENT RESTRICTED RIGHTS. Programs, Ancillary Programs and Documentation, deliveredsubject to the Department of Defense Federal Acquisition Regulation Supplement, are “commercialcomputer software” as set forth in DFARS 227.7202, Commercial Computer Software and CommercialComputer Software Documentation, and as such, any use, duplication and disclosure of the Programs,Ancillary Programs and Documentation shall be subject to the restrictions contained in the applicableSiebel license agreement. All other use, duplication and disclosure of the Programs, Ancillary Programsand Documentation by the U.S. Government shall be subject to the applicable Siebel license agreementand the restrictions contained in subsection (c) of FAR 52.227-19, Commercial Computer Software Restricted Rights (June 1987), or FAR 52.227-14, Rights in Data—General, including Alternate III (June1987), as applicable. Contractor/licensor is Siebel Systems, Inc., 2207 Bridgepointe Parkway, SanMateo, CA 94404.Proprietary InformationSiebel Systems, Inc. considers information included in thisdocumentation and in Siebel eBusiness Applications Online Help tobe Confidential Information. Your access to and use of thisConfidential Information are subject to the terms and conditions of:(1) the applicable Siebel Systems software license agreement, whichhas been executed and with which you agree to comply; and (2) theproprietary and restricted rights notices included in thisdocumentation.
ContentsSiebel Data Warehouse Installation and Administration Guide 1Chapter 1: What’s New in This ReleaseChapter 2: Overview of Siebel Data WarehouseSiebel Data Warehouse Overview19Siebel Data Warehouse Architecture20Siebel Data Warehouse Architecture ComponentsAbout the Data Warehouse Application Console2122About DAC Repository Objects 25About the DAC Process Life Cycle 27Chapter 3: Preinstallation Considerations for Siebel DataWarehouseSiebel Data Warehouse Deployment Configuration30Operating System, Driver, and Connectivity Requirements for Siebel Data Warehouse31General Guidelines for Setting Up Siebel Data Warehouse32IBM DB2 UDB-Specific Database Guidelines for Siebel Data Warehouse34IBM DB2 UDB zOS and OS/390-Specific Database Guidelines for Siebel DataWarehouse 35Oracle-Specific Database Guidelines for Siebel Data Warehouse36Additional Suggestions for Optimizing Oracle Performance in Siebel Data Warehouse40SQL Server-Specific Database Guidelines for Siebel Data WarehouseTeradata-Specific Database Guidelines for Siebel Data Warehouse4143Deploying Siebel Data Warehouse in Latin-1 General, Unicode and Non-EnglishEnvironments 44Code Page Overview 44Source and Data Warehouse Code Pages for Latin-1 General (ASCII) to Latin-1 General(ASCII) 45Source and Data Warehouse Code Pages for Unicode to Unicode 46Source and Data Warehouse Code Pages for Code Page to Unicode 48Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 3
ContentsSource and Data Warehouse Code Pages for Code Page to Code Page50Chapter 4: Installing and Configuring Siebel DataWarehouse on WindowsInstalling Siebel Data Warehouse-Related Software on Windows58Installing Siebel Analytics (Data Warehouse Option) on Windows 58Installing the Informatica Server and Repository Server on Windows 59Installing Informatica Client Software on Windows 61Setting Informatica Data Code Pages Validation 61Installing the Java SDK 62Configuring the DAC Client62Configuring the DAC Config.bat File 62Installing JDBC Drivers for DAC Database ConnectivityCreating the DAC Metadata Repository6263Configuring the DAC Metadata Repository65Setting Up DAC System Properties 65Creating ODBC Database Connections 68Registering Informatica Servers on the DAC Client 69Configuring Email Recipients on the DAC Client 70Activating Join Indices for Teradata Databases 71Configuring the Siebel Data Warehouse Database71Creating the SSE Role 71Creating Data Warehouse Tables 72Creating and Dropping Data Warehouse Tables on a Teradata DatabaseConfiguring the Informatica Server73Setting Environment Variables on WindowsCopying Database Parameter Files737577Copying Teradata Loader Control Files77Creating, Restoring, and Configuring the Informatica Repository78Starting the Informatica Repository Server 78Creating or Restoring the Informatica Repository 79Dropping the Informatica Repository (Optional) 81Registering the Informatica Repository Server in Repository Server Administration Console81Pointing to the Informatica Repository 82Configuring the Informatica Repository in the DAC 83Configuring the Informatica Repository in Workflow Manager 864 Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
ContentsSetting the Code Page File Property for Unicode Environments on Teradata Databases86Setting Up the HOSTS File for Teradata Installations on WindowsVerifying the Informatica Repository ConfigurationStarting the Informatica ServerSetting DAC ETL PreferencesConfiguring the DAC Server8787888890Configuring the Connection between the DAC Server and DAC RepositoryConfiguring Email in the DAC Server (Optional) 91Updating Siebel Transactional Database Schema DefinitionsBacking Up the Siebel Repository 92Importing the SIF File into the Siebel Transactional DatabaseVerifying the SIF Patch Application 93Creating Delete Triggers 94Creating Siebel Stored Procedures for DB2-UDB91929295Chapter 5: Installing and Configuring Siebel DataWarehouse on UNIXOverview of Deploying Siebel Data Warehouse on UNIX97Siebel Data Warehouse Installation and Configuration Process on UNIX98Installing and Configuring the Informatica Server and Repository Server on UNIXInstalling the Teradata Patch on UNIX 105Creating Database Connections for Teradata Installations 106Setting Environment Variables for the Informatica Server on UNIX 106Setting Up the HOSTS File for Teradata Installations on UNIX 107Starting the Informatica Repository Server on UNIX 108Configuring the DAC Server on UNIX101109Starting the Informatica Server on UNIX 111Stopping the Informatica Server on UNIX 111Starting the DAC Server on UNIX 112Stopping the DAC Server on UNIX 112Chapter 6: Upgrading the DAC Platform to Release 7.7.1Upgrading the DAC Platform to Release 7.7.1113Chapter 7: Upgrading Siebel Data WarehouseUpgrade Requirements for Siebel Data Warehouse 7.7115Siebel Data Warehouse 7.7 Product Changes and Customization Impacts116Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 5
ContentsSiebel Data Warehouse Upgrade Paths 116Approaches to Upgrading the Siebel Data Warehouse 117Process of Siebel Data Warehouse Upgrade 118Data Migration Workflows for Siebel Data Warehouse Data Upgrades 119Running Data Migration Workflow for Preconfigured Content in Siebel Data Warehouse121Siebel Data Warehouse Upgrade Customizations 121Data Migration Workflows for Siebel Industry Applications Data Warehouse Upgrades125Running the Data Migration Workflow for Preconfigured Siebel Industry ApplicationsContent 126Upgrading the Siebel Data Warehouse from Version 7.7. to 7.7.1Upgrading the Siebel Data Warehouse from Version 7.0.4 to 7.7.1127128Chapter 8: DAC Quick StartDAC Licensing Options in Siebel Data Warehouse 7.7.1Navigating the DAC User Interface134Main Toolbar of the DAC 134DAC Toolbars and Right-Click Menu CommandsDAC Tools Menu 138DAC Server Monitor Icon 141DAC Navigation Tree 142DAC Editable Lists 142Logging In to the DAC131135143Tailoring Execution Plans for Your Needs143Pruning Execution Plans in the DAC 145Pruning Subject Areas in the DAC 145Pruning Table Groups in the DAC 145Pruning Tasks and Dependencies in the DAC 147Disabling DAC Repository Entities 147Using the DAC Preview Functionality to View Tasks and DependenciesDistributing DAC Metadata148150Using the DAC Query Functionality151DAC Query Commands and Operators 151DAC Query Examples 152Common DAC Query Procedures 152Executing an ETL with the DAC153Running the DAC Server Automatically153Overview of Command Line Access to the DAC Server6 154Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
ContentsSetting Up Command Line Access to the DAC Server 156Using the Command Line to Access the DAC Server 157Replacing an Informatica Workflow with a Custom SQL FileHandling ETL Failures with the DACUsing the Change Capture Filter159159161Chapter 9: DAC Functional ReferenceAbout the DAC Design View163About the DAC Execution Plans Tab 163About the DAC Subject Areas Tab 166About the DAC Table Groups Tab 167About the DAC Tables Tab 169About the DAC Indices Tab 171About the DAC Task Definitions Tab 174Using SQL Files as an Execution Type in the DACAbout the DAC Setup ethethethetheDACDACDACDACDAC180System Properties Tab 180Informatica Servers Tab 181Database Connections Tab 181Email Recipients Tab 183About the DAC Execute ViewAboutAboutAboutAboutAbout178183Execution Plans (Read Only) TabCurrent Run Tab 183Run History Tab 186Scheduler Tab 186Validation Tab 188183Chapter 10: Customizing the Siebel Data WarehouseSiebel Data Warehouse Customization ScenariosSiebel Data Warehouse ETL Process Concepts189191About Siebel Data Warehouse Extension Tables 191About the Siebel Data Warehouse DATASRC NUM ID Column 193Working with the Custom Folder of the Siebel Data Warehouse 193Creating Custom Informatica Workflows 193Important Notes About Siebel Data Warehouse Customizations 195Standard Templates for Siebel Data Warehouse CustomizationsFact Templates for Siebel Data Warehouse CustomizationsCustomization Steps for Siebel Data197198198Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 7
ContentsAdding a Column from a Main Source Table in the Siebel Transactional Database 199Adding a Column from a Related Source Table in the Siebel Transactional Database 199Including a Source Table for Change Capture Process 200Modifying an Existing Column in the Siebel Data Warehouse 201Adding a New Dimension in the Siebel Data Warehouse 201Adding a New Fact Table in the Siebel Data Warehouse 202Adding a New Dimension Table for a New Fact Table in the Siebel Data Warehouse 203Siebel Data Warehouse Customization Steps for Non-Siebel Data203Adding New Data as a Whole Row into the Standard Dimension Table in Siebel DataWarehouse 204Adding New Data as a Whole Row into the Standard Fact Table in Siebel Data Warehouse206Adding a Column in a Standard Dimension Table in Siebel Data Warehouse 211Adding a Column for a Standard Fact Table in Siebel Data Warehouse 212Building a Custom Dimension Table from External Sources in Siebel Data Warehouse 213Linking the Custom Dimension to a Standard Fact Table in Siebel Data Warehouse 213Building Custom Fact Tables from External Sources in Siebel Data Warehouse 214Chapter 11: Using Siebel Data Warehouse ExceptionReportsUnderstanding Siebel Data Warehouse ExceptionsExecuting Siebel Data Warehouse Exception Reports215218Chapter 12: Troubleshooting the Siebel Data WarehouseSiebel Data Warehouse Installation and Initial Configuration Issues 223Informatica and Loading Issues 224Unicode Issues with Informatica and the Siebel Data Warehouse 231UNIX Installation Issues with the Siebel Data Warehouse 233Siebel Data Warehouse Application Console (DAC) Issues 236Siebel Data Warehouse Upgrade Issues 240Appendix A: 7.7 Analytics BridgesOverview of the 7.7 Analytics BridgesInstalling the 7.7 Analytics Bridges243244Setting Up the Siebel Transactional Database for the 7.7 Analytics Bridge7.7 Analytics Bridge Files2452477.7 Analytics Bridge Platform Support248Appendix B: Installing the Usage Accelerator8 Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
ContentsInstalling the Usage Accelerator2497.7 Usage Accelerator-Analytics Bridge Files255Appendix C: Siebel Data Warehouse for Life Sciences DataConsiderationsImporting Syndicated Data into Siebel Data WarehouseSiebel Analytics Data Loading Matrix for Syndicated DataData Source Values for Syndicated Data Attributes 263Data Loading Issues with Siebel Data Warehouse257258264Incremental Updates in the Siebel Data Warehouse LS Dimension Tables266IndexSiebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 9
Contents10 Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
1What’s New in This ReleaseWhat’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1, Rev. ETable 1 lists changes described in this version of the documentation to support Release 7.7.1.5 of thesoftware.NOTE: This version of the guide applies to the 7.7.1.5 release of Siebel Analytics and Siebel DataWarehouse. Siebel Analytics 7.7.1.5 is compatible with Siebel 7.7 operational applications.Table 1. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. ETopicDescription“To create database connections forTeradata installations” on page 69Added step in this procedure for support of Unicodeenvironments on Teradata databases.“To configure the Informatica repository inthe Workflow Manager for Teradatainstallations” on page 85Added step in this procedure for support of Unicodeenvironments on Teradata databases.“Setting the Code Page File Property forUnicode Environments on TeradataDatabases” on page 86Added new procedure for support of Unicodeenvironments on Teradata databases.“Setting Up the HOSTS File for TeradataInstallations on Windows” on page 87Added new procedure for setting up the HOSTS file forTeradata installations on Windows.“Setting Up the HOSTS File for TeradataInstallations on UNIX” on page 107Added new procedure for setting up the HOSTS file forTeradata installations on UNIX.“Advanced Custom Index Management” onpage 174Added information about how to handle advancedindex management outside of the DAC.“7.7 Analytics Bridges” on page 243Added information about the Siebel IndustryApplications 7.5.3 to 7.7 Bridge application.“Replacing an Informatica Workflow with aCustom SQL File” on page 159Added new procedure for replacing an Informaticaworkflow with a custom SQL file.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 11
What’s New in This Release What’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1, Rev. DTable 2 lists changes described in this version of the documentation to support Release 7.7.1.4 of thesoftware.NOTE: This version of the guide applies to the 7.7.1.4 release of Siebel Analytics and Siebel DataWarehouse. Siebel Analytics 7.7.1.4 is compatible with Siebel 7.7 operational applications.Table 2. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. DTopicDescriptionTeradata database supportAdded information about installing the Teradata patchon Windows.“To install the Teradata patch on Windows”on page 60.Teradata database support“Installing the Teradata Patch on UNIX” onpage 105.Teradata database support“Creating ODBC Database Connections” onpage 68.Teradata database support“Creating Database Connections forTeradata Installations” on page 106.Teradata database support“Activating Join Indices for TeradataDatabases” on page 71.Teradata database support“Creating and Dropping Data WarehouseTables on a Teradata Database” on page 73.Teradata database support“Copying Teradata Loader Control Files” onpage 77.12 NOTE: Teradata databases are supported in SiebelData Warehouse version 7.7.1.4 and higher.Added information about installing the Teradata patchon UNIX.NOTE: Teradata databases are supported in SiebelData Warehouse version 7.7.1.4 and higher.For Windows installations, added information aboutcreating Teradata ODBC database connections.For UNIX installations, added information aboutcreating Teradata ODBC database connections.Added section with instructions for activating joinindices.For Teradata databases, the preconfigured tasks forcreating and dropping join indices are inactive bydefault. These tasks need to be activated in order forETLs to run.Added procedures for creating and dropping datawarehouse tables on a Teradata database.Added section with instructions for copying loadercontrol files to the Informatica Server.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
What’s New in This Release Table 2. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. DTopicDescriptionTeradata database supportAdded instructions for creating or restoring theInformatica repository for Teradata installations.“To create or restore the Informaticarepository for Teradata installations” onpage 80.Teradata database support“To configure the Informatica repository inthe Workflow Manager for Teradatainstallations” on page 85.Teradata database support“About the DAC Indices Tab” on page 171.New preinstallation chapter“Preinstallation Considerations for SiebelData Warehouse” on page 29.Revised Windows installation andconfiguration chapter“Installing and Configuring Siebel DataWarehouse on Windows” on page 55.New UNIX installation and configurationchapter“Installing and Configuring Siebel DataWarehouse on UNIX” on page 97.Set up DAC server to run automatically“Running the DAC Server Automatically” onpage 153.Internal tasksAdded instructions for setting relational connectionsand external loader connections for Teradatainstallations.Added information about registering indices in theDAC.Moved information about deployment, connectivity,and database-specific requirements into this chapter.Also, added new general guidelines for setting upSiebel Data Warehouse, and new information aboutdeploying Siebel Data Warehouse in a non-Englishenvironment.Extensive reorganization of information. Moved UNIXinstallation and configuration information into aseparate chapter.Moved UNIX installation and configuration informationinto this chapter. Extensive reorganization ofinformation. Revised DAC server configurationinformation.Added procedure for setting up the DAC server to runautomatically upon rebooting the machine.NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.4 or higher.Added information about managing internal tasks.“About the DAC Database Connections Tab”on page 181.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 13
What’s New in This Release What’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1, Rev. CTable 3 lists changes described in this version of the documentation to support Release 7.7.1 of thesoftware.Table 3. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. CTopicDescriptionConfiguring the DAC server on HP-UXAdded information about configuring the DAC serveron HP-UX.See “Siebel Data Warehouse Installationand Configuration Process on UNIX” onpage 98Oracle 9i configuration parametersSee “Oracle-Specific Database Guidelinesfor Siebel Data Warehouse” on page 36.Importing the SIF fileSee “Updating Siebel TransactionalDatabase Schema Definitions” on page 92.Updated information about Oracle 9i configurationparameters.Corrected the procedure for importing the SIF file intothe Siebel transactional database.Installing and setting up the 7.7 AnalyticsBridge applicationsCorrected the procedures for installing and setting upthe 7.7 Analytics Bridge applications.See “7.7 Analytics Bridges” on page 243.NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.1 or higher.Installing the Usage Accelerator for the7.7 Analytics Bridge applicationsUpdated the installation information for the UsageAccelerator application that is a part of the 7.7Analytics Bridge applications.See “Installing the Usage Accelerator” onpage 249.New Informatica troubleshooting topicSee “Informatica and Loading Issues” onpage 224.New upgrade troubleshooting topicSee “Siebel Data Warehouse UpgradeIssues” on page 240.14 NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.1 or higher.Addressed how to handle tasks that fail during an ETLprocess.Addressed how to handle duplicate rows beinginserted into a mini dimension table during an upgradeprocess.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
What’s New in This Release What’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1, Rev. BTable 4 lists changes described in this version of the documentation to support Release 7.7.1 of thesoftware.Table 4. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. BTopicDescriptionUpgrading the DAC platformAdded information about upgrading from Analytics 7.7to Analytics 7.7.1.See “Upgrading the DAC Platform toRelease 7.7.1” on page 113.Accessing the DAC server through acommand lineAdded a new chapter that describes how to access theDAC server through a command line.See “Overview of Command Line Access tothe DAC Server” on page 154.NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.1 or higher.Installing and using the 7.7 AnalyticsBridge applicationsAdded a new appendix that describes how to installand use the 7.7 Analytics Bridge applications.See “7.7 Analytics Bridges” on page 243.NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.1 or higher.Installing the Usage AcceleratorAdded a new appendix that describes how to install theUsage Accelerator application.See “Installing the Usage Accelerator” onpage 249.NOTE: This feature is only available if you installSiebel Data Warehouse version 7.7.1.1 or higher.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 15
What’s New in This Release What’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1, Rev. ATable 5 lists changes described in this version of the documentation to support Release 7.7.1 of thesoftware.Table 5. What’s New in Siebel Data Warehouse Installation and Administration Guide, Version 7.7.1,Rev. ATopicDescriptionDAC licensing optionsAdded information about the two Data WarehouseApplication Console (DAC) licensing options availablein Siebel Data Warehouse 7.7.1.See “DAC Licensing Options in Siebel DataWarehouse 7.7.1” on page 131.Code page parameter settingsSee “Deploying Siebel Data Warehouse inLatin-1 General, Unicode and Non-EnglishEnvironments” on page 44.About SIF filesRevised the parameter description for InformaticaServer Unicode settings.Revised the .sif file description.See “Transactional Database Environment(Analytics-Specific) Upgrade” on page 118.Configuring database parametersSee “Copying Database Parameter Files” onpage 77.Upgrading the DAC platformSee “Upgrading the DAC Platform toRelease 7.7.1” on page 113.DAC change capture commandsUpdated information about configuring databaseparameter files.Added information about upgrading from Analytics 7.7to Analytics 7.7.1.Added new change capture commands.See “DAC Toolbars and Right-Click MenuCommands” on page 135.Task Definitions tabSee “About the DAC Task Definitions Tab”on page 174.16 For the Task Definitions tab, revised the Optionalcolumn description and added the Conditional Tablessubtab description.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
What’s New in This Release What’s New in Siebel Data Warehouse Installation and AdministrationGuide, Version 7.7.1Table 6 lists changes described in this version of the documentation to support Release 7.7.1 of thesoftware.Table 6. New Product Features in Siebel Data Warehouse Installation and Administration Guide,Version 7.7.1TopicDescriptionNew customization procedureThis procedure provides instructions for including asource table for the change capture process.See “Including a Source Table for ChangeCapture Process” on page 200.New DAC troubleshooting topicSee “Siebel Data Warehouse ApplicationConsole (DAC) Issues” on page 236.New DAC troubleshooting topicSee “Siebel Data Warehouse ApplicationConsole (DAC) Issues” on page 236.Enhanced explanation of DAC server logicAdded information about the DAC client not runningon machines where Analytics Pop Chart is installed.Added information about exporting the DACrepository against a DB2 database.Added step 9 to the DAC server logic list of actions.See “Tailoring Execution Plans for YourNeeds” on page 143.Upgrade to Version 7.7.1See “Upgrading the Siebel Data Warehousefrom Version 7.7. to 7.7.1” on page 127.Added instructions for upgrading to Siebel DataWarehouse 7.7.1.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 17
What’s New in This Release 18 Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
2Overview of Siebel DataWarehouseThis chapter provides an overview of the Siebel Data Warehouse. It includes the following sections: “Siebel Data Warehouse Overview” on page 19 “Siebel Data Warehouse Architecture” on page 20 “About the Data Warehouse Application Console” on page 22Siebel Data Warehouse OverviewThe Siebel Data Warehouse is a unified data repository for all customer-centric data. The purpose ofthe Siebel Data Warehouse is to support the analytical requirements of Siebel eBusiness Applications.NOTE: The Siebel Data Warehouse is also referred to as the Siebel Relationship ManagementWarehouse (RMW).The Siebel Data Warehouse includes the following: A data integration engine that combines data from the Siebel transactional database and otherdata sources to build a data warehouse. An open architecture to allow organizations to use third-party analytical tools in conjunction withthe Siebel Data Warehouse using the Siebel Analytics Server. Optional prebuilt data extractors to incorporate data from external applications into the SiebelData Warehouse (licensed separately). A set of ETL (extract-transform-load) processes that takes data from the Siebel eBusinessapplication transactional data (OLTP) and creates the Siebel Data Warehouse tables. The Data Warehouse Application Console (DAC), a centralized console for the set up,configuration, administration, loading, and monitoring of the Siebel Data Warehouse.Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E 19
Overview of Siebel Data Warehouse Siebel Data Warehouse ArchitectureFigure 1 provides an overview of the Siebel Data Warehouse.Figure 1. Data Warehouse OverviewSiebel Data Warehouse ArchitectureHigh-level analytical queries, like those commonly used in Siebel Analytics, scan and analyze largevolumes of data using complex formulas. This process can take a long time when querying atransactional database, which impacts overall system performance.For this reason, the Siebel Data Warehouse was constructed using dimensional modeling techniquesto allow for fast access to information required for decision making. The Siebel Data Warehousederives its data from Siebel operational applications, and uses Informatica’s data integrationtechnology to extract, transform, and load data from the Siebel transactional database into theSiebel Data Warehouse.20 Siebel Data Warehouse Installation and Administration Guide Version 7.7.1,Rev. E
Overview of Siebel Data Warehouse Siebel Data Warehouse ArchitectureFigure 2 illustrates the Siebel Data Warehouse architecture.Figure 2. Siebel Data Warehouse ArchitectureSiebel Data Warehouse Architecture ComponentsThe Siebel Data Warehouse architecture comprises the following components: DAC client. A command and control interface for the data warehouse to allow for set up,configuration, administration, and monitoring of data warehouse processes. DAC server. Executes the instructions from the DAC client. The DAC server manages datawarehouse processes, including scheduling, loading of the ETL, and configuring the subject areasto be loaded. It dynamically adjusts its actions based on information in the DAC repository.Depending on your business needs, you might incrementally refresh the Siebel Data Warehouseonce a day, once a week, once a month, or on another similar schedule. DAC repository. Stores the metadata (semantics of the Siebel Data Warehouse) that representsthe data warehouse processes. Informatica Server. When the server is loading or refreshing the Siebel Data Warehouse, it isrecommended that the server be dedicated to that activity. However, when the ETL server is notloading or refreshing the Siebel Data Warehouse, you can use it for other purposes. Informatica Repository Server. Manages the Informatica repository. Informatica Repositor
Creating, Restoring, and Configuring the Informatica Repository 78 Starting the Informatica Repository Server 78 Creating or Restoring the Informatica Repository 79 Dropping the Informatica Repository (Optional) 81 Registering the Informatica Repository Server in Repository Server Administration Console 81 Pointing to the Informatica Repository 82
How Siebel CRM Desktop Handles a Microsoft Outlook Task 56 How Siebel CRM Desktop Handles a Microsoft Outlook Email Message 56 How Siebel CRM Desktop Handles Items If the User Removes the Siebel CRM Desktop Add-In 57 How a User Can Link a Siebel CRM Record to a Microsoft Outlook Record 58 Chapter 5: How Siebel CRM Desktop Synchronizes Data
Thomas M. Siebel . Aspenia. 79. 2018. Thomas M. Siebel is Chairman and CEO of C3 IoT. He previously founded Siebel Systems and the Thomas and Stacey Siebel Foundation, which cre ated the Siebel Energy Institute in 2015. 097-108 Siebel-ing 79 SCENARIO.indd 98 11/06/18 15.01
Downloading and Installing the Siebel Mobile Application Container (Siebel App). 4-20 Using the Siebel Mobile Archive MAA File (Administrator Task) . 4-21 Setting Up the Host Server for Siebel Mobile . 4-21 Configuring the Siebel Mobile Application Container (Siebel App) on an iOS Device . 4-22 Clearing the Application Cache for .
Siebel CRM Pricing Prices in USA-Dollar (USD) License Price Software Update License & Support Licensing Metric Minimum Siebel CRM General Siebel Advanced Market Development Funds 500 110.00 Application User Siebel Anywhere 200 44.00 Application User Siebel Server Sync - Microsoft Exchange Server 120 26.00 Application User Siebel Content Publishing 120
12 Siebel eFinance for Teller Connector to IBM WebSphere Business Component Composer Guide Version 7.0, Rev. H Siebel Teller Architecture The Siebel Connector for Teller extends the functionality of the Siebel Connector for IFX XML to provide Teller-specific data exchange between Siebel and other systems.
Siebel Performance Tuning Guide Version 8.0 3 Contents Siebel Performance Tuning Guide 1 Chapter 1: What's New in This Release Chapter 2: Siebel Architecture and Infrastructure About Performance and Scalability 13 About Siebel Architecture and Infrastructure 14 About Siebel User Request Flow 18 Performance Tuning Terminology 19
- PowerCenter 7 (Informatica etl august 2005) Siebel : - Siebel Datawarehouse developer (june 2005) - Siebel EIM Workshop (23rd june 2003) - Siebel 7 EAI (October 2002) - Siebel 7 Core Consultant (April 2002) - Siebel 2000 EAI (march 20
Siebel Installation Guide for UNIX Version 8.1/8.2, Rev. A 3 Contents Siebel Installation Guide for UNIX 1 Chapter 1: What's New in This Release . Configuring the Siebel Gateway Name Server fo r Automatic Start on Linux or Oracle Solaris 109 Configuring the Siebel Server for Automatic Start 110
