Jedox Feature Voting Tool

Dear Jedox User,

in our continuous strive to improve our services, features and to help you gain your share of this ever growing market we are introducing the Jedox Feature Voting System.
This new service is currently exclusively available for you, our Users and Partners.

What is this Jedox Feature Voting System?
It is a tool that provides you with the options to create and vote on Feature request, Ideas and any other general Feedback.
This in return provides us with the necessary Information to react and provide you with the things you need.

We invite you to browse this Page, create and vote on new Features, Ideas and requests!

How can we improve Jedox Software?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Improve Batch PDF / Push-Mails

    E-mails sent by ETL-/Taskmanager shall be more configurable:
    - User defined mail subject incl. use of ETL variables
    - User defined mail body incl. use of ETL variables, incl. HTML
    - Mail recipients: TO/CC/BCC
    - Possibility to attach statical files in addition to the batch-PDF.
    - Configurable layout templates

    93 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  3 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  2. debug mode for macros and script code in ETL

    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 for those scripts and macros to see step by step if they are working correctly.
    This could be combined with the object manager I proposed within another feature request.

    89 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    backlog  ·  0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. Undo in ETL

    There is no way of undoing a change in ETL rather than reloading the whole ETL Project. Once a change has been made one is forced to save!

    Would be helpful if you can leave a changed ETL component without saving it.

    36 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  4. Tomcat multicore support

    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  5. Tags for ETL-components

    Choose several ETL components of one project which belong somehow logically together and group them under a given name.
    Should be displayed in ETL Manager under a new item
    -Tags
    --- SalesRelated
    ------Extract
    --------- E_XY_1
    --------- E_XY_2
    ------Transforms
    --------- T_QWERT
    --- ImportantComponents
    ...

    A component may be assigned in different tags
    Option to create a tag out of the dependency of a component (to decide if dynamic or not)
    #13405

    30 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    backlog  ·  1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  6. Drill Through with more sources

    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.

    28 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  7. create folders in ETL integration manager (by user)

    instead of forcing the creation of folders by component type (e.g. "Cube", "Dimension", .. for extracts), it would be very much appreciated, if it was possible to create a folder-structure by user.
    Potentially, these folders could also span across "E", "T" and "L", to allow even easier structuring by topics.
    Not sure though, if the latter brings more advantages or disandvantages. Please post your comment.

    28 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  8. Improve usability of Groovy function editor

    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Rollback functionality for Jedox ETL

    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 halfway data may remain in the target database after the execution.
    To avoid the problem, the Jedox ETL need to have the rollback functionality.

    23 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  10. Load multiple Excel files from a directory with one connection and extract (like CSV Files).

    oad multiple Excel files from a directory with one connection and extract (like CSV Files).

    Basicly the same structure like creating a file extract using a folder-connection. But also working with Excel files :)

    20 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  11. Copy function from a Field Transporm 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).

    19 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  12. Find & filter in ETL data preview windows

    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.

    My solution:
    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  13. Number of rows from an ETL component

    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();

    17 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  14. Scheduler: possibility to create multiple folders in the scheduler

    So that administration of the scheduler jobs is possible.
    For example to manage active and inactive jobs.
    (Enable or disable jobs all at once)

    16 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  15. ETL: change variables without leaving the current component

    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. Navigating from scheduled task to ETL component

    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. Sending the mail with Cc and Bcc in the Jedox ETL

    I tried the following code in the Groovy in the Jedox ETL.

    -----------------------------------------------
    import javax.mail.Message;
    LOG.info("BCC:" + Message.RecipientType.BCC);

    mailer = API.getMailer();
    mailer.setServer();
    mailer.addRecipient(Message.RecipientType.BCC,"e-mail address");
    //mailer.addRecipient("e-mail address");
    mailer.setSubject("test");
    mailer.setMessage("test!");
    mailer.send();
    -----------------------------------------------

    And then, I get the following error.

    Unable to execute groovy job: groovy.lang.MissingMethodException: No signature of method: com.jedox.etl.core.util.MailUtil.addRecipient() is applicable for argument types: (javax.mail.Message$RecipientType, java.lang.String) values: [Bcc, e-mail address]

    And I can use the following code,
    but it send email only with To.

    mailer.addRecipient("e-mail address");

    At this time , it is not supported to send the mail with Cc and Bcc in the Jedox ETL .

    So, Could you please…

    15 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  18. Target column structure for table transforms (like field transform)

    It would be great to filter and rename the set of output columns directly within table joins, table views and extracts
    ...similar to field transforms. (see screenshot)

    This would save time as well as a couple of additional elements in the ETL flow chart.

    Today after table joins I often add an additional field transform because I only need maybe 3 out of 10 columns from the join...and maybe 2 of them with another name.

    Thanks JC

    15 votes
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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 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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  20. Monitor: Auto-Refresh of Monitor Output does not scroll to bottom (=newest entry) automatically

    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
    Vote
    Sign in Sign in with Jedox AG
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4
  • Don't see your idea?

Jedox Feature Voting Tool

Feedback and Knowledge Base