Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows >

Installation and Configuration Process Task List for Windows


The Oracle BI Applications installation and configuration process consists of the following tasks. Complete each of these tasks in the order listed below.

  1. Installing the Java SDK (if not already installed as part of the Oracle BI infrastructure installation).
  2. Running the Oracle Business Intelligence Applications Installation Wizard (Windows).
  3. Running the Informatica PowerCenter Installation Wizard (Windows).
  4. Setting Up the Informatica Server and Informatica Repository Server
    1. Process Of Setting Up The Informatica Server
    2. Process Of Setting Up The Informatica Repository Server
    3. Process of Starting the Informatica Services
  5. Setting Environment Variables on Windows
  6. Installing the Informatica Patch for Teradata. (Teradata only)
  7. Setting Informatica Data Code Pages Validation.
  8. Process of Copying Hibernate Libraries
  9. Configuring the DAC Client.
    1. Process of Configuring the DAC Config.bat File.
    2. Installing JDBC Drivers for DAC Database Connectivity.
  10. Creating the Required Databases
  11. Creating the DAC Metadata Repository.
  12. Configuring the DAC Metadata Repository.
    1. Setting Up DAC System Properties.
    2. Specifying Transactional and Data Warehouse Data Sources in the DAC
    3. Configuring Email Recipients in the DAC Client
    4. Configuring Email Recipients in the DAC Client.
    5. Activating Join Indices for Teradata Databases.
  13. Configuring the Oracle Business Analytics Warehouse Database.
    1. Process of Creating the SSE Role.
    2. Process of Creating Data Warehouse Tables.
    3. Process of Creating Data Warehouse Tables on a Teradata Database
  14. Registering Informatica Servers in the DAC Client.
  15. Process of Configuring and Managing the Informatica Repository.
    1. Process of Registering the Informatica Repository Server
    2. Process of Loading the Pre-Built Repository Into Informatica.
    3. Process of Configuring the Informatica Repository in Workflow Manager
    4. Process of Stopping and Starting the Informatica Repository (Optional).
    5. Process of Backing Up and Restoring the Informatica Repository (Optional).
  16. Setting the Code Page File Property for Unicode Environments on Teradata Databases
  17. Setting Up the HOSTS File for Teradata Installations on Windows.
  18. Verifying the Informatica Repository Configuration.
  19. Starting the Informatica Server.

NOTE:  You must perform the following steps for each source database type.

  1. Setting Up The Time Dimension
  2. Configuring the DAC Server.
    1. Process of Configuring the Connection Between the DAC Server and DAC Repository
    2. Process of Configuring Email in the DAC Server (Optional)
    3. Process of Setting DAC Source System Parameters
    4. Process of Starting the DAC Server
  3. Updating Siebel Transactional Database Schema Definitions.
    1. Process of Applying Siebel (CRM) and Oracle E-Business Suite Schema Changes For Oracle, DB2/UDB, MSSQL.
    2. Process of Applying CRM Schema Changes For DB2 on 390 or z/os
    3. Process of Verifying the Siebel (CRM) and Oracle E-Business Suite Schema Changes.
    4. About Delete Triggers.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.