jdbc

This configuration is an example of a process merge based on sort order in PPM.

Scenario

A list of events is extracted from a source system using JDBC Extractor. The appearance of the events depends on the system event specification of the extractor. In each event, the process step is described by the STEPTBL-CHANGEDESC attribute. In addition, each system event knows its own order relation (ORDERTBL-ORDERNO), its execution time, its processor and the customer who placed the order (see example data in data/jdbc/JDBC_ORACLE_Data.xml).

The process steps are to be merged to form a process in PPM, sorted by the order number and execution time.

Solution

Installation:

  1. Prerequisite: JDBC Extractor must be installed.
  2. Use this configuration to create a new PPM client.
  3. For details on how to install the JDBC example data source system, refer to the instructions in the readme.txt file stored under <installation directory>\ppmmashzone\server\bin\agentLocalRepo\.unpacked\ppm-client-run-prod-<version>-runnable.zip\ppm\ctk\ctk\examples\custom\jdbc\dump.