Jedox Ideas

Let us know how we can make Jedox even better!

ADD A NEW IDEA

Integrator

Showing 149

No distinction between uppercase and lowercase in the integrator

At the moment, Jedox differentiates between uppercase and lowercase in the integrator and treats the elements like two different ones. Example: RepUnit <> REPUNIT -> Table normalization, lookups etc. won't work properly as Jedox raises th...
3 months ago in Jedox Platform / Integrator 0 Future consideration

Import Integrator Projects from SFTP (with ELT Project)

As a consultant, I would like to upload Integrator Projects from an SFTP Server. Basically, we would like to have the basic functionality of the "Import" option within the Integrator as a function that we can use within an ETL Job. This way we cou...
about 2 months ago in Jedox Platform / Integrator 2 Future consideration

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

MS Connectivity: Ensure Azure Blob Storage/Data Lake v2 Connection also works with MS Fabric/OneLake

Microsoft are heavily pushing MS Fabric and thereby their "OneLake" concept. "OneLake" can be adressed similarly to DataLake v2 and thereby probably as Blob Storage, but I think none of us have tested that. Furthermore, we don't show the wording "...
3 months ago in Jedox Platform / Integrator 0 Future consideration

Flag / Highlight ETL component in graph

the basic idea comes from a forgotten filter in the table view. Flagging or highlighting components in the graph could help to visually perceive open changes/adjustments so that they are not forgotten. in the attached screenshot you can find a qui...
7 months ago in Jedox Platform / Integrator 1 Future consideration

Jedox integrator - Same features for "Insert columns" as in Extract

Currently, only in the "Extract" elements within Jedox Integrator the "Insert column" feature has very good functionality. You can select all elements, deselect all or just select certain columns into your Extract. But within the "Transform" eleme...
about 2 months ago in Jedox Platform / Integrator 0 Future consideration

XML editor - option to show all code of the ETL process

Currently the XML editor is limited in functionality: Find and replace is missing (there is a separate idea for this: JS-I-1557) The XML editor can only show the currently selected ETL element, e.g. job, transform Solution: Have a drop-down in the...
about 2 months ago in Jedox Platform / Integrator 0 Future consideration

Integrator: Support for Parquet file format

Parquet file format is a type of csv where the data is laid out in a columnar fashion, instead of rows. We should have native support for this. https://parquet.apache.org/docs/file-format/ https://medium.com/mlearning-ai/parquet-file-explained-8d5...
almost 2 years ago in Jedox Platform / Integrator 0 Planned

Add packet size option on Snowflake relational load

Hi all, When loading data into Snowflake, it inserts lines by small packet of lines. I wish I had a parameter in the load to set the "Packet size" manually to a higher value when I have to deal with large amount of data. Many thanks
4 months ago in Jedox Platform / Integrator 2 Planned

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
almost 5 years ago in Jedox Platform / Integrator 1 Not Planned