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. MD5 Hash in ETL => compare records, detect changes/deviations, history logic

    It would be great if Jedox Integrator could generate an MD5 Hash based on an entire row. This would be very useful in generic routines where you need to compare records and detect changes (esp. for historization logics)
    For me this would be a new field transform function.

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  2. Reuse of Field Transforms (esp. groovy) - central library / repository of components

    Hi,

    sometimes you have field transform methods which are used in the same way in different ETL processes.
    This might be complex groovy scripts or simple concatenations.

    If you need to change even a simple concatenation scheme (like generating a key) across several different processes it is very much effort and very error prone.

    Also for more complex groovy scripts it is not good if you have them redundant.
    Therefore it would be good to create such transformations in a kind of central repository with generic inputs. And then you can select/use/map them in a concrete field transform step within…

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  3. Export and import multiple Integrator projects in one step

    We have split our ETL processes into several different Integrator projects to keep everything modular and maintainable.

    However the deployment of a new complete release from a development to a production system is quite annoying:
    We have to export every single project separately.
    And on the production sides it is the same:
    We have to import every single project separately.

    It would be great to be able to do this in one step.
    Thanks :)

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  4. Shortcut for Data Preview

    A shortcut for Data Preview in the ETL would be quite useful, and I think not so complicated to develop

    1 vote
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  5. Add navigation capabilities (previous/next/first/last) in the FieldTransform functions

    if you want to edit the next or the previous function in ETL client, you have to close the current one, and click on edit for the following. This would be helpful to jump to the next or previous one without closing the window

    2 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  6. Window functions in ETL

    This would be great to add window functions capabilities in the ETL, maybe as a new function. Window function allow to do aggregations within a query, on the query itself. For instance:
    id | Value | Sum
    X | 1000 | 6000
    Y | 3000 | 6000
    Z | 2000 | 6000

    the third column is the result of a window function (this can also be avg, max...)

    this is present in some relational systems, see here : http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/courses/SS2008/NEDM/RDDM.Chapter.06.Windows_and_Query_Functions_in_SQL.pdf

    at the present time to do that in the ETL you have to get an aggregation component, and lookup on it…

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  7. Including Python 3.x for Skripting (e.g. Field Transforms, Job Skripts, Loads,...) additional to the current Groovy / JavaScript

    Including Python 3.x for Skripting (e.g. Field Transforms, Job Skripts, Loads,...) additional to the current Groovy / JavaScript

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  8. Writeback NULL for lookup function

    It is not possible to writeback a null directly from the lookup function.
    This would be usefull for possible writebacks to a SQL database. As this would require less space within the SQL database.

    The workaround for now is using a extra groovy function in order to get the etl to write back a null.

    1 vote
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  9. 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 :)

    19 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  10. Add functionality to "Handling of missing elements" in ETL Loads

    I think it would be utterly helpful to add an instruction like "show warnings without import". This would make it possible to update basic data (i. e. Dimensions) before importing.

    One can of course delete the imported data and reimport, but if you use "Cube Load with Drillthrough", then you will end up with plenty of double entries here, since this is a separate database...

    1 vote
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  11. Monitor: Add links to mentioned Integrator components

    Having huge integrator projects makes it confusing to find a component that failed in etl process for example. The components (Extracts, Transforms, Jobs, ...) are part of the logfiles shown in the monitor but in case of failure of in case of the need to get some details it is necessary to go to the concrete extract, transform, job and so on.

    The feature request is now to show the displayed components in the monitor log file as link that points to the component inside the integrator. So only one click is needed to jump to the concerned component.

    8 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  12. Global Components in the Integration-Manager

    It would be very useful to have the possibility defining global Variables, Connections etc... (Perhaps even extracts!)
    In Case e.g. an IP-Adress of a source-server changed it is not longer necessary to change all the concerned connections in the projects, but only the one global defined connection...

    7 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  13. 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.

    30 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  14. Full Groovy support missing in Jedox 7

    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 functions are supported.
    e.g AntBuilder() is missing in Jedox 7.

    Either change the doku, give a list of all supported functions or provide the full function catalogue of groovy by adding the missing libraries.

    Also the groovy version used would be nice to now.

    26 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  15. Reuse of a jedox session id in a connection in ETL

    if a job using this variable connection is still running => message to the user / allow to cancel the job

    9 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  16. 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();

    14 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  17. Enhance the REST connection with the standard methods

    At the present time only GET and POST are supported. It would be great to have all the other methods of REST (PUT, DELETE...)

    9 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  18. Connection, Extract, Load for Workday

    In the US we are seeing increasing demand for integrating Workday HR data into planning processes based on other sources (NetSuite, SAP, and other ERP systems, Qlik on the frontend). Workday They already has a relationship with Adaptive Insights and offer their own solution for Planning, Budgeting, and Forecasting. We would be competing against them in deals that lead with planning for Workday as a requirement but in other deals having a Workday integration solution may help us against Adaptive, especially if the project goals include other areas where Jedox is strong (flexibility, Qlik integration, etc.).

    6 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  19. Enable string list as variable

    ${Countries} = ['Germany', 'France', 'Italy'].
    ${Values} = ['1','2','3'].

    These variables could for instance be used in a Field Transform (e.g., named "FT_countries_values").
    ${Countries} and ${Values} would serve as input columns, named "Countries" and "Values" with rows corresponding to list elements:
    Countries | Values
    Germany | 1
    France | 2
    Italy | 3

    An error message would appear if row numbers do not match between lists or between a list and the FT source.

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
  20. Excel ETL Connection to Office 365

    According with the customer support channel, this connection is not possible due to:

    Microsoft uses rest api to connect its modules, like share-point and other products. These modules are authenticated with auth2 type(also handled via rest calls). Your example uses basic authentication which is not a correct way to connect share-point. So, as a result, this is normal to have this error.

    This connection would be very usefull

    3 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
← Previous 1 3 4
  • Don't see your idea?

Jedox Feature Voting Tool

Feedback and Knowledge Base