In this section, we will create a bridge between OSWorkflow and Pentaho BI. By using the OSWorkflow Workflow instance database as a data source in Pentaho, we'll have all this process information available for reporting and charting, thereby allowing us to spot trends and monitor the business process visually.

Remember that the Pentaho integrated distribution we downloaded is based on the JBoss application server. Well, this enables us to define a JBoss data source that Pentaho can use to access the OSWorkflow database.

The following XML is the data source definition file for JBoss; the file can have any name as long as it ends with the -ds suffix and has the XML extension. For example, osworkflow-ds.xml is a suitable name. This file must be placed in the deploy directory of the Pentaho JBoss server.

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>solution1</jndi-name>...