Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse > Installing the Siebel Data Warehouse >
Installing the Siebel Data Warehouse
- You must install the Siebel Data Warehouse through the Siebel Data Warehouse Installation Wizard.
In the Prerequisite Check screen, you select the data warehouse for the Siebel eBusiness (Horizontal) or the Siebel Industry (Vertical) application to install. The installation wizard creates a Start Menu item and Windows Desktop icon. Clicking this Desktop icon after the installation runs a second wizard to configure the Siebel Data Warehouse repository.
NOTE: If you are installing to a UNIX operating system, you will need to run the Siebel Analytics Installer on a Windows platform in order to install Siebel Data Warehouse tables, because this Wizard is a Windows-only application.
- You may install either from the installation CD-ROM or from a network location that contains the installation files.
- Use this installation wizard on English-language (ENU) installations only, not on PSE (pseudo-language code).
NOTE: Only the Siebel Data Warehouse installation-specific screens are described in detail in this book. For a description of the other screens, plus a more detailed procedure for the installation, see Siebel Analytics Installation and Configuration Guide.
To install the Siebel Data Warehouse using the Siebel Data Warehouse installer
- Run the program setup.exe.
(On Windows 2000, an Installshield message screen may appear, stating that an older version of the Windows Installer is being used. Ignore this message. Close the message window and proceed with the installation.)
The installation wizard prompts you through each screen. For details of Steps 1 through 12, see Siebel Analytics Installation and Configuration Guide. The first twelve screens are:
- Prerequisite Check screen: Select one or more choices as appropriate.
- Database client type:
- For Siebel Analytics operational applications installation only:
If you are using MS SQL Server for your transactional database or data warehouse, the installer proceeds to the DSN Configuration screen. You set up the Data Source Names (DSNs) using the Microsoft ODBC Driver Manager. (The actual configuration is done after all the files have been copied. Choose the database connectivity client from the choices given.)- For other databases, you are not prompted for DSN configuration. However, you should set up the DSNs appropriately later. For example, for IBM DB2, use the DB2 Client Configuration Assistant to set up the database connectivity and DSNs.
- If you are installing a data warehouse, specify which one:
- Horizontal (Siebel Enterprise Application)
- Vertical (Siebel Industry Applications)
NOTE: Although these options are not listed in the Prerequisite Check screen, you may also install one of the Siebel Analytics Bridge products. Depending on the specific bridge you are installing, see either Appendix A or Appendix B for additional information before continuing the installation. To complete a Siebel Analytics Bridge installation, select Horizontal (Siebel Enterprise Application).
- Install the Siebel Data Warehouse.
You are prompted to create, delete, or configure an Informatica repository, or to create or drop Siebel Data Warehouse tables. The requested information is shown in the tables.
If you are installing DB2 UDB under OS/390, use the procedure in Installing and Configuring the Siebel Data Warehouse in DB2 for OS/390.
If you are installing to a UNIX operating system, you will need to run the Siebel Analytics Installer on a Windows platform to install Siebel Data Warehouse tables, because this Wizard is a Windows-only application.
For deployment in non-English language environments, see Deploying Informatica and Siebel Data Warehouse in Non-English Environments.
CAUTION: If you are installing a Siebel Analytics Bridge, you must pause your installation at this point to replace the standard 7.5 Informatica repository (.rep) file with the Bridge-specific Informatica repository file. For further information regarding this procedure, see The Siebel 6.3 to 7.5 Analytics Bridges or The Siebel 7.0.4 to 7.5 Analytics Bridges.
- Fill out the Setup Type page, using the following table as a guide, and click Next.
NOTE: Determine the values for these options before beginning the installation.
Select this to create star schema tables within the Siebel Data Warehouse. The Data Warehouse Server populates these star schema tables when you run a build process.For more information, see Administering and Troubleshooting the Siebel Data Warehouse.- Specify the connection (source) information to be used for the Siebel transactional database. This information will be placed in the Informatica repository, to be used by Informatica to access the Siebel transactional database. Fill out the form on this window using the following table as a guide, then click Next.
- Specify the connection (target) information to the Siebel Data Warehouse. When you create the connections to the Siebel Data Warehouse on the Data Warehouse Server (read Creating Database Connections), it must use the same information. Fill out the form, using the following table as a guide, then click Next.
Enter the native connect string or to the Siebel Data Warehouse (or database alias name). You created this connection on the Data Warehouse Server in Creating Database Connections. Enter the Data Source Name (DSN) for the Siebel Data Warehouse. You created this connection on the Data Warehouse Server in Creating Database Connections.NOTE: Oracle users should select a Data Source that uses an Oracle ODBC driver and not a Merant ODBC driver. You created this in Step 2 of To create database connections for Oracle installations.- If you selected "Delete existing Informatica repository" or "Drop existing Siebel Data Warehouse Tables" on the Setup Type window of the installer, then the installer displays the Siebel Old Data Warehouse Information window.
If you do not want to drop an existing Informatica repository or data warehouse tables, click Back until you get the Setup Type window of the installer, and clear the check boxes for "Delete existing Informatica Repository" and "Drop existing Siebel Data Warehouse Tables."
NOTE: To check the status of the repository restoration, read the dwdb.log file.
- The Siebel Data Warehouse Tablespace Information screen is for Oracle use only. Specify the tablespace for the target data warehouse by clicking Next to use the default tablespace information.
- Specify the location of the Siebel Data Warehouse repository location (target) information in the Configure Informatica Service screen. (This repository can reside in any database.) Fill out the form, using the following table as a guide.
When you click Next, the installer connects to the Siebel Data Warehouse and creates the following components:
- Informatica repository
- Data warehouse tables that hold the Siebel Data Warehouse information
NOTE: The default Informatica repository has the extension .rep.
At the completion of the Siebel Data Warehouse configuration during the initial installation, a Start Menu item and a desktop icon ("Siebel Data Warehouse Configurator") are created. Use these to perform subsequent incremental data warehouse configuration.
When the installation Wizard is finished, a screen prompt asks if you want to view the Readme file. After the installation wizard is finished, check the log file and change the system variables as necessary.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |