Configuring the Example JDBC Datasources

You must configure the example JDBC datasources imported to the JasperReports Server to connect to the correct ActiveMatrix BPM database and BDS case data store, to access the data to be displayed in the dashboards.

Prerequisites

A JDBC driver for the appropriate database type(s) must be available in the JasperReports server's classpath. See TIBCO ActiveMatrix BPM Installation and Configuration for details of the JDBC drivers needed to connect to the different databases supported by ActiveMatrix BPM. See the JasperReports Server documentation for information about how to upload and make available the required JDBC driver.

Procedure

  1. Log into the Jaspersoft server as a system administrator (by default, the jasperadmin user).
  2. Select View Repository and, in the Folders panel, expand the tree to Organizations > Organization > AMX-BPM.
  3. In the Repository panel, select AMX-BPM Datasource and click Edit.
    The details of the JDBC data source that will be used to connect to the ActiveMatrix BPM database are displayed. Default ActiveMatrix BPM installation values are used, which you should edit as required.
  4. Select the correct JDBC Driver for the ActiveMatrix BPM database.
  5. Enter the Host IP address, Port number, and database details used by the ActiveMatrix BPM database. (These fields are used to construct the connection URL.) The database detail fields are:
    • Database name, for SQL Server or PostrgeSQL.
    • Service, for Oracle
    • Database, Driver Type and Schema Name, for DB2.
  6. If you are using the IBM DB2 JDBC driver, edit the connection URL to remove the ;currentSchema=schemaname parameter from the connection string. (If you do not do this the dashboard reports will not show any data, because the underlying queries assume use of a default schema name.)
    Note: You do not need to do this if you are using the TIBCO DB2 JDBC driver.
  7. Enter the User Name and Password of the database server user account that ActiveMatrix BPM uses to connect to the ActiveMatrix BPM database.
  8. Click Test Connection.
    A Connection Passed message indicates that connection to the ActiveMatrix BPM database has succeeded.
  9. Click Save.
  10. In the Repository panel, select AMX-BPM Global Data Datasource and click Edit.
    The details of the JDBC data source that will be used to connect to the BDS case data store are displayed (with default ActiveMatrix BPM installation values).
  11. Repeat steps 4 to 9 to validate the connection to the BDS case data store.

Result

You can now use the AMX-BPM Statistics AdHoc dashboard to view reports about the Claims process.