Bookshelf Home | Contents | Index | Search | PDF |
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:
NOTE: Do not use the following procedures unless you have completed To install the Siebel Data Warehouse using the Siebel Analytics installer.
To install the Informatica repository on DB2 for OS/390
- In Step 3 of To install the Siebel Data Warehouse using the Siebel Analytics 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. That is covered in Installing the Star Schema Tables on DB2 for OS/390.
Option Default Setting Comments Create Informatica Repository Checked Check this to create an Informatica repository specific to Siebel Analytics. Delete existing Informatica Repository Clear Check 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, check this box. Configure Informatica Repository (enter source and target information) Checked Check this to configure the Informatica repository's connection to the Siebel Transaction Database. Create Siebel Data Warehouse Tables Checked 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, refer to Installing the Star Schema Tables on DB2 for OS/390. Drop existing Siebel Data Warehouse Tables Clear Do not check this. If you need to drop existing tables, have your DBA drop them.- 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.
- Specify the connection information to the database holding 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.
- Click Finish to close the window.
To configure the Informatica repository on DB2 for OS/390
- Open Informatica Server Manager.
- Connect to the repository.
- From the Server Configuration menu, choose Database connections.
- In the Database Connections window, select OLAP and click Edit.
- In the Edit Database Connection window, fill out the form using the following table as a guide.
- Install the Siebel Data Warehouse tables.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C Published: 18 April 2003 |