When the BPM Engine is configured for persistence, general information about all Business Processes running on the engine is stored in the database. You can store and monitor additional information about a Business Process by configuring it for reporting persistence. You need to configure reporting persistence for each Business Process individually; the detailed information is only stored for those processes that are configured for it. This information can be accessed from the Enterprise Manager.
When you configure a Business Process for reporting persistence, a database script is generated that creates one database table for the Business Process. This table is populated with data from attributes of the WSD Object that are simple types (such as strings, integers, and so on). Data corresponding to complex attributes is not persisted, and a Business Process must include at least one simple attribute in order to be configured for persistence.
After you create your Business Processes, perform the following steps for each Business Process you want to enable for reporting persistence.
Scripts are also provided for you to uninstall the database components created for a Business Process.
Reporting persistence for a Business Process is configured in the properties of the Business Process.
In the Project Explorer of NetBeans, right-click the Business Process and then click Properties.
On the General page of the Business Process Properties window, select Yes for the Persistence for Reporting option.
Repeat the above step for each Business Process you want to configure for reporting persistence.
Select Save All.
A folder named Database Scripts appears under the Business Process.
In order to connect with the database to run the scripts, you need to specify the database connection information for the scripts.
Right-click the Database Scripts folder under the Business Process, and then click Properties.
Enter the properties.
Click OK.
Once you configure the database connection information, you can run the database script. This procedure creates the table required for reporting on the Business Process. The name of the table created is unique to each Business Process, and begins with the first few characters of the Business Process name followed by a series of numbers and a version number.
Before you can perform this step, the monitoring and recovery database must be created and running. The BPM Engine must be configured for persistence in order for information to be stored in the Business Process table. Both of these procedures are described earlier in this chapter.
In the Project Explorer, expand the Business Process.
Expand the Database Scripts folder.
From the Database Scripts folder, right-click the database install file appropriate to your database vendor, and then click Run.
BPM provides a simple way to uninstall the database tables created by the Business Process database installation script.