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 ...
Dear Jedox, The log files have useable server statistics. i.e. user login, users opening reports, ect. please allow the jedox cloud integrator to access the Core.log.
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...
Jedox is using a customized Groovy implementation.
This does not contain all functionality of groovy!!!!!!
The documentation
https://knowledgebase.jedox.com/knowledgebase/job-groovy/
does not state a hint that not all native groovy function...
this would be greatly useful to have a method to get the number of rows returned by an ETL component, such as:
mySource=API.initSource("myExtract");
mySource.getRowCount();
This would be helpful to enable setting the target fields in a cube extract. When copying a slice to another one, I use a cube extract, then a fieldtransform where I put a constant. We could cut the FieldTransform if the target structure could be ...
using the following: source = API.initSource('myextract'); count = 0; while (source.nextRow()) { count++; } this would be great to have a method to get the rowcount directly, e.g.: count = source.rowCount(); if I want toto iterate over the source ...
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...