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...
Loads with insertParallel on sub-trees (boundaries)
If one uses a load with insertParallel mode, the ETL will unconsolidate duplicates of elements in every Top-Element. This behavior is documented but not always wanted - sometimes you only want to load a certain Top Element (Tree) to be loaded with...
Only calculate dependent functions / inputs in a field transform / treeElement transform data preview on function level
When re-using Field Transforms you often need to update functions however the preview of a single function will not work until every transform function is correctly updated otherwise it throws an error for a function you intended to fix later. The...
Keep source structure / types when reading a file, so that decimals etc are not changed (same for reading via SQL)
When you extract a file via integrator (i.e. Excel workbook) it doesn't keep the source formatting and requires you to use an extract and transform to get the numbers back to their original format. The suggestion would be to add a checkbox to an e...
Implementation of Token-Based Authentication for JDBC connection
The customer would like to use Token-Based Authentication for JDBC connection (NetSuite in this case) in addition to the User name and Password currently supported. As per Knowledge Base article https://knowledgebase.jedox.com/integration/connecti...
Create a new Load type to write custom messages to log files.
Create a new load type that allows writing to log files custom messages. Currently possible with LOG.info and a groovy script job. It would be better if groovy jobs were not required.
Integrator function to import/export a file into Designer
Jedox Integrator needs a function/load to take a file from another datasource (local neetwork drive, FTP, OneDrive, Sharepoint, etc) and load to Filemanager (Designer). Ot should be able to do the reverse as well (ie export).
Possibility to restore old versions in the designer / integrator
If you work on a report or an integrator project and save it, you realize that you would like to restore your version from 1 day / 1 hour ago. An automated possibility for that would be great. Otherwise we always need to store our projects / desig...