Installation of Reporting Module

The reporting module consists of two components. The first component comprises the software that generate and manage the reports and the second component consists of an SQL script that provides part of the definition of the reports that the system can generate. The first component is included in the commercial distribution of OpenEMPI so it should already be installed and activated on your instance. The second component is also distributed with the commercial release of OpenEMPI but needs to be installed.

Installation of Report Definitions

The report definitions are distributed as an SQL script called report_definitions-entity.sql and should be located in the conf directory of your OpenEMPI home directory. The installation consists of simply loading the script onto the database that you are using.

Note: If you are using the H2 database, use the corresponding report definitions from the h2 sub-directory instead of the ones in the conf directory which are intended for Postgres

Note: In the following instructions use the password for the database user openempi for your installation as the instructions just use the password 'openempi' as an example

Installation on the Postgres Database

If you are using OpenEMPI with the Postgres database you can install the script using the following command from the OpenEMPI home directory

psql -U openempi -h localhost openempi \
	-f conf/report_definitions-entity.sql

Installation on the H2 Database

If you are using OpenEMPI with the H2 database you can install the script using the following command from the OpenEMPI home directory:

java -cp ../lib/h2-1.4.192.jar org.h2.tools.RunScript \
	-url jdbc:h2:tcp://localhost/openempidb \
	-user openempi -password openempi \
	-script conf/h2/report_definitions-entity.sql