Executing Scripts
in Groovy Jobs
Database scripts can be generated and executed in Jedox Integrator with a Groovy job. Examples for the use of script functions and jobs can be found in the sample Jedox Integrator projects sampleGroovyOlap.xml, sampleGroovyFunction.xml, sampleGroovyJob.xml, and ETLTasks.xml.
Task | Interface | Example |
Generating script for a dimension | IDimensionScriptContext |
Copy
|
Generating script for a cube | ICubeScriptContext |
Copy
|
Generating script for a whole database | IDatabaseScriptContext |
Copy
|
Reading the variables and values of a given script | IScriptvariable |
Copy
|
Setting the variable values in a given script | IScriptvariable |
Copy
|
Executing a database script (with a given set of variable values) | IScriptHandler |
Copy
|
Within Integrator Groovy jobs and functions, a Java API (palojlib) – can be used by model builders. The Java API provides all functions necessary for establishing a connection to the In-Memory DB, retrieving data, and creating or modifying database contents.
An overview and documentation of all functions provided in the Jedox Java API can be found in the Java API Documentation, which is available online or as a download.
Updated April 14, 2025