Business Intelligence (BI) Interface Guide › Business Intelligence Interface › Administration › Initial Configuration Tool

Initial Configuration Tool

The initial configuration tool is a part of the installation process. It enables the installation to be configurable, by generating SQL scripts needed for installing the system that take into account the configuration parameters. After all initial configuration parameters are set, this tool generates the SQL scripts that the user needs to execute in order to install the system.

The RDLProperties.xml file contains all the relevant parameters needed for the creation of the needed scripts. See Configuration for details on defining the initialization parameters in the RDLProperties.xml file.

When configuring the BI Interface for installation on two separate databases, the installation assumes that the target DB exists, but that the streams DB users and the second target DB user do not exist. The computer where the scripts will run needs to have access to both databases through sqlplus with SYS privileges for connection "as sysdba". Also, batch files for making the export and the import will be created, and these batch files should be executed before the rest of the scripts.

The configuration tool consists of the following parts:

• The scripts that are needed for creating the replication processes and interface views and functions. These scripts are general and will contain parameters for the variable sections of the scripts.
• A simple tool that parses the initial scripts and replace the parametric parts of the scripts with the configuration parameters from the parameters file.
• The batch files for executing the scripts that will be generated after parsing. The scripts will also create log files containing the log of the script execution and any problems encountered during the script execution. The batch files will return a list of problems encountered during script execution.
• A tool for creating export and import commands for the needed tables according to the properties file.
• An undo batch. Batch files that execute the scripts that remove the Oracle Streams environment; delete the created users, views, and functions; and put the databases back to the pre-install condition. There are two versions of these undo scripts, one for Oracle version 10 and later, and one for Oracle 9.