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

Installing the Siebel Data Warehouse

NOTE:  Only the three Siebel Data Warehouse installation-specific screens are described in detail in this book. For a description of the other screens, see Siebel Analytics Installation and Configuration Guide.

To install the Siebel Data Warehouse using the Siebel Analytics installer

  1. Run the program setup.exe.

    2. (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: Check 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 OLTP or OLAP, 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)
      • Siebel ePharma Data Warehouse 6.3 to 7.5 ETL Bridge

        • NOTE:  If you are using Siebel ePharma 6.3, and are installing a licensed version 7.5 of Siebel Analytics, you will need to install the Siebel ePharma 6.3 to 7.5 Analytics Bridge. See The Siebel ePharma 6.3 to 7.5 Analytics Bridge before continuing the installation.

        NOTE:  Although this option is not listed in the Prerequisite Check screen, you may also install a Siebel eBusiness 6.3 to 7.5 Analytics Bridge. To complete the Siebel eBusiness 6.3 to 7.5 Analytics Bridge installation, select the Horizontal (Siebel Enterprise Application) option. See The Siebel eBusiness 6.3 to 7.5 Analytics Bridge for additional information before continuing the installation.

  3. Install the Siebel Data Warehouse.

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

CAUTION:  If you are installing the Siebel eBusiness 6.3 to 7.5 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 eBusiness 6.3 to 7.5 Analytics Bridge.

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

  1. Fill out the Setup Type page, using the following table as a guide, and click Next.

    2. 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, check this box.
    Delete existing Informatica repository
    For a new installation, this is not needed; leave unchecked.
    For an installation from an existing data warehouse, check this box.
    For a failed installation (requiring a clean installation), check 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, check this box.
    Create Siebel Data Warehouse Tables
    Check 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, read Administering and Troubleshooting the Siebel Data Warehouse.
    Drop existing Siebel Data Warehouse Tables
    For a new installation, this is not needed; leave unchecked.
    For an installation from an existing data warehouse, check this box.
    For a failed installation (requiring a clean installation), check this box.
    Check 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.

    3. 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
    Check 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 for OLAP and OLTP), it must use the same information. Fill out the form, using the following table as a guide, then click Next.

    4. 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 for OLAP and OLTP.
    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 for OLAP and OLTP.
    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
    Check the option box.
    Email address
    Leave this field blank.

  4. If you checked "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.

    5. 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 checkboxes 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.

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

  • 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, Version 7.5, Rev. C 
     Published: 18 April 2003