Configure the Process Data Mart

To configure the process data mart, create a process data mart database business end point:

  1. In the left pane of the Process Administrator, click Service Endpoints.

  2. On the Business End Points page, click Add.

  3. On the Service Endpoints | Add Service Endpoint page, enter a Name for the process data mart database, such as DataMartDB.

  4. In the Type drop-down list, select SQL Database.

  5. In the Subtype drop-down list, select the JDBC connector type for the process data mart database. The JDBC selected must be installed on the computer that hosts the SQL database where the process data mart database will be created.

  6. Click Next.

  7. On the Service Endpoints | Add Service Endpoint | Edit Service Endpoint page, enter the configuration Properties for the process data mart database. The configuration properties will vary based on the type of JDBC selected. For an explanation of the properties required for each type of JDBC, refer to the Required Parameters for Configuration of SQL Database Service Endpoints.

  8. Configure the Runtime options or accept the default settings.

  9. Click Save.

Then configure the process data mart settings:

  1. In the left pane of Process Administrator, click Process Monitoring.

  2. On the Process Data Mart page, Process Data Mart tab, configure the process data mart Properties:

Property

Description

Enable Automatic Update

Sets the data mart updater to run automatically at the time specified in the Daily Update Time field. If this option is not selected, a manual update can be performed from the ptprocess\1.5\bin folder using fuegowarehouse.bat.

Runtime Database Configuration

The process data mart database. The process data mart database must be configured as a SQL Database business end point before it will appear in this drop-down list.

Data Detail Level

Specifies the granularity of the data that is transferred from the process execution engines to the data mart. If set to Hourly, data (instances) will be available to be retrieved for particular hours of a given day. If set to Daily, data can be retrieved for particular days.

Snapshot Time

The time at which the workload snapshots are taken. If the data detail level is set to hourly, only the minutes portion of the time is used and twenty-four snapshots will be taken, one for each hour of the day. If the data detail level is set to daily, only one snapshot is taken each day at the snapshot time.

Daily Update Time

The time at which the process data mart updater will run each day and migrate events from the process execution engines to the data mart database.

Log Directory

Log messages from the process data mart updater will be written to the dwupdater-service.log file in this directory. This directory must exist in order for the log file to be created by the process data mart updater.  The verbosity level can be set by configuring the wrapper.logfile.loglevel property in \conf\WarehouseService.conf. Acceptable values are: NONE, INFO, and DEBUG.

Messages Logged from Data Mart Updater

The minimum severity level required for messages to be included in the process data mart updater log.

Language

The language used for descriptions of objects such as processes and activities.

Generate Performance Metrics

Updates the process performance data when the process data mart updater is run automatically.

Generate Workload Metrics

Updates the workload data when the process data mart updater is run automatically.

  1. Click Save.

  2. Click Manage Database.

  3. On the Process Data Mart | Manage Database page, select the Create Database checkbox.

  4. Select the Create Data Structure checkbox.

  5. Enter a User Name and User Password with administrative write privileges for the host engine.

  6. Click OK.

  7. At the top of the Process Data Mart page, the Message(s) section should contain the following confirmation messages:

    1. To verify the creation of the database and data structure, check the host engine to see if the new database is there.

Then install the data warehouse Process Monitoring service on the host computer for Process or BPM:

  1. In the command prompt, change to the directory containing the albpmwarehouse.bat file that was included during installation.

  1.  In the correct directory, type:

albpmwarehouse.bat install

Note that the JAVA_HOME environment variable must be set.

  1. In the Windows Services utility, start the data warehouse Process Monitoring service.

Note: Changes to the Process Data Mart and BAM configurations will only take effect if you stop and re-start the data warehouse Process Monitoring service.

Note: Installation of this service is not required for Unix. Start the service to use the Process Data Mart and BAM configurations. The Unix parameters for this service are: ./albpmwarehouse.sh { start | stop | dump }

Related Topics: