Automated method to refresh data from Production to another environment

FranckVal

Right now in order to refresh Production into Integration for instance, we must:

- Ensure that no Revision Tags are in progress and that they are all deployed to Production before starting the refresh

- Archive the target model

- Duplicate the source model into a new Integration

- Reset all the security as they were

- Recreate all the "Source models"

- Update each dashboard individually to link it to the new duplicated model

We would need to have all those steps automated in one process, where we would select the source system (Prod) and the target system (Integ) for each model.