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...
Wenn performing a load of a cube with drillthrough parallel load a log line states : Number of rows in table "<schema>"."table" changed from xxx to yyy the query performed to do that is select count(*) from <schema>.<table> thus ...
Check user permissions before execution of Integrator job
When executing an Integrator job with limited user permissions in a database, it could happen that the job does not complete successfully due to missing permissions of the user. If in that case some write actions were already executed and others a...
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...
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...
Customizable Naming Conventions for Integrator Projects
Currently, when creating a new Extract within the Integrator, the system automatically generates a default name, such as "New Excel Extract." However, given the varying preferences of consultants, it would be beneficial to offer users the option t...
Increase the size of some ETL- input fields for better handling and input
Please increase the size of some ETL- input fields, where many characters can be entered.For instance: logical expression fields; json template in JSON connections, etc.The current size is error-prone and inconvenient.
At one of our prospects, we ran into a requirement, where prospect files are located in Google Drive. Since cloud solutions are spreading, it will be a more and more frequent required functionality to access these cloud-based file servers. If it i...
When creating a json extract the different column names can be defined. This would be great that it does not have to be defined manually but dynamically, I see 2 possibilities: 1/ getting the column list from another extract or transform 2/ have a...
