Groovy Job

image_pdfimage_print

This job executes a script in the Groovy programming language. Groovy is a scripting language that is closely based on the Java syntax but also allows a simplified syntax. It is characterized by its dynamic typing, high execution speed, and good integration into the Java Virtual Machine.

Besides the various functionalities, Groovy (and Java) offers specific Jedox Integrator functionality via the Jedox Integrator Scripting API.

All standard Groovy functions are supported. Note that Groovy does not support any UI interactions, such as pop-ups.

Note: a script that is intended to be interruptible by Integrator Server must use Java’s sleep method, e.g. Thread.sleep(15000). For more information, see https://docs.oracle.com/javase/7/docs/api/java/lang/Thread.html#sleep(long)

Main settings

The main settings area provides a scripting window with syntax highlighting. Once you’ve entered your script, click Save on the toolbar. To check whether the script is valid, click Test. If your test results are good, then click Run to execute the script. The Integrator Monitor will show the results of the job:

Advanced settings

Fail on status: if the job executes several loads or sub-jobs, the selected option defines the behavior in case of a warning or an error message in one of the loads or sub-jobs. The options are described below:

none:

All subsequent loads or sub-jobs are executed. The job terminates with “Completed with warnings” or “Completed with errors”.

error:

In case of an error message, the job terminates without executing subsequent loads or sub-jobs with status “Failed”. (this was the behavior of a job until release 5.1).

warning:

In case of a warning message, the subsequent loads or sub-jobs are executed and the job terminates with status “Completed with warnings”.

Groovy scripts can also be used in Field Transform functions. For more information, see Groovy Functions.

image_pdfimage_print