To make the scheduled automation usable, the following must be improved:
Add option to delete the data before the load – otherwise cases deleted in source data will be kept in Aris forever
Add option to limit/select connections/extractions - in case of multiple connections/extractions, we should be able to limit which one we want to use (otherwise error is raised - see screenshot attached)
Add option to refresh the model & columns
Add option to add new columns & remove old columns - otherwise new columns will not appear in Aris until a manual load
(4) Extraction defintion should be auto-updated and loaded.
Thanks for filing this idea. Regarding (1): why would you like to delete data before the load, since you typically extract deltas not the full data; hence, deleting data will result in not having those cases in the system at all anymore. There is already a dedicated deletion option to delete loaded cases from the system.
Could you please also provide some more details on (3)? Thank you.