Integrator

Sometimes you need to have a list of values to iterate on, for instance in a loop job. A constant table is used for this purpose. This would be great to be able to populate a constant table with variable values (like an array), coming from a diffe...

I would like to propose a connector to Azure Synapse database

Currently the powerbi integrator can only create 1 table in a dataview, making it essentially useless. Even though API-PUSH datasets are difficult to work with, if you at least had the ability for multiple tables, and some control/setting of the d...

add a method in ETL Scripting API to get the session id of a jedox olap connection

For backuping the databases we use a custom Groovy script, but currently this won't support custom classess such as Amazon S3. Maybe it is good to include the posibility to make the use custom classess who easily could be import via the import c...

Today, many different technical fields are needed for creating hierarchies in Dimensions. As Jedox needs a unique element for different consolidations in hierarchies, I find it often to be the case to have a lot of fields just for that purpose. Su...

SQL Query Designer with UI that generates SQL from clicks, e.g. Query Builder as in MS Access + Editor with Syntax highlighting for SQL. #6396

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 ...

when writing macros or script code in ETL it is often difficult to find out what went wrong and when it went wrong. The only way at the moment is to scan the log files for error messages. For development it would be helpfull to have a debug mode ...

As I have been informed by Jedox Dev team, the ETL-Server (Tomcat Service) is running one job per CPU core. This behaviour is mainly slowing down our ETL projects since a huge amount of data has to be proceeded. The number of cores that should be ...