iii
Contents
Preface
................................................................................................................................................................. xi
Audience...................................................................................................................................................... xii
Documentation Accessibility .................................................................................................................... xii
Related Documents .................................................................................................................................... xii
Conventions ............................................................................................................................................... xiii
1
What's New in This Release
1.1
What's New in Oracle Business Intelligence Applications Installation Guide for
Informatica PowerCenter Users................................................................................................ 1-1
Part I
Getting Started
2
Overview of Oracle BI Applications
2.1
What Is Oracle BI Applications? ............................................................................................... 2-1
2.2
Oracle Business Analytics Warehouse Overview .................................................................. 2-2
2.3
Oracle Business Analytics Warehouse Architecture.............................................................. 2-2
2.3.1
Oracle Business Analytics Warehouse Architecture Components............................... 2-3
2.4
Roadmap to Installing and Configuring Oracle BI Applications ........................................ 2-4
2.5
Using Oracle BI Repository Documentation........................................................................... 2-5
Part II
Installation and Set Up Steps for Oracle BI Applications
3
Preinstallation and Deployment Requirements for Oracle BI Applications
3.1
General Guidelines for Setting Up Oracle Business Analytics Warehouse........................ 3-2
3.2
IBM DB2 UDB-Specific Database Guidelines for Oracle Business Analytics Warehouse 3-4
3.3
IBM DB2 UDB zOS and OS/390 and z/OS-Specific Database Guidelines for Oracle
Business Analytics Warehouse ................................................................................................ 3-5
3.4
SQL Server-Specific Database Guidelines for Oracle Business Analytics Warehouse ..... 3-6
3.4.1
Setting the ANSI NULL Option......................................................................................... 3-6
3.4.2
Modifying the DB Library Options Setting...................................................................... 3-6
3.4.3
Recommended SQL Server Database Parameters .......................................................... 3-7
3.5
Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse ......... 3-8
3.5.1
Installation of Required JDBC Driver for Teradata Databases ..................................... 3-8
3.5.2
General Guidelines for Teradata Deployments .............................................................. 3-9
3.5.3
Best Practices For Teradata Deployments..................................................................... 3-10