The following are the step-by-step instructions to install the BI Interface on two seperate databases.
- Go to the machine you are planning to work from (CA Business Service Insight source database or BI Interface machine) and copy to it the BI_Interface folder which is located under the <installation directory>/Setup folder.
Description
After installing CA Business Service Insight, a folder called BI_Interface can be found under the <installation directory>/Setup folder.
The following folders can be found in the BI_Interface folder:
- Class: Folder containing the java class files needed for running the batch files for generating scripts.
- ExpImp: Folder where the export and import commands are going to be generated.
- Generated_setup_scripts: Folder in which the setup scripts are going to be created.
- Param_scripts: Folder where the initial scripts are stored. The scripts in this folder are used by the Build scripts batch file to create the setup scripts. Changes made to these scripts will result in changes in the generated scripts.
- remove_archived_logs: Folder containing script files used to remove archived redo log files.
- src: Folder containing the java class sources.
- The following files can be found in the BI_Interface folder:
- BuildScripts.bat: Batch file for generating the setup scripts.
- RDLProperties.xml: XML file that contains all the relevant parameters needed for the creation of the needed scripts.
- CreateExpImpBatch.bat: Batch file for generating the Export and Import commands with the parameter files.
- Runsql.bat: Batch file for executing the generated scripts. Before running this batch, make sure that the scripts in the generated_setup_scripts folder have been created.
- Undo_10.bat: Batch file for executing the Undo_10.sql script. This script removes the stream environment from the both source and target databases. It is intended for Oracle version 10 or later.
- Undo_9.bat: Batch file for executing the Undo_9.sql script. This script removes the stream environment from both the source and the target databases. It is intended for Oracle version 9.
- DelTBL's.bat: Batch file for deleting the imported tables and created views on the target database.
Note: In addition, each .bat file also has its UNIX equivalent file which has the same name and extension .sh.
Expected Result
You are located in the root of the location where the BI Interface installation kit exists and the files and folders exist as described in the Description column.
- Run the CreateExpImpBatch.bat file from the BI_Interface folder.
Description
To set up the Streams environment, you must first instantiate the tables that are going to be replicated. This operation creates the ExportTables.bat, ImportTables.bat, ExpParameterFile.txt, ImpParameterFile.txt, and PREP_INST.sql files. The CreateExpImpBatch.bat file uses the RDLProperties.xml file to read the data for the source and target databases for the tables that need to be replicated and for the Users that need to be created.
Expected Result
In the ExpImp folder the following files exist:
- ExportTables.bat
- ImportTables.bat
- ExpParameterFile.txt
- ImpParameterFile.txt
- PREP_INST.sql
- Run the BuildScripts.bat file from the BI_Interface folder.
Description
This operation creates all the needed SQL scripts in the generated_setup_scripts folder.
Expected Result
In the generated_setup_scripts folder you have 88 SQL scripts.
- Run ExportTable.bat from ExpImp folder.
Description
This operation performs an export of the tables that are written in the ExpParameterFile.txt file to the RDLExportedTables.dmp file.
Expected Result
- The RDLExportedTables.dmp file is created in the ExpImp folder.
- No errors appear in the ExportTable.log file located in the ExpImp folder.
- Run ImportTables.bat from ExpImp folder.
Description
This operation uses the RDLExportedTables.dmp file for importing to the target database. The ImportTables.bat file and other settings for performing the import are written in the ImpParameterFile.txt file.
Expected Result
The import process completed successfully and no errors appear in the ImportTables.log file located in the ExpImp folder.
- Run the runsql.bat file from the BI_Interface folder.
Description
This operation creates the Streams environment with all the needed processes and all the views and functions.
Expected Result
- The Streams environment with all the needed processes and all the views and functions is created successfully.
- No errors appear in the Logs_with_errors.txt file located in the BI_Interface folder.
