Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring the Data Sources for Oracle Business Intelligence >

About Configuring Initialization Blocks


Typically, initialization blocks do not have to be reconfigured if you use one of the supported database platforms. The SQL for the applications repository initialization blocks and all selected tables are set for the Oracle Business Intelligence-supported database versions of the following DBMS:

  • Oracle
  • IBM DB2
  • Microsoft SQL Server

The SiebelAnalytics.rpd file uses initialization blocks that set dynamic session and repository variables. To prevent logon failures when running Oracle databases, make sure that all initialization blocks are configured to use the correct logon for Siebel operational applications.

For more information about variables, initialization blocks, and adding custom SQL in initialization blocks, see Oracle Business Intelligence Server Administration Guide.

NOTE:  To test your installation, you may need to change connection pool settings for items such as the name of the database, user ID, and password.

Oracle Business Intelligence Infrastructure Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.