Source database specific arguments

-datasource <file name> (optional)

Specify the data source you want to use for the extraction. The XML file contains specifications of all files to be used for extraction and XML output. Make sure that you use this parameter instead of and not in combination with the -datasourcelist, -systemconfig, -tableconfig, -calcconfig, -outfile, or -nozip parameters.

-datasourcelist <file name>

Multiple data sources can be extracted simultaneously by means of the -datasourcelist argument. This corresponds to multiple consecutive extraction using the -datasource argument. Only JDBC data sources are extracted.

See chapter Extract multiple data sources.

-systemconfig <filename> <configname>

This is where you specify the name of the XML file containing the system configuration. The content of the file is source database-specific and can contain several configurations. The name of the configuration to be used is specified in the second argument. If the XML file contains only one configuration, this is used automatically. In this case you do not need to specify a configuration name.

-tableconfig <file name> <config name>

This is where you specify the name of the XML file containing the table configuration. The content of the file is source database-specific. The file must contain all table configurations specified in the table configurations. The name of the table configuration is specified in the second argument. If the XML file contains only one configuration, this is used automatically. In this case you do not need to specify a configuration name.

-calcconfig <file name> (optional)

This is where you specify the name of the XML file with which you can change attributes of the XML output file or add attributes including attribute calculations.

-begindate <dd.mm.yyyy> (optional)

This is where you specify the date from which data is to be extracted from the source database. If you do not use this parameter, the value of the lastreaddate XML attribute from the specified system configuration or data source is used. The yyyymmdd format is supported.

-begintime <hh:mm:ss> (optional)

Specify the time from which data is to be extracted from the source system. If you do not use this parameter and -begindate, the value of the lastreadtime XML attribute from the specified system configuration or data source is used. If you do not use the parameter but you do use -begindate, the default value 000000 is set.

-enddate <dd.mm.yyyy> (optional)

This is where you specify the date up to which data is to be extracted from the source database. If you do not use this parameter, the current date is used. The yyyymmdd format is supported.

-endtime <hh:mm:ss> (optional)

This is where you specify the time up to which data is to be extracted from the source database. If you do not use the parameter but use
-enddate, 235959 is set as the default value. If you use neither this parameter nor -enddate, the current time is used.

If PPM Process Extractor JDBC-2-PPM is started without specifying a period of time, the start time is extracted from the specified configuration file. The current date and time are used as the end time.

-valueconstraint <parameter1> ... <parameter4> (optional)

Use this parameter to delimit the data volume to be extracted using an integer criterion. The "<", "<=", ">" and ">=" comparison operators are allowed. You can compare the corresponding field value with one or two (interval) values. If a last extracted value (lastreadvalue) has already been saved in the system configuration or data source, you can also use this value for the comparison (see chapter Continuous automated extraction).

Examples

-valueconstraint 25000020 "<="

Only data records are extracted whose integer value for the field specified in the event specification is smaller than or equal to the value 25000020.


-valueconstraint 15000020 ">" 25000020 "<"

Interval: Only data records are extracted whose integer value for the field specified in the event specification is smaller than the value 25000020 and greater than the value 15000020.

-save_value_minimum (optional)

Use this parameter to specify that with -valueconstraint, the smallest value last read is saved as lastreadvalue in the configuration file used (system configuration or data source) when extracting with restrictions. Default value: Saving the largest value

-cpd <int> (optional)

This parameter is used to specify the number of system events to be extracted simultaneously (concurrently processed documents). The specified value gradually extracts the primary key fields from the table referenced using the doctable XML element in the table configuration, and stores them in the extractor's Java memory. Specifying a higher value results in improved extraction performance and more efficient memory usage.
If you do not specify the parameter, the recommended default value of 20000 is used.

-ping (optional)

This parameter is used to test the connection to the specified source database. No data is extracted.

-removeempty (optional)

You use this parameter to remove extracted attributes with no values before the attribute transformation.