Integrator

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

A dedicated connector for Netsuite, rather than using JDBC

If one uses a load with insertParallel mode, the ETL will unconsolidate duplicates of elements in every Top-Element. This behavior is documented but not always wanted - sometimes you only want to load a certain Top Element (Tree) to be loaded with...

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

Often someone wants to easily update a dimension from a file. Often, they want to just rebuild it instead of extending what is currently in the dimension (similar to what you can do in the Time dimension UI) (see attached file) This can be the cas...

It would be nice to have the lucanet cube extracts and dimension extracts in a seperate folder in the integrator, rather than showing them in the same folder as a jedox cube and dimension extracts. For one it would provide a better overview (of co...

It would be very helpful to be able to add columns to an existing drillthrough database. Currently this is not possible. There is no control over the drillthrough database at all (only via ETL Load process). This is a pain once there are more colu...

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

We would like to use "openxlsx2" or "xlsx" or any other similar "R" package to generate well formatted Excel files, expected by customers, from Integrator "RScript" transform . We expect, we will be able, among other things, too : - create workboo...

When re-using Field Transforms you often need to update functions however the preview of a single function will not work until every transform function is correctly updated otherwise it throws an error for a function you intended to fix later. The...