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.
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();
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...
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...
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...
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...
Expand column aggregation to include more than 2 column inputs
It would be great to be able to add additional columns in the Column Aggregation Transformation Function so the aggregation can be calculated based on the unique dimension elements from another column. Currently, it allows max two columns but woul...
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/...