In this section, the following steps describe how you can configure the ODW database connection in the Reports module.
To begin, Obtain the password for ODW from /usr/local/nagios/etc/opsview.conf.
Next, Login to the JasperServer with an account that has REPORTADMIN privileges and click 'View > Repository'. Finally, In the Folders section on the left, as shown in the screenshot below, click the Data Sources folder:
Next, right click on 'ODW' and click 'Edit' which will load the configuration window for the ODW data source. This is how the reports module can retrieve and report on the historical data that is stored within the Opsview Data Warehouse. In order to allow the Reports module to connect, you need to provide it with valid credentials - therefore here you should enter the password you retrieved in step one (opsview.conf):
After entering your password into the 'Password:' field, click 'Test Connection'. If all it configured correctly, you should see the message 'Connection passed', as above.