Preinstallation Tasks
Installing and Setting Up Oracle BI Applications
4-11
4.4.1 Create Databases for Oracle BI Applications and Informatica PowerCenter
Components
Before you install Oracle BI Applications, the Data Warehouse Administration Console
(DAC), and Informatica PowerCenter, use your target database tool to create database
instances to hold the following:
DAC Repository
Informatica Domain
Informatica Repository
Oracle Business Analytics Warehouse
Note the following points:
The transactional (OLTP) database user that is registered in DAC should be the
database table owner. Alternatively, at a minimum, the user registered in DAC
must have read privileges on the transactional database for all tables and aliases.
For Siebel CRM databases, the OLTP database user requires privileges to create
triggers and views on all tables and aliases.
For efficient ETL, DAC and Informatica components utilize multiple connections
to the Oracle Business Analytics Warehouse. The Oracle Business Analytics
Warehouse database must allow for a minimum of 100 connections to be made by
DAC and Informatica. In addition, ensure that these connections are not allowed
to time out. Consult with your network administrator and DBA for information on
how to ensure these requirements.
Make sure that the Oracle Business Analytics Warehouse instance is granted the
SSE_ROLE. For more information, see
Section 4.4.1.1, "How to Create the SSE
Role."
You can store the DAC Repository and the Oracle Business Analytics Warehouse
in separate databases or in the same database.
The DAC and Informatica repositories are not supported on all database
platforms. For information about which database platforms are supported, see
System Requirements and Supported Platforms for Oracle Business Intelligence
Applications.
For database requirements for the Informatica PowerCenter components, see the
topic titled, "Verifying Prerequisites," in "Chapter 2: Before You Install," in the
PowerCenter Installation and Configuration Guide.
You must create the Informatica PowerCenter domain configuration database
before you run the PowerCenter installer. For more information see the topic
titled, "Creating the Domain Configuration Database," in "Chapter 2: Before You
Install," in the PowerCenter Installation and Configuration Guide.
4.4.1.1 How to Create the SSE Role
Follow this procedure to create the SSE role for the Oracle Business Analytics
Warehouse database.
Note:
Delete triggers are only used with Siebel CRM databases.