Add Python Code Module to Integrator similar to R-Code Module
Python is our typical scripting language. It would be beneficial if we could use our skills also in Jedox or if we could copy code from other systems to Jedox.
when writing macros or script code in ETL it is often difficult to find out what went wrong and when it went wrong.
The only way at the moment is to scan the log files for error messages.
For development it would be helpfull to have a debug mode ...
Similar to SAP, a new connection type to DATEV should be offered, ideally with pre-built extract types, to be able to quickly generate master and transactional data in Jedox.
Jedox integrator - Same features for "Insert columns" as in Extract
Currently, only in the "Extract" elements within Jedox Integrator the "Insert column" feature has very good functionality. You can select all elements, deselect all or just select certain columns into your Extract. But within the "Transform" eleme...
XML editor - option to show all code of the ETL process
Currently the XML editor is limited in functionality: Find and replace is missing (there is a separate idea for this: JS-I-1557) The XML editor can only show the currently selected ETL element, e.g. job, transform Solution: Have a drop-down in the...
Bring back addFileNameColumn in directory/ file extract
As of Version 23.4 the distinct directory extract has been deprecated in favour of the option to select to extract either a single file or a directory within the file extracts. While doing this the addFileNameColumn option of the directory extract...
Roll-back of write actions when execution of Integrator job fails
When executing an Integrator job that writes data to a database with limited user permissions in that database, it could happen that the job does not complete successfully because some write actions fail (due to missing permissions of the user). I...
No distinction between uppercase and lowercase in the integrator
At the moment, Jedox differentiates between uppercase and lowercase in the integrator and treats the elements like two different ones. Example: RepUnit <> REPUNIT -> Table normalization, lookups etc. won't work properly as Jedox raises th...
The Project box is not wide enough to show the full project names
The dropdown list in the 'Project' box is not wide enough to display the full project names.
This limitation can pose challenges for users in identifying the correct project to choose, especially for a long project name; for example, a project...
Possibility to add the separator for aggregation type -> group concatenation. It could be ,.;[]#XX!, etc. Currently, the separator by default is coma ",". Sometimes we need to do a step after where we split things in columns based on the separa...