Currently the groovy function editor is not reflecting the high maturity which Jedox Integrator has reached now. You cannot even resize it if you have to develop a more extended logic. More real-time validation of the code and debugging support wo...
When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
...
Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
==>
It would be great to jus...
Copy function from a Field Transform component to another one
In the integrator > field transform, i would like to use the same function for several different transforms. More specifically, i'm using a map and I'd like to use the same map in other transforms without retyping it (or updating it individually).
Load multiple Excel files from a directory with one connection and extract (like CSV Files).
Load multiple Excel files from a directory with one connection and extract (like CSV Files). Basically the same structure like creating a file extract using a folder-connection. But also working with Excel files :)
It would be great to be able to delete a complete job with its dependencies. Maybe with an option to prevent the deletion of the component that are used elsewhere. For instance:
Connection1 => Extract1 => Transform1 => Transform2 =>...
if you copy elements out of one project by dependencies and insert them in an other project. Jedox give you the feedback if there are elements with the same name in the second project and ask you to replace them. It would be great if Jedox show me...