Persisting entities with the Batch Activity Dashboard application

The sample Batch Activity Dashboard application allows you to run batch jobs, including persistence jobs, within an IBM Business Process Manager (BPM) environment.

The Batch Activity Dashboard application is a Web-based UI that runs within BPM. It provides a graphical user interface for the InfoSphere MDM batch processor.

The Batch Activity Dashboard enables users to view, create, and manage batch activities and their associated jobs, including persistence jobs (Persist Entities (multiple entity types) and Persist Entities (single entity type)).

Consider the following as you complete the fields in the Batch Activity Dashboard:

Input type: For hybrid MDM, you can choose SQL Override, CSV File, or Task Parameter depending on the type of input you are providing to the batch job.

Input value

This is the input definition. For hybrid MDM, to generate the CSV file for initial load, you can use the “Register Virtual Entities for Physical MDM” job in the InfoSphere® MDM Workbench. By default, the output directory for the Register Virtual Entities for Physical MDM job is MAD_ROOTDIR/entityRegistration.

For CSV files, provide an absolute or relative path, from $home/input where $home is the home folder of the batch instance to run the job. It is where the batch instance is installed. Be sure to include the file extension.

For SQL overrides, provide a SQL SELECT statement.

For Task Parameters, provide the SQLPrefix, TaskParameters, and SQLSuffix definition.

Ensure that the file format is correct. For a single entity type, the CSV or SQL SELECT file must include column titles in the first row, and the column titles must match ENTITY_ID:

ENTITY_ID
1
2
3
4

For multiple entity types, the CSV or SQL SELECT file must include column titles in the first row, and the column titles must match ENTITY_ID, ENTITY_TYPE:

ENTITY_ID,ENTITY_TYPE
1,mdmper
2,mdmper
3,mdmper
4,mdmper
1001,mdmorg
1002,mdmorg
1003,mdmorg
1004,mdmorg

Extension properties: The base name of the extension batch properties file. For example, if the file name is batch_extension.properties, use batch_extension. You can use this optional file to customize the batch behavior.