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...
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...
It would be helpful if you could choose whether a CSV or Excel file should be created when exporting ETL DATA PREVIEW. As is the case when exporting drill-through data.
Scheduler - visualize like a calendar for a better overview
To organize the different tasks and have a good overview over open timeslots it would be helpfull to visualize each task in a calendar. (Just like organizing people in an outlook calendar or teams calendar.) One would be able to see whether a week...