Business Intelligence (BI) Interface Guide › Installation on One Database › Configuration

Configuration

Prior to installation, edit the RDLProperties.xml file, located under the BI_Interface folder, as follows:

• In the Source DB Users section edit the following keys according to your specifications:
  • SourceGlobalName: The global name of the source database.
  • Source_TNSNAME: The alias needed to connect to the source database from where the scripts are run.
  • SourceDBUser: An existing DB user on the source database where the CA Business Service Insight tables exist.
  • SourceDBPass: The password for SourceDBUser.
  • SourceDBAdminUser: The system user of the source database.
  • SourceDBAdminPass: The password for SourceDBAdminUser.
  • SourceStreamAdminUser: This user is created by the SQL scripts, therefore a user with this name should not exist. In this type of installation, keep the default value for this parameter.
  • SourceStreamAdminPass: The password for SourceStreamAdminUser. In this type of installation, keep the default value for this parameter.
• In the Target DB Users section edit the following keys according to your specifications:
  • TargetGlobalName: The same value set in SourceGlobalName.
  • Target_TNSNAME: The same value set in Source_TNSNAME.
  • TargetDBUser: The same value set in SourceDBUser.
  • TargetDBPass: The same value set in SourceDBPass.
  • TargetDBAdminUser: The same value set in SourceDBAdminUser.
  • TargetDBAdminPass: The same value set in SourceDBAdminPass.
  • TargetDBRegularUser: This user is created. This user is granted read-only access to the replicated data and the created views, excluding: full T_PSL interface, T_PSL, T_RAW_DATA, T_SLALOM_OUTPUTS, and T_INTERMEDIATE_DATA.
  • TargetDBRegularPass: The password for the TargetDBRegularUser.
  • TargetStreamAdminUser: This user will be created by the SQL scripts, therefore a user with this name should not exist. In this type of installation, keep the default value for this parameter.
  • TargetStreamAdminPass: The password for the TargetStreamAdminUser. In this type of installation, keep the default value for this parameter.
  • FilePath: Specifies the location of the database file for new table space.
• In the Tables to be replicated and interfaces to be created section edit the following keys according to your specifications:
  • Replication: Specifies whether installation is to be on two separate databases connected using streams technology (true) or on the original database (false). In this type of installation set the parameter to false.
  • ReplicatedTables_PSL: List of tables needed to be replicated for the T_PSL interface.
  • CreatePSLInterface: Specifies whether the T_PSL interface should be created. Possible values are true or false.
  • ReplicatedTables_RAW_DATA: List of tables needed to be replicated for the T_RAW_DATA interface.
  • CreateRAW_DATAInterface: Specifies whether the T_RAW_DATA interface should be created. Possible values are true or false.
  • ReplicatedTables_SLALOM_OUTPUTS: List of tables needed to be replicated for the T_SLALOM_OUTPUTS interface.
  • CreateSLALOM_OUTPUTSInterface: Specifies whether the T_SLALOM_OUTPUTS interface should be created. Possible values are true or false.
  • ReplicatedTables_Booklets: List of tables needed to be replicated for the Booklet mapping interface.
  • CreateBookletsInterface: Specifies whether the Booklet mapping interface should be created. Possible values are true or false.
  • AdditionalTables: List of any additional tables that need to be included in the replication process.
  • AdditionalTablesInterface: Specifies whether the Additional tables need to be replicated. Possible values are true or false.