Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse > Installing the Siebel Data Warehouse >

Installing the Siebel Data Warehouse

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

  1. 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:

    (1) License Agreement

    (2) Prerequisite Check

    (3) DSN Configuration

    (4) Destination Folder

    (5) Setup type

    (6) Cache Configuration

    (7) Language selection

    (8) COM Service Type

    (9) Logon Service

    (10) Temporary Folders

    (11) Mail Server

    (12) Scheduler Server

  2. Prerequisite Check screen: Select one or more choices as appropriate.
    1. 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.
    2. 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).

  3. 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.

  1. 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.

    Option
    Action
    Create Informatica repository
    For creating an Informatica repository into a fresh database or from an existing data warehouse, select this box.
    Note that if you select this option, you cannot select the Configure Informatica repository option.
    Delete existing Informatica repository
    For a new installation, this is not needed; leave unselected.
    For an installation from an existing data warehouse, select this box.
    For a failed installation (requiring a clean installation), select this box.
    Configure Informatica repository (enter source and target information)
    For creating an Informatica repository into a fresh database or from an existing data warehouse, select this box.
    Note that the repository server service must have been configured and be running before this step is possible. Also note that if you select this option, you cannot select the Create Informatica repository option.
    Create Siebel Data Warehouse Tables
    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.
    Drop existing Siebel Data Warehouse Tables
    For a new installation, this is not needed; leave unselected.
    For an installation from an existing data warehouse, select this box.
    For a failed installation (requiring a clean installation), select this box.
    Select this to drop (remove) existing Siebel Data Warehouse (star schema) tables and create new Data Warehouse tables.
  2. 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.
    Field
    Description
    Platform
    Choose the DBMS platform. If you choose MS SQL, then you must also fill out the MS SQL DBMS Name field.
    Connect String
    Enter the native connect string to the Siebel transactional database (or the database alias).
    Table Owner
    Enter a valid user name with database owner privileges of the Siebel transactional database.
    Password
    Enter the password (double-entry confirmation).
    MS SQL DBMS Name
    If you chose MS SQL as the platform above, then enter the name of the database. For DB2 and Oracle platforms, leave this blank.
    Unicode
    Select the option box if your database is Unicode.
    ODBC Data Source
    Enter the Data Source Name (DSN) for the Siebel transactional database.
  3. 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.
    Fields
    Description
    Platform
    Choose the DBMS platform. If you choose MS SQL then when you click Next, the installer prompts you for the MS SQL DBMS Name.
    Connect String
    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.
    Table Owner
    Enter a valid user name with database owner privileges of the Siebel Data Warehouse.
    Password
    Enter the password (double-entry confirmation).
    ODBC Data Source
    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.
    Unicode
    Select the option box.
    Email address
    Leave this field blank.
  4. 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.

  5. 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.
  6. 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.
    Field
    Description
    Platform
    Choose the RDBMS platform.
    Connect String
    Enter the native connect string to the Siebel Data Warehouse.
    Table Owner
    Enter a valid database user.
    Password
    Enter a valid database password.
    Administrator Login
    Enter "Administrator."
    Administrator password
    Enter "Administrator."
    MS SQL DBMS Name
    If you chose MS SQL as the platform earlier, then enter the name of the database. For DB2 and Oracle platforms, leave this blank.
    Repository Name
    Enter a name for your Siebel Data Warehouse repository, such as "Siebel_DW_Rep."

    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.

    To check the log file

    1. Open $INSTALL_DIR\dwdb\dwdb.log. This file shows the number of tables installed in the Siebel Data Warehouse.
    2. Click Finish to close the window.

    •  Siebel Data Warehouse Installation and Administration Guide
     Published: 09 September 2004