A Jedox Integrator process is executed via a job, which is the last step in the Integrator process. Jobs can be managed in the Integrator UI and can also be run with an Excel macro via OData.
Only jobs of type "Parallel" are executed without sequential queuing. If an Integrator job is running, execution of any subsequent job requests depend on the type of job(s):
- If both the job that is running and the subsequent execution are of type parallel, Integrator will process the new execution request concurrently, as long as the system has sufficient resources.
- If either the job that is running or the subsequent execution are of any type other than Parallel, the execution of jobs will be sequential, i.e. new executions will commence only after any jobs already running have completed.
Every job of some other type (e.g. Groovy or switch) can be parallelized by simply creating new parallel job and adding the other job(s) to it. Also, a parallel access to Microsoft Access DB is not possible due to restrictions of Microsoft Access Driver.
| External | Executes jobs from another Integrator project as a sub-job, splitting Integrator logic into several projects and executing them together in one central job. |
| Groovy | Executes a script in the Groovy programming language. |
| JavaScript | Executes a script in the JavaScript programming language. |
| Loop |
Performs multiple processing of another parameter-dependent load or job with differing variables. Can also be used to set variables dynamically for a load or a job. |
| LoopParallel | Runs a loop in which all subjobs are executed in parallel. |
| Parallel | Executes several loads or jobs simultaneously. |
| Standard | Executes several loads consecutively. May also contain and combine other jobs that are executed as sub-jobs. |
| Switch |
Builds an execution chain based on conditions. |
For more information on the execution states, see Integrator Execution status codes.
Updated December 9, 2024