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
Configuration of the data source in terms of system access and data extraction (definition of system events).
Extraction of data from the system specified in the data source.
Event import of extracted data with order-based merge.
A single process fragment definition is used and the names of the steps are copied from the system event data.
Fixed process type definition with predefined process type group/process type in the attribute copy rules.
Installation:
Prerequisite: JDBC Extractor must be installed.
Use this configuration to create a new PPM client.
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.