Knowledge Base

Analyzing Execution Details

After the execution of an Integrator (ETL) job or load, the following essential runtime information is displayed in the monitor of Jedox Integrator:

Execution ID

Start time

Duration

Status

Log messages

More detailed information at the component level (i.e., extracts, transforms, loads) can be obtained through execution detail monitoring. This can be helpful for performance analysis of complex Integrator jobs.

The execution detail monitoring has to be activated first by setting the parameter “#persistDetails” in file .\tomcat\webapps\etlserver\config to “true”.

Note: the analysis of execution details is currently only available via the Jedox Integrator Command Line Client (CLI). For a forthcoming release, it will also be integrated in the Jedox Integrator.

The runtime data can be returned either in tabular or graphical form, as outlined below.

Execution details in tabular form

A CSV file can be generated, with additional runtime information on the execution of each component (using “;” as delimiter). The following information is available:

Component name

Runtime in seconds

Runtime in % of total runtime

Number of input calls

Number of output calls

Number of input rows

Number of output rows

For extracts, the number of input calls and rows is always 0. For loads, the number of output calls and rows is always 0.

Notation:

etlclient -ed <executionid> -o <filename>

Execution details in graphical form

A flow graph of the Integrator project can be generated with additional runtime information on the execution for each component. This SVG (Scalable Vector Graphics) file can be opened with any browser.

Available information:

Component name

Runtime in seconds

Number of calls

Number of rows

For extracts, the number of calls and rows signifies the number of output rows. For transforms the number of calls and rows signifies the number of input rows.

Examples

1. Write the execution details of execution ID 123 in tabular form to file ExecutionDetails_123.csv

etlclient -ed 123 -o ExecutionDetails_123.csv

2. Write the execution details of execution ID123 in graphical form to file ExecutionDetails_123.svg