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...
Nous utilisons la fonctionnalité de partition de DataSync sur la table X3 GACCENTRYA. La partition est basée sur le champ CREDATTIM_0 qui est la date et l'heure de création de la ligne. Nous avons...
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...