Preinstallation Tasks
4-12
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Note
: 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.
To create the SSE role
1.
Create a database role named SSE_ROLE (SSEROLE for DB2/390 databases).
Assign this role to the database user that you are using for the target database. For
example, in an Oracle database, you might use the following commands to create
the role, grant DBA privileges to the new role, and assign the SSE_ROLE role to a
database user named OLAP:
CREATE ROLE SSE_ROLE;
GRANT DBA TO SSE_ROLE;
GRANT SSE_ROLE TO olap;
For instructions on creating roles, refer to the documentation provided with your
database.
Note the following:
For an Oracle database, when you create the SSE_ROLE role, you need to grant the
following privileges:
CONNECT
RESOURCE
For an Oracle database, if the DAC Repository and the Informatica Repository are
stored in a different database from the data warehouse database, the SSE_ROLE
must have the following additional privileges:
SELECT
INSERT
UPDATE
DELETE
GRANT
If you are using a Teradata database, you do not need to create the SSE role.
If you are using a DB2/390 database, you can use the alternative SSE role name
SSEROLE if required. To specify a different role name, modify the 'set
GRANTEE="SSEROLE"' line in the ORACLE_
HOME\biapps\dwrep\createwtables.bat file.
4.4.2 Install and Configure Database Connectivity Software
You must install and configure the appropriate database connectivity software on the
machines that host the Informatica PowerCenter Services, DAC Server, and DAC
Client.
The machine that hosts the PowerCenter Integration Service requires connectivity to
the Oracle Business Analytics Warehouse (target) database and transactional (source)
Note:
Delete triggers are only used with Siebel CRM databases.