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. 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...

    12 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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.

    37 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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();

    18 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  9. Netsuite connector

    Several prospects we met recently are using Netsuite. A dedicated connector would be nice.

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

    Would be nice to have a dedicated Quickbooks connector. Many smaller prospects we have met recently at trade shows are still using Quickbooks.

    4 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  11. Copy Data button in Data Preview for ETL

    In addition to the "Export Data" function which generates a CSV files that opens in Excel, we would like to see a function for just copying data to the clipboard for manual paste into an already open Excel sheet. This will make data analysis/reconciliation easier, when you can just paste it into the next sheet, instead of opening a new Excel workbook.

    6 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  12. Dedicated Microsoft Dynamics NAV 2016 Webservice Connector

    Current SOAP/Webservice connector in Jedox Integrator does not support webservices that have Basic Authentication in front of the service.

    Microsoft Dynamics Webservices requires authentication in front of the Webservice due to the sensitive nature of the content.

    This means that we can not e.g. connect to a cloud based Dynamics instance, via its webservices directly from Integrator.

    Dynamics supports both SOAP and OData protocols.

    https://msdn.microsoft.com/en-us/library/dd355398(v=nav.90).aspx

    11 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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).

    17 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    14 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  16. Spashing Function in the ETL

    The main idea is to integrate splashing function ( COPY, LIKE ... ) directly in the integrator manager using groovy job or anything else.

    7 votes
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  17. Ability to turn off cube transaction logging during batch data load

    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
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  18. Layout back to list-view instead of icons

    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
    Vote
    Sign in
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Jedox Integrator (ETL)  ·  Flag idea as inappropriate…  ·  Admin →
  19. New extract type for SAP Connector: ABAP Report

    Theobald software already supports ABAP reports - see this click through demo (attached).

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

Jedox Feature Voting Tool

Feedback and Knowledge Base