Business Intelligence (BI) Interface Guide › Installation on Two Separate Databases › 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.
  • SourceStreamAdminPass: The password for SourceStreamAdminUser.
• In the Target DB Users section edit the following keys according to your specifications:
  • TargetGlobalName: The global name of the target database.
  • Target_TNSNAME: The alias needed to connect to the target database from where the scripts are run.
  • TargetDBUser: An existing DB user on the target database where the tables of the replication process are going to be updated. It should contain instances from the tables that are going to be replicated. The script creates only replication processes that keep the tables up to date.
  • CreateBookletsInterface:The password for TargetDBUser.
  • TargetDBAdminUser: The system user of the target database.
  • TargetDBAdminPass: The password for TargetDBAdminUser.
  • 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 TargetDBRegularUser.
  • TargetStreamAdminUser: This user is created by the SQL scripts, therefore a user with this name should not exist.
  • TargetStreamAdminPass: The password for TargetStreamAdminUser.
  • 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 true.
  • 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.