Sending exception sets to IBM BPM processes

To use your own IBM® BPM processes to manage exception sets, you must configure Data Quality Exception Console to send exception sets to your processes.

Before you begin

About this task

Your IBM BPM processes are notified when a user of Data Quality Exception Console chooses to manage new exception sets with IBM Stewardship Center. Then, you use Subscription Manager to update the subscription that was configured by default to send all exception sets to Data Quality Exception sample process application in IBM Stewardship Center.

Procedure

  1. Define a descriptive name for each IBM BPM process. You use this name when you register a callback and create subscriptions.
  2. Register a callback to each IBM BPM process. Specify the following values.
    Table 1. Parameter values for the istool event registerCallback command
    Parameter Value
    -authentication parameters The user name and password for the computer where IBM BPM is installed.
    -eventTypeName NEW_MANAGED_SET_EVENT
    -callbackType HTTP_POST
    -callbackName The name that you define for your IBM BPM process.
    -callbackDescription The description that you define to identify your process.
    -callbackService The URL to your IBM Stewardship Center sample process. Use the format:
    https://<bpm_server>:<SSL_port>/rest/bpm/wle/v1/service/<BPM_process_application_acronym>
    @<service>?action=start
    Where:
    <BPM_process_application_acronym>
    The acronym for your IBM BPM process.
    <service>
    Name of the service in the IBM BPM process that is accessible by URL.
    For example, if you define the name for your IBM BPM process as DataStage_exception_workflow, you might run the following command:

    event registerCallback -eventTypeName "NEW_MANAGED_SET_EVENT" -callbackType "HTTP_POST" -callbackName "DQ_workflow" -callbackDescription "When a NEW_MANAGED_SET_EVENT occurs, this callback is invoked to send the exception set to DataStage_exception_workflow."-callbackService "https://my_bpm_server.com:9443/rest/bpm/wle/v1/service/DQWKFLW?@StartProcess?action=start" -u isadmin -p infsv123pwd

  3. To specify which exception sets are sent to which IBM BPM process, create new subscriptions with event filters.
    1. Specify the following values for each subscription.
      Table 2. Properties of a NEW_MANAGED_SET_EVENT subscription
      Subscription properties Values
      Name A descriptive name for your subscription, for example, DQ_workflow.
      Event Type NEW_MANAGED_SET_EVENT
      Notification Type Application
      Application

      The descriptive name that you defined for your IBM BPM process. This name is also the value that you specified on the –callbackName parameter when you registered the callback.

      To send exception sets to the Data Quality Exception sample process application, select IBM Stewardship Center - Data Quality Exception.

      Application user name The IBM BPM cell admin ID.
      Application password The password for the IBM BPM user that you specified in the Application Username property.
    2. Specify values for the event filters to limit which exception sets are sent to which IBM BPM process in IBM Stewardship Center. You can filter by application, project, InfoSphere Information Analyzer, or data rule. You can use the following event filters.
      Table 3. Event filters to limit exception sets
      Event filters Valid values
      applicationType
      • Information Analyzer
      • Exception Stage

      Type the strings exactly as they appear here. The filter is case sensitive.

      projectName
      • IA_project_name
      • DS_project_name, for example, IOD_Bank_Demo
      .
      exceptionSummaryName
      • If you specify Information Analyzer for applicationType, specify the name of a data rule in the project.
      • If you specify Exception Stage for applicationType, specify the name of an exception descriptor in an Exceptions stage in the project.

      Your subscription includes selected event types that occur in any stage of any job of the specified project, where the stage contains an exception descriptor of the specified name. To limit the subscription to events from a single stage, define a unique name for the exception descriptor in that stage.

    When a user of Data Quality Exception Console selects an exception set and clicks Manage, the exception set is sent to the appropriate IBM BPM process, depending on the filters that you specify in your subscription.
  4. If you do not want exception sets sent to a specific IBM BPM process, delete the NEW_MANAGED_SET_EVENT subscription for that process. For example, the subscription for the default Data Quality Exception sample process application has the following properties:
    Table 4. Properties of the subscription to send all exception sets
    Property Value
    Name NEW_MANAGED_SET_EVENT/<Unique_ID>
    Event type NEW_MANAGED_SET_EVENT
    Application IBM Stewardship Center - Data Quality Exception
    Event filters None
  5. To restore the default configuration so that all exception sets are sent, delete all subscriptions for the event type NEW_MANAGED_SET_EVENT. Create a subscription and specify the properties in Table 4. Do not specify filter properties for this subscription.

Example

A data steward manager wants to manage exception sets that are generated by InfoSphere Information Analyzer by using Data Quality Exception sample process application. The administrator wants to manage exceptions sets that are generated by the InfoSphere DataStage® project IOD_Bank_Demo by using the IBM BPM process, DataStage_exception_workflow.

On the Subscriptions tab of Subscription Manager, the administrator deletes the subscription to the Data Quality Exception sample process application that is created by default.

Next, the administrator creates two subscriptions. Both subscriptions define NEW_MANAGED_SET_EVENT as the event type and Application as the form of notification.

For the first subscription, the administrator specifies IBM Stewardship Center - Data Quality Exception as the application. Events are filtered by using the applicationType property to specify that the subscription is for only those exception events from InfoSphere Information Analyzer. With this subscription, only exceptions that are generated by InfoSphere Information Analyzer are sent to the Data Quality Exception sample process application.

For the second subscription, the administrator specifies DataStage_exception_workflow as the application. Events are filtered by using the projectName property to specify that the subscription is for only those exception events from the project IOD_Bank_Demo. With this subscription, only exception sets that are generated by the IOD_Bank_Demo project are sent to the DataStage_exception_workflow process application. Exceptions that are generated by other InfoSphere DataStage projects are ignored and are not sent to IBM Stewardship Center.