8.1.1 Configuring Data Analysis Tool

The Data Analysis Tool uses the install.cfg and analysis.xml (or similar) configuration files. You edit either file in a text editor such as vi. To produce well-formed XML files, however, you should edit the XML file in a validating XML editor.

Configuring General Tool Properties

Use the Data Analysis Tool to configure the general tool properties. To access the Data Analysis Tool, navigate to the install.cfg file that resides in <OFSAAI Installed Directory>/ database/db_tools/mantas_cfg. The following table provides the configuration instructions for the properties that the Data Analysis Tool uses in the install.cfg file.

Table 8-1 Configuring General Tool Properties

Property Description Example
database.driver Name Database connection driver that the utility is to use. database.driverName =oracle.jdbc.driver. OracleDriver
utils.database.urlName Database connection string that the Data Analysis Tool is to use. utils.database.urlName=jdbc:oracle:oci: @PROD_DB
schema.business.owner Database user for the ATOMIC schema. schema.business. owner=ATOMIC
dat.database. username User name for the database. The Data Analysis Tool connects to the database as the ATOMIC USER for the appropriate privileges. dat.database.username= ATOMIC
dat.database. password Password for the database. This is set by the Password Manager Utility.
dat.analysis. input Path and name for the XML input file.

By default, this is the analysis.xml file under the <OFSAAI Installed Directory>/database/ db_tools/mantas_cfgdirectory. You can override this at the command line.

dat.analysis.input=/opt/ mantas/database/ db_tools/ mantas_cfg/ analysis.xml
dat.analysis. output Path and file name of output file for the analysis report. You can override this at the command line. dat.analysis.output=/opt/ mantas/database/ db_tools/ data/ analysis.html
dat.output. format Output format for the report. Acceptable output formats are HTML or TEXT. dat.output.format=HTML
dat.output. delimiter Not currently used. The delimiter for the format TEXT is always a comma (“,”).
schema.market. owner Database user for the ATOMIC schema. schema.market.owner=ATOMIC