v
4.3
Mandatory Requirements .......................................................................................................... 4-7
4.3.1
Oracle Business Intelligence Infrastructure Requirements for the Oracle BI
Applications Installer ......................................................................................................... 4-7
4.3.2
Informatica PowerCenter Requirements.......................................................................... 4-8
4.3.3
Code Page and Data Movement Requirements .............................................................. 4-9
4.4
Preinstallation Tasks................................................................................................................ 4-10
4.4.1
Create Databases for Oracle BI Applications and Informatica PowerCenter
Components...................................................................................................................... 4-11
4.4.1.1
How to Create the SSE Role ..................................................................................... 4-11
4.4.2
Install and Configure Database Connectivity Software.............................................. 4-12
4.4.2.1
How to Set the NLS_LANG Environment Variable for Oracle Databases ....... 4-13
4.4.2.2
How to Set the DB2CODEPAGE Environment Variable for DB2 Databases ... 4-14
4.4.3
Perform Prerequisites for Informatica PowerCenter Installation.............................. 4-15
4.5
Installing the Oracle BI Applications files............................................................................ 4-15
4.6
Installing and Setting Up Informatica PowerCenter .......................................................... 4-19
4.6.1
Installing Informatica PowerCenter Client Tools (Windows) ................................... 4-21
4.6.2
Installing Informatica PowerCenter Services ............................................................... 4-21
4.6.3
Creating the Informatica Repository Service................................................................ 4-23
4.6.4
Creating the Informatica Integration Service ............................................................... 4-25
4.6.5
Restoring the Pre-built Informatica Repository ........................................................... 4-26
4.6.5.1
Restoring the Pre-built Informatica Repository for Environments in English . 4-26
4.6.5.2
Restoring the Pre-built Informatica Repository on a Non-English Operating
System ........................................................................................................................ 4-28
4.6.6
Configuring Informatica PowerCenter Components .................................................. 4-28
4.6.6.1
Setting up the Informatica Domain and Repository in Informatica PowerCenter
Client Tools................................................................................................................ 4-28
4.6.6.2
Copying Source Files and Lookup Files................................................................. 4-31
4.6.6.3
Setting PowerCenter Integration Services Relaxed Code Page Validation....... 4-32
4.6.6.4
Setting PowerCenter Integration Services Custom Properties ........................... 4-32
4.6.6.5
Creating the Repository Administrator User in the Native Security Domain . 4-33
4.7
Installing and Setting Up the DAC Platform ....................................................................... 4-35
4.7.1
Installing DAC Using the DAC Installer....................................................................... 4-35
4.7.2
Installing the DAC Server on UNIX............................................................................... 4-37
4.7.3
Installing JDBC Drivers for DAC Database Connectivity .......................................... 4-38
4.7.4
Creating ODBC Database Connections for the DAC Client....................................... 4-39
4.7.4.1
How to Create ODBC Connections for Oracle Databases ................................... 4-40
4.7.4.2
How to Create ODBC Connections for DB2 Databases ....................................... 4-41
4.7.4.3
How to Create ODBC Connections for SQL Server Databases........................... 4-41
4.7.4.4
How to Create ODBC Connections for Teradata Databases............................... 4-42
4.7.5
Installing pmcmd and pmrep to Enable Communication Between Informatica
PowerCenter and DAC ................................................................................................... 4-42
4.7.6
Installing DAC Metadata Files........................................................................................ 4-43
4.8
Logging into DAC for the First Time and Importing Metadata into the DAC
Repository ................................................................................................................................. 4-44
4.8.1
Logging into DAC and Creating a Connection to the DAC Repository................... 4-44
4.8.2
Importing Metadata into the DAC Repository............................................................. 4-46
4.9
Creating the Oracle Business Analytics Warehouse Tables .............................................. 4-49
4.9.1
Creating Data Warehouse Tables ................................................................................... 4-49