Search for "name"/"description" within Jedox Integrator
Currently, a new user can have issues in finding specific ETL components, because he has to work backwards from Jobs to Loads to Transforms and try to find the relevant pieces. An easy solution would be to add a "Search" functionality to the main ...
Customizable Naming Conventions for Integrator Projects
Currently, when creating a new Extract within the Integrator, the system automatically generates a default name, such as "New Excel Extract." However, given the varying preferences of consultants, it would be beneficial to offer users the option t...
It would be very useful to have the possibility to instead of only find, to have a find and replace option. Then users could edit things faster and help them spend less time in the editor. The alternative is to copy the text in some other editor. ...
At one of our prospects, we ran into a requirement, where prospect files are located in Google Drive. Since cloud solutions are spreading, it will be a more and more frequent required functionality to access these cloud-based file servers. If it i...
Increase the size of some ETL- input fields for better handling and input
Please increase the size of some ETL- input fields, where many characters can be entered.For instance: logical expression fields; json template in JSON connections, etc.The current size is error-prone and inconvenient.
change variable default in overview & exporting/importing the variables
It would be great to be able to change the default of a variable in the overview of all existing variables instead of having to to click/open every single variable to make changes. In addition it could be useful to change the description here as w...
When loading data into relational database, the Jedox ETL commit the data every 1000 records by default, and it's not possible to change the commit size to "unlimited".
Therefore, if the data loading was failed at the middle of the execution, the ...
Enable Integrator "RScript" transform to manipulate and generate well formated XLSX reports
We would like to use "openxlsx2" or "xlsx" or any other similar "R" package to generate well formatted Excel files, expected by customers, from Integrator "RScript" transform . We expect, we will be able, among other things, too : - create workboo...
When creating a json extract the different column names can be defined. This would be great that it does not have to be defined manually but dynamically, I see 2 possibilities: 1/ getting the column list from another extract or transform 2/ have a...
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...
