Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Introduction >

Revision History

---

Siebel Data Warehouse Installation and Administration Guide

Version 7.5.3, Rev. A

Table 2.  Changes Made in Version 7.5.3, Rev. A

Topic	Revision
Capturing Row Deletion Changes	Added an appendix that explains how the Siebel Data Warehouse deletes rows.
Upgrading the Data Warehouse Schema Using upgrep_dw	Added this section for customers who want to upgrade the Siebel Data Warehouse 7.0.4 schema to the 7.5.3 schema using the upgrep_dw batch file.
The Siebel 6.3 to 7.5 Analytics Bridges and The Siebel 7.0.4 to 7.5 Analytics Bridges	Added a note to the installation process, explaining what a customer should do if they have already installed Siebel Analytics 7.5 and created the Informatica repository.
Optional Customization Procedures	Added a reference to review Technical Note 420 located on SupportWeb for information about customizing the Siebel Data Warehouse.
Linking Workflows	Added a section in the Linking Example, to show how a customer can use the command PMCMD startworkflow to execute a workflow.
IBM DB2 UDB-Specific Database Requirements	Added the Sortheap and Sheapthres variables, and recommended settings for IBM DB2 UDB databases.
Oracle-Specific Database Requirements	Added the Sort_area_retained_size and Sort_area_size variables, and recommended settings for Oracle databases.
Creating Database Connections	Added a note that an Oracle 8 ODBC driver should be used for an Oracle 9i Siebel Data Warehouse.
Informatica and Loading Issues	Added a section that details a non-fatal error when running the Siebel_DW_Rep jobs through the pmcmd. Added a section that details an error that may occur when executing SDE_ETLDataSource.

Version 7.5.3

Table 3.  Changes Made in Version 7.5.3

Topic	Revision
Introduction	Added a note to the Introduction stating that this guide assumes that you are using the 7.5.3 release. Added a note that the Siebel Data Warehouse is also referred to as the Siebel Relationship Management Warehouse.
Product Modules and Options	Added text regarding functionality and licensed modules.
Deploying Informatica and Siebel Data Warehouse in Non-English Environments	New for 7.5.3: Added this section to clarify settings required to deploy the Siebel Data Warehouse and Informatica 6.1 in languages other than English.
Installing the Siebel Data Warehouse	Revised for 7.5.3: Revised information according to changes made in the installation program. New for 7.5.3: Added a note to the Installer procedure regarding a new choice to install the Analytics Bridges, with cross-reference to Appendixes A and B, where the Analytics Bridge installations are described.
Recommended Configuration	Revised for 7.5.3: Updated the hardware configuration graphic to show the new three-tier server structure of Siebel Data Warehouse due to Informatica 6.1.
General Process Flow for Installing Siebel Data Warehouse	Revised for 7.5.3: Added a flow diagram of the installation process.
Installing Informatica Software	Revised for 7.5.3: Changed procedures for the installation of Informatica 6.1 version used by Siebel Analytics 7.5.3.
Upgrading the Informatica Platform	New for 7.5.3: Added this section for customers who have a version of Siebel Data Warehouse that uses Informatica 5.x.
The Siebel 6.3 to 7.5 Analytics Bridges	Revised for 7.5.3: Revised this appendix to cover all 6.3 to 7.5 Bridges. The Bridge must be installed manually; it is not installed by the installer program.
The Siebel 7.0.4 to 7.5 Analytics Bridges	New for 7.5.3: Added appendix for installation of the Siebel eBusiness 7.0.4 to 7.5 Analytics Bridge. The Bridge must be installed manually; it is not installed by the installer program.
Troubleshooting the ETL Process	Added a reference to review Siebel Technical Note 406, located on SupportWeb.
The Siebel 6.3 to 7.5 Analytics Bridges	Added a reference to review Siebel Technical Note 429, located on SupportWeb.
The Siebel 7.0.4 to 7.5 Analytics Bridges	Added a reference to review Siebel Technical Note 429, located on SupportWeb.
Applying SIF Patches	Added instructions for applying the .sif file patches when upgrading from versions of Siebel Data Warehouse prior to 7.5.2.101.

Additional Changes

• Corrected or added settings for code pages in non-English deployments.
• Changed the term batch (as used for ETL) to workflow.
• Removed most uses of the term OLAP, and replaced it with more specific terms based on context.

Version 7.5, Rev. C

Table 4.  Changes Made in Version 7.5 Rev. C

Topic	Revision
7.5.2.210/.211 Maintenance Release requirement	Added a note to the Introduction stating that this guide assumes that you are using the 7.5.2.210 or 7.5.2.211 maintenance release.
Appendix A, Siebel ePharma 6.3 to 7.5 Analytics Bridge	Added a note to Installer procedure regarding a new choice to install the Analytics Bridge, with cross-reference to Appendix B, where the Analytics Bridge is described.
	Added a note to Installer procedure that if an Analytics Bridge will be installed, to read the appendix before beginning.
Importing Data with Siebel EIM	This section, of interest only to those customers using the Siebel Life Sciences Data Warehouse, has been moved to Siebel Life Sciences Guide.

Version 7.5, Rev. B

Table 5.  Changes Made in Version 7.5 Rev. B

Topic	Revision
7.5.2.200 Maintenance Release requirement	Added a note to the Introduction stating that this guide assumes that you are using the 7.5.2.200 maintenance release.
Appendix A, Siebel ePharma 6.3 to 7.5 Analytics Bridge	Added Appendix on installation of Siebel ePharma Data Warehouse 6.3 to 7.5 Analytics Bridge.
	Added note to Installer procedure regarding a new choice to install the Analytics Bridge, with cross-reference to Appendix A, where the Analytics Bridge is described.
Installing and Configuring the Siebel Data Warehouse in DB2 for OS/390	The Siebel Analytics installer does not work for installation of the data warehouse for DB2 for OS/390. Appendix C provides instructions on using the previous SES installer to install the data warehouse.
In the Administering and Troubleshooting the Siebel Data Warehouse restoration of "Analytics Data Loading Matrix for Syndicated Data" and "Siebel Analytics for Life Sciences" sections of book	The material in the "Analytics Data Loading Matrix for Syndicated Data," "Siebel Analytics for Life Sciences," and EIM loading sections is about loading data from the OLTP into the Siebel Data Warehouse. It was removed from the previous version of the book but has been restored.

Version 7.5.2.101

Table 6.  Changes for Version 7.5.2.101

Topic	Revision
Installing the Siebel Data Warehouse	Added notes in the Introduction and "Installing and Configuring the Siebel Data Warehouse" chapter, to specify that the Siebel Data Warehouse must be installed through the Siebel Analytics installation.
	Installation section rewritten to reflect new installation program.
Deleted "Analytics Data Loading Matrix for Syndicated Data" and "Siebel Analytics for Life Sciences" sections from the Administering and Troubleshooting the Siebel Data Warehouse chapter	This material is not about the data warehouse, but rather about loading data into the OLTP. These sections are to be moved to more appropriate books.
Third Party Documentation	The third-party products and documentation sections, previously widely separated, were reorganized and combined into one table.

Version 7.5.2 Rev. A

Table 7.  Changes for Version 7.5.2 Rev. A

Topic	Revision
General platform-specific information	Most information about supported platforms was removed to Siebel System Requirements and Supported Platforms. However, where platform variations influence the configuration process, this information was retained, clarified, or added (see below).
Informatica Client requirements	In "Installing Informatica PowerMart Client" on page 36, added warning notes about configuring specific operating system platforms with a specific DBMS.
Oracle DBMS requirements	Added tablespace and binary sorting requirements to "Oracle-Specific Database Requirements" on page 29.
SQL Server requirements	Added "To modify the DB Library Options setting" on page 31.
UNIX installation requirements	Added note to "Configuring the Repository Server" on page 62 that this installation must be from a CD-ROM.
Added installation step	Added "To check the log file" on page 51.
System variable changes	Rewrote "Changing the System Variables" on page 52 as a procedure, and added NLS_LANG information.
	Added HP-UX, Solaris, and AIX settings to "Setting the Environment Variables for Informatica Server Under UNIX" on page 63.
Data Code Pages	Added "Data Code Pages Validation" on page 51 to resolve operating system conflicts with languages.
	Added note that Code Page 1252 must run on the Informatica Server (Siebel Data Warehouse Server) to "Configuring the Informatica Service" on page 39.

Bookshelf Home | Contents | Index | Search | PDF