It would be fantastic in the DataSync if we can have a kind of workflow or Data Pipeline to define sequences on some action.As an example we could have :Sequence 1 : a file is drop in a folderSequence 2 : a...
We are using the partition feature of DataSync on the X3 table GACCENTRYA. The partition is based on CREDATTIM_0 field which is the creation datetime of the line. We recently discovered that when...
The ability to have predefined built-in function in the field screen to transform the field without having to create an SQL script.Ex : * Remove Comma * Format a phone Number * Format a date * Make...
Sometime we use the same source value to define multiple destination value. As an example, the Account Code as a source will be used to define 4 different dimensions as a destination. So, we could...
In some scenario third party software generate files with data where the file name will include the timestamp or other unique identifier in a folder (ex: invoice_2022-01-01_11_10_10.csv), the...
To be able to organize DataSync objects (connections, extractions, transformations, schedules, ...) in folder and/or project/environments instead of prefixing objects with the same word.As the...
When we remove the table from an existing extraction we would like to have an option to allow the delete of the table that was previously created in the destination as actually the table stay in the...