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...
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.
there is no possibility to set the default right for ETL Projects like a modeler.
We would like to hide ETL projects as default settings.
And then, we would like to be able to display projects only for explicitly authorized user groups.
Setting variables via source like Extract, FieldTransform etc
It is only possible to set variables dynamically without Groovy when using Loop-Jobs (more or lesse misusing them). Downside of this is that it will not work with Data Preview.It would be great to have a) a variable setting integrator component (V...
Option for automatical restart of ETL jobs after the server went down or restarts
Scenario:There is a long running ETL job and the Jedox server or part of services went down or "crashes". After the (re-)start of the components/services the ETL jobs are marked as failed or aborted. Here there is need for a feature or a new optio...
the basic idea comes from a forgotten filter in the table view. Flagging or highlighting components in the graph could help to visually perceive open changes/adjustments so that they are not forgotten. in the attached screenshot you can find a qui...
Check user permissions before execution of Integrator job
When executing an Integrator job with limited user permissions in a database, it could happen that the job does not complete successfully due to missing permissions of the user. If in that case some write actions were already executed and others a...
New connection type to AWS , GCP in the Integrator
Major clouds have Amazon Web Services(AWS) Microsoft Azure(Azure) Google Cloud Platform(GCP) Currently Jedox Integrator only have Azure connection. Similar to Azure, a new connection type to AWS(S3 etc) , GCP should be offered.
Integrate Jedox ETL with OCR tools (like Echovera) to capture/convert image to text tables and use it for importing to Jedox database. Scenario : Ability to import scanned copies of Vendor Statements or Bank statements to Jedox using Intelligent O...
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/...