Jedox Ideas

Let us know how we can make Jedox even better!

ADD A NEW IDEA

Integrator

Showing 173

Error in field transform would return the function name where the error occurs.

When a function in field transform runs into an error, its now pretty hard to investigate which function resulted in an error. Intsted of this, the error message should tell more about which function has an error, or, in the field transform data p...
about 1 month ago in Jedox Platform / Integrator 2 Planned

Global Field transforms

In integrator, it would be very useful if we could generate a global field transform (within a project, or within a certain workspace). For example, during data inputs, customer ID should be processed by a groovy, concatenation, or any other field...
about 1 month ago in Jedox Platform / Integrator 1 Future Consideration

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...
over 5 years ago in Jedox Platform / Integrator 2 Future Consideration

Roll-back of write actions when execution of Integrator job fails

When executing an Integrator job that writes data to a database with limited user permissions in that database, it could happen that the job does not complete successfully because some write actions fail (due to missing permissions of the user). I...
over 1 year ago in Jedox Platform / Integrator 0 Future Consideration

Create new folders in Integrator

Today, it is not possible to create a new folder in the Integrator section. Only importing projects via the marketplace creates new folders that cannot be renamed. It would be interesting to have this possibility in order to gain visibility at the...
over 1 year ago in Jedox Platform / Integrator 1 Planned

Include "Column Exclude pattern" into Table View Transformation

Many times, a Table View Transformation is the final step of loading data into different sources. It would therefore be very handy to also have the Column Exclude/Include patterns in this transformation. This way, you don't have to define the whol...
about 2 months ago in Jedox Platform / Integrator 0 Future Consideration

Option to ignore format in Excel Extract

When there's an error in one of the columns due to a wrong format or null values in some cells, the Excel Extract will not load and instead return an error. An option to either ignore the format of columns or ignore columns entirely, if they're no...
about 2 months ago in Jedox Platform / Integrator 1 Future Consideration

REST Connector from an external Server to Jedox

The current REST Connector only supports one connection setup from JEDOX -> Server. This means that each accessing server must first open an incoming port. When an incoming port is opened, further steps must be initiated to secure the server. T...
6 months ago in Jedox Platform / Integrator 0 Planned

Multiple Table Joins in one transform

As a Model Builder, I want to join multiple sources in one single step so that I can accomplish my tasks with as little ETL footprint as possible and have a more intuitive ETL Flow Graph. Often there are multiple sources where values have to be re...
about 3 years ago in Jedox Platform / Integrator 0 Future Consideration

SQL-Generator for ETL Relational Extract

SQL Query Designer with UI that generates SQL from clicks, e.g. Query Builder as in MS Access + Editor with Syntax highlighting for SQL. #6396
over 5 years ago in Jedox Platform / Integrator 1 Not Planned