Integrator Configuration

The configuration file for Integrator is located at /tomcat/webapps/etlserver/config/config.xml (Windows) or /opt/jedox/ps/tomcat-etl/webapps/etlserver/config/config.xml (Linux). The parameters for configuration are described below. After making any changes to the file, the Tomcat service must be restarted.

Settings for "config.xml" file

Parameter	Description of parameter value	Default value	Type
logFileSize	Maximum size of one etlserver log file in bytes, KB, MB, or GB	10MB	string
logBackupIndex	Maximum number of etlserver log files to keep	20	integer
maxParallelWriteExecutions1 Write executions are those that may change data in the target system, such as starting a load or a job.	Maximum number of parallel running integrator jobs or loads	5	integer
maxParallelReadExecutions2 Read executions normally only read data from source systems and don't change data in target systems. Examples: data preview, function preview, tests, drillthrough, metadata, column output.	Maximum number of parallel running Integrator executions	7	integer
maxParallelSubExecution	Maximum number of parallel subexecutions inside of a parallel execution	5	integer
maxQueuedExecutions	Maximum number of executions that can be queued	42	integer
removalSchedule	Period (in hours) between two cleanup runs	24	integer
removalDelay	Delay (in seconds) before cleanup is executed	30	integer
removeWriteExecutions3 Write executions are those that may change data in the target system, such as starting a load or a job.	Time (in hours) after which old job and load executions are removed from the Integrator monitor for every scheduled cleanup operation defined by removalSchedule parameter	336 (14 days) *	integer
removeReadExecutions4 Read executions normally only read data from source systems and don't change data in target systems. Examples: data preview, function preview, tests, drillthrough, metadata, column output.	Time (in hours) after which old executions are removed from the Integrator monitor for every scheduled cleanup operation defined by removalSchedule parameter	48 (2 days)**	integer
removeTempExecutions	Time (in hours) after which temporary executions are removed from the Integrator monitor for every scheduled cleanup operation defined by removalSchedule parameter	1	integer

*in Jedox version 2019.3, the default setting was 720 (30 days)
**in Jedox version 2019.3, the default setting was 168 (7 days)

It is also possible to configure some settings for the Integrator UI in the Jedox Web. In Windows you can do this in the ./tomcat/webapps/rpc/WEB-INF/classes/etl-mngr.properties file, and in Linux you can do it in the ./tomcat-rpc/webapps/rpc/WEB-INF/classes/etl-mng.properties. In this file, entries are made in the format parameter=value. After making any changes to the file, the Tomcat service must be restarted. The various configurations are described below.

Configuration for the Integrator UI

Parameter	Description of parameter value	Default value	Type
testServerTimeout	The timeout for execution of "Test" of a component or project, in seconds	60	Integer
dataPreviewServerTimeout	The timeout for retrieving data in a Data Preview, in seconds	300	Integer
dataPreviewLinesInitial	The number of lines initially shown in a Data Preview	20	Integer
dataPreviewLinesMaximum	The maximum number of lines allowed in a Data Preview	5000	Integer
execLogPageSize	The number of lines shown in the execution monitor for a page in a single execution	200	Integer

Updated September 27, 2022