Multiselecting rows in ETL transforms to delete or sort up/down (no XML)
Sometimes when we work in the Field Transform or Table view, Target columns could have a large number of rows. IT would be useful if we could multi-select them (on shift perhaps) and then delete them or move them without the need to use XML view.
Only calculate dependent functions / inputs in a field transform / treeElement transform data preview on function level
When re-using Field Transforms you often need to update functions however the preview of a single function will not work until every transform function is correctly updated otherwise it throws an error for a function you intended to fix later. The...
Keep source structure / types when reading a file, so that decimals etc are not changed (same for reading via SQL)
When you extract a file via integrator (i.e. Excel workbook) it doesn't keep the source formatting and requires you to use an extract and transform to get the numbers back to their original format. The suggestion would be to add a checkbox to an e...
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...
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...
Add UpdateRuleTemplates Option to Cube Load Settings
Instead of having to add a separate JedoxDatabase load to jobs involving Jedox Cubes, add this option to the main settings fields in the Cube load. I have many times run jobs that update data to Jedox Cubes where I forgot to manually update rule t...
Only stop the services when no Integrator job is running
We have implemented on our own systems that the restart of the services, which is carried out during the backup, only takes place when an ETL job is no longer running. This is also necessary for the cloud.
It's necessary to have an option of Partial Reload in the Integrator Qlik Load. Qlik Sense supports it. And it saves a lot of time during data sinchronization between Jedox and Qlik.
The Database name are usually used as reference with apps. In case that a Database is renamed all these references stop working. In our solution design we use the ID from Metadata to ensure that we always have the correct database as reference (it...