Include "Column Exclude pattern" into Table View Transformation
Many times, a Table View Transformation is the final step of loading data into different sources. It would therefore be very handy to also have the Column Exclude/Include patterns in this transformation. This way, you don't have to define the whol...
When there's an error in one of the columns due to a wrong format or null values in some cells, the Excel Extract will not load and instead return an error. An option to either ignore the format of columns or ignore columns entirely, if they're no...
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 helpful to be able to add columns to an existing drillthrough database. Currently this is not possible. There is no control over the drillthrough database at all (only via ETL Load process). This is a pain once there are more colu...
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 ...
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.
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...
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...
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...
