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 just define such formulas directly in the variables section of the ETL project.
Right now you would need a separate groovy job for this which is too much overhead for this simple task
and creates unnecessary complexity within the flowchart / ETL process.15 votes
The main idea is to integrate splashing function ( COPY, LIKE ... ) directly in the integrator manager using groovy job or anything else.7 votes
We are working on a new load type that will specifically allow “copy” and “like” operations.
When loading data in high volume and in high frequency, the cube transaction logs are "exploding" in terms of size. As this data is loaded from external source, the transaction logging would not be necessary: data can be always restored from original data source by simple reloading data.
In order to avoid gigantic log files, the transaction logging should be possible to turn off temporarily during the ETL load. Similar property is in IBM Cognos TM1 and helps a lot when dealing with log files.9 votes
Posibility to change the layout in the Integrator back to the list-view (like it was before jedox 6 SR3)
Since Jedox 6 SR3 there are this symbols -> It would be nice if we can configure if there are symbols or lists like before!12 votes
Theobald software already supports ABAP reports - see this click through demo (attached).1 vote
Navigating from a scheduled task in task scheduler to the actual ETL component (groovy/ standard job, etc) would be handy. Right clicking and selecting an option to navigate to the respective ETL component would save a lot of time in implementations with a large number of scheduled jobs across many projects.16 votes
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.
Add search and filter functionality to DataPreview window. Any column would be searchable and filtrable. Something like Data Filter in Excel.
It would exclude any exporting for debugging purposes.17 votes
It would be great to be able to change default values of variables
without leaving the current component.
..e.g. via a sidebar or popup.
This would make development and testing more efficient.
Currently whenever you need to change a variable value while you are editing an extract, transform or load you need to jump into the variables tree, which implicitelly closed the current view.16 votes
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 used in parallel within one job should be configurable.35 votes
Each Extracts/Transforms/Load component in Jedox Integrator has a description field.
The content of the description field shoud be shown as a tooltip in the process flow chart on mouse over the respective component.
This would make the maintenance of a project esp. over longer times much easier by providing fast and good transparency about the project.
Enable extracting data from Extractors in SAP.
- works in BW and ECC (BW not required)
- delta-capable. SAP managed process for easier incremental loading and faster loads
- built-in business logic like joins implemented already by SAP
- proven. SAP uses these to load BW
- customizable6 votes
Actually 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 would also bring a big value add.27 votes
When you configure a Load step in Jedox Integrator it would be great to display a description of the selected Load mode (create, update, add, insert) next to the dropdown list.
I guess everyone who is not really everyday working with the Integrator is a bit annoyed by all the time going back to the knowledgebase to verify the detailed meaning, distinction and implications of those modes for certain different targets (dim, cube, relational, rule, ..)5 votes
The monitor refreshes after some seconds but the new output is not visible because scrolling to the bottom of the output is not done automatically.
This would be nice!
Another way: Reverse the output's display (newest lines on top) and there is no scrolling / displaying-problem any more.14 votes
Table, Tree (etc) Joins should be able to be cached in memory or at disc in the same way caching of extracts is possible12 votes
Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte Führt man im ETL einen Excel extract auf eine wss Datei aus, so werd
Excel extract auf wss Datei ignoriert aktuell formelbasierte Zellwerte
Führt man im ETL einen Excel extract auf eine wss Datei aus, so werden momentan nur fix eingetragene Zellwerte ausgelesen.
Von Zellen die eine Formal, eine Palo Formal oder ein Subset enthalten wird der entsprechende Wert nicht ausgelesen.
Es würde die Möglichkeiten des Excel extracts stark erweitern, wenn dies möglich wäre6 votes
At the moment drill through works only with one database.
Filling a cube from different sources with the need of different drill through information is not possible.
It would be nice to use different databases as source for drill through.26 votes
Currently in the ETL TableJoin Transform we only have the possiblity to define a join on an exact match of key fields in the right and left data source.
It would be great to be able to define a matching range (intervall) for the right data source.
In SQL this would be:
SELECT * FROM leftSource JOIN rightSource
ON (leftSource.joinField >= rightSource.range_start)
AND (leftSource.joinField <= rightSource.range_stop)
column "joinField": 250
column "range_start": 200
column "range_stop": 300
This would then give a matching record.
Same request is applicable for
Map-FieldTransform and Lookup-FieldTransform!
Thanks :)6 votes
Done for Join and Lookup (function LookupInterval) in 7.0 SR1.
For Map planned #32965
It would be interesting accessing files from s3 / s3-compatible object storage directly in Jedox as a connection, or event in jedox-web.
Object Storage is extrem convinient as file interface, and allow easyly to interact with other systems :
- third party systems write there Data on the object store (for jedox and maybe other programs too)
- Jedox can read that file and use it for ETL purposes as connection or extract.
A "nice to have" would be, being able to use wildcards, and access all files with the same pattern at one time : my_import_files_*.txt3 votes
ETL project description input text field: Expand from current "height: 200px" to e. g. "height: 100%"
Currently the text input field for describing an ETL project has only 200px in height. Most of the browser window is unused empty space. If there is a long description (= over 200px in height) one has to scroll.
So please give this input box more space. Maybe 100% or 95%.4 votes
- Don't see your idea?