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:
- To install the Informatica repository on DB2 for OS/390
- To configure the Informatica repository on DB2 for OS/390
- 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
- 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.
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.- 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 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.
- Click Finish to close the window.
To configure the Informatica repository on DB2 for OS/390
- Open Informatica Workflow 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 Published: 09 September 2004 |