Architecture

The figure below illustrates the functionality of PPM Process Extractor JDBC-2-PPM:

s_jdbc_4_abb_dat_extr_xml_ausgabe

The JDBC driver is used to create a connection to the SQL source database with the access data for the JDBC system configuration. Data is then extracted from the tables in the source database system using the JDBC table configuration and an optional transformation using the data extraction module and is written to an XML file in a PPM-compatible output format.

You need to ensure that the specified source system user has appropriate access authorization to extract the relevant data fields.