This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My company has been using a Production environment of Alteryx Server for about a year. I've been asked to set up proper QA and DR environments. I have three VMs, all with the same version of Alteryx Server installed. I have also created a .bat file that runs a nightly backup of the MongoDB (from Prod) and places copies on the QA and DR boxes. My primary concern is the QA environment, as I want to have all Data Connections, Workflows, Studios, Users, etc. from the Prod environment available for testing purposes. Is it as simple as restoring the MongoDB backup in the QA environment? It should be noted that I do not want the scheduled jobs to run on QA, as there would be potential overwrite of outputs. When I tried this restoration process, I could see all of my users/studios/workflows; however, my data connections were absent, and I wasn't even able to add new ones (it was a blank page). When I clicked on jobs, I was prompted with an error about the workers not being found. Please advise what the best practice is for replicating Prod on QA, but disabling all of the scheduled workflows.
The goal for the DR environment is to have an identical version of Alteryx Server installed; however, the services would not be running. This environment would only be used in the case of a disaster, and should be able to handle the exact duties of the Prod environment. As such, I WOULD want the scheduled jobs to run. Please advise how to best coordinate these environments.
When data connections are added on the Gallery itself, where would these connections be stored? My impression is that these are "System Type" connections; however, I cannot locate the SystemAlias or SystemConnections files.
What differentiates a System Type from a User Type connection? We try to manage all of our connections via the Gallery (we have a couple of dedicated admins that handle these).
Great job including the DSN bit, I had no idea that I could back those up as well.
If I could sort out the Data Connections from the gal