Jedox Ideas

Let us know how we can make Jedox even better!

ADD A NEW IDEA

Integrator

Showing 110

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...
11 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...
12 months ago in Jedox Platform / Integrator 2 Future Consideration

Setting variables via source like Extract, FieldTransform etc

It is only possible to set variables dynamically without Groovy when using Loop-Jobs (more or lesse misusing them). Downside of this is that it will not work with Data Preview.It would be great to have a) a variable setting integrator component (V...
almost 6 years ago in Jedox Platform / Integrator 0 Future Consideration

New Load Type: Constant Table

Ability to store data in a constant table. It would be designed to store small amounts of data that you want cached for other processes in Integrator. Fields in Load: Data Source Target constant table (must be defined beforehand) Mode (add/delete/...
almost 4 years ago in Jedox Platform / Integrator 0 Future Consideration

folder creation after ETL excel load

What exists today and what is great : When using the upload action, it is possible to save a file in a folder that doesn't exist yet. Indeed, when we will configure the action, we will specify the path (including the name of a folder that doesn't ...
about 2 years ago in Jedox Platform / Integrator 0 Future Consideration

Snowflake connector Improvement

In the new version 2023.3, we started to use the new Snowflake connector. When the current snowflake connector queries all meta data (e.g. table names, column names), the query is over ALL tables and columns in the Siemens Snowflake Account. This ...
about 2 years ago in Jedox Platform / Integrator 0 Future Consideration

REST Connection Output Formatting for Improved Testing

As a user, I would like to be able to see json testing format in a prettier manner. Currently, we need to scroll to the right in order to see what is there or to select all and copy to some notebook. Even when we copy it to Notepad we need to save...
about 2 years ago in Jedox Platform / Integrator 0 Future Consideration

Change of "File based" Global Connections similar to SAP/SQL

Currently Global Connections such as Azure Blob, OneDrive, SharePoint are not usable, because they always point to a specific file. In contrast, Global Connections of SAP or SQL only store user and system credentials. This needs to be the same for...
about 1 year ago in Jedox Platform / Integrator 0 Future Consideration

Azure Data Lake gen2: Integrator support for Common Data Model Views

When you connect to ADL, the data is "schema-less" (ie there are no field names on the file columns.). Data Lake has a way of presenting multiple files (i.e the data files - there could be multiple.., the json file containing the field definitions...
over 3 years ago in Jedox Platform / Integrator 0 Future Consideration

Additional checkbox in Json and XML extract: Dynamic

As a Integrator builder, I want to be efficient with my usage of extracts from cloud based systems. Right now, I need to define a specific json or xml schema for each rest connection. What would be great is if Integrator could automatically assign...
over 3 years ago in Jedox Platform / Integrator 0 Future Consideration