when using the methode FILE.zip(connName,sourceConnName) in the FILE api, it is not possible to zip mutliple files on the root of the zip file (directory works) this would be helpful since specific systems ingest a zip file without subdirectories ...
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.
this would be greatly useful to have a method to get the number of rows returned by an ETL component, such as:
mySource=API.initSource("myExtract");
mySource.getRowCount();
As a Data Integrator, I want to see the previous runtime executions in the monitor after the job/load's name was modified and executed.
Currently, if I run the job/load, change the name, run it and check the previous execution (with the initial n...
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).
Currently, you cannot use add or update load mode for an excel file that resides in JedoxFiles. This means adding additional worksheets in an existing workbook is not possible. This should be enabled.
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...
Scheduler Job when copying from one instance to another
With the "Jedox Instance Synchronization" feature, users can copy information from one instance to another, including the scheduler. https://knowledgebase.jedox.com/jedox/maintenance/synchronization.htm After copying from the test environment to t...
Ability to store data in a constant table. It would be designed to store small amounts of data that you want cached for other processes in Integrator. Fields in Load: Data Source Target constant table (must be defined beforehand) Mode (add/delete/...
Retrieve information from parent node in JSON extract
When hierarchical data is retrieved from a REST endpoint, it's really cumbersome to get that data into a dimension. Imagine, your JSON data has the following hierarchy: Legal entity > Function Area > Cost Center Naturally you'd configure you...