Migrating workflows from one environment to other.

Ranjith15

I am having situation like, I have to move the worklfow from UAT to Prod

From UAT the workflow has to write output to D drive. once the workflow migrated to Prod it has to write output to E drive. But I have to achieve the above condition without modifying workflow connection properties.

In Informatica we do have connection option to create connection with same name in each environment, but it will point to destination as per the environment(UAT D- drive, Prod - E drive). So no need to modify the connection properties on each migration and we can able to achieve the above business logic. 

Is any similar option is available in Alteryx too?

jamielaird

Hi @Ranjith15 

You could possibly achieve this by defining the drive as a workflow constant (e.g. [User.Drive] = D), building the file paths for the output tool using this constant in a Formula tool and then at the migration stage updating the workflow constant value from D to E.

This isn't very user friendly so you might want to experiment with building custom output tools that wrap up the file path creation process and configuration of the output tool.

You could also edit the XML at the migration stage to replace instances of \ with E:\.