Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse in DB2 for OS/390 >

Installing Siebel Data Warehouse for DB2 under OS/390


The following are the main steps required to complete the installation of the Siebel Data Warehouse:

  1. To install the Informatica repository on DB2 for OS/390
  2. To configure the Informatica repository on DB2 for OS/390
  3. To install the star schema tables for DB2 on OS/390

NOTE:  Do not use the following procedures unless you have completed To install the Siebel Data Warehouse using the Siebel Data Warehouse installer.

To install the Informatica repository on DB2 for OS/390

  1. In Step 3 of To install the Siebel Data Warehouse using the Siebel Data Warehouse installer, fill out the Prerequisite Check screen to create and configure the Informatica repository, using the following table as a guide, and then click Next. Do not create the Siebel Data Warehouse tables because it is covered in Installing the Star Schema Tables on DB2 for OS/390.
    Option
    Default Setting
    Comments
    Create Informatica Repository
    Selected
    Select this to create an Informatica repository specific to Siebel Analytics.
    Delete existing Informatica Repository
    Clear
    Select this only when you need to delete an existing Informatica Repository. This is not needed for a new installation, as there is no existing Informatica Repository. However, if you have a failed installation and need to do a clean install, select this box.
    Configure Informatica Repository (enter source and target information)
    Selected
    Select this to configure the Informatica repository's connection to the Siebel Transaction Database.
    Create Siebel Data Warehouse Tables
    Selected
    Clear this box. You create the Siebel Data Warehouse (star schema) tables using a separate installer after completing the Informatica repository configuration. For information on creating the Siebel Data Warehouse tables, see Installing the Star Schema Tables on DB2 for OS/390.
    Drop existing Siebel Data Warehouse Tables
    Clear
    Do not select this. If you need to drop existing tables, have your DBA drop them.
  2. Specify the connection information to be used for the Siebel Transaction Database.

    This information will be placed in the Informatica Repository, to be used by Informatica to access the Siebel Transaction Database. Fill out the form, using the following table as a guide, and then click Next.

    Field
    Description
    Platform
    Choose DB2.
    Connect String
    Enter the native connect string (example: server@database) to the Siebel Transaction Database.
    Table Owner
    Identify the table owner of the Siebel Transaction Database.
    Password
    Enter the password (double-entry confirmation).
    MS SQL DBMS Name
    Leave this blank.
    Unicode
    Do not select. This is reserved for future compatibility with Unicode databases.
    ODBC Data Source
    Enter the Data Source Name (DSN) for the Siebel Transaction Database.
  3. Specify the connection information to the database that holds the Informatica repository. Fill out the form, using the following table as a guide, and then click Next.

    NOTE:  Enter connection information to the database that holds the Informatica repository, even though the window indicates the Siebel Data Warehouse.

    Fields
    Description
    Platform
    Choose the RDBMS that holds the Informatica repository (DB2, MS SQL Server, or Oracle).
    Connect String
    Enter the native connect string (example: server@database) to the database that holds the Informatica repository.
    Table Owner
    Identify the table owner.
    Password
    Enter the password (double-entry confirmation).
    ODBC Data Source
    Enter the Data Source Name (DSN) for database that holds the Informatica repository.
    Unicode
    Do not select. This is reserved for future compatibility with Unicode databases.
    Email address
    Enter an email address or group distribution name. When Informatica completes a build of the Siebel Data Warehouse, it sends an email notification to this address. Enter a complete email address. Example: MarketingSupervisor@yourcompany.com
  4. Click Finish to close the window.

To configure the Informatica repository on DB2 for OS/390

  1. Open Informatica Workflow Manager.
  2. Connect to the repository.
  3. From the Server Configuration menu, choose Database connections.
  4. In the Database Connections window, select OLAP and click Edit.
  5. In the Edit Database Connection window, fill out the form using the following table as a guide.
    Field
    Description
    Database Type
    Choose DB2, which is the RDBMS for the Siebel Data Warehouse.
    Data Source
    Choose OLAP.
    User Name
    Enter the user name for the database that holds the Siebel Data Warehouse on DB2 for OS/390.
    Password
    Enter the password for the database that holds the Siebel Data Warehouse on DB2 for OS/390.
    Connect String
    Enter the connect string (example: server@database) for the Siebel Data Warehouse on DB2 for OS/390.
    Code Page
    Choose a code page. If in doubt, choose MS Windows Latin 1 (ANSI) superset of Latin.
  6. Install the Siebel Data Warehouse tables.

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