topic Re: Alteryx server on a VM - workflows location in Alteryx Server Discussions

Alteryx server on a VM - workflows location

Mythili — Fri, 03 Jan 2020 17:35:10 GMT

Hi -

I' m new admin on the alteryx. my server is setup on the vm. There is a mongo db back up that runs twice a week. I would like to help our users by making a more frequent backups of just the workflows and not the entire server. I would like to know the location for all the studio workflows. Can you please advise?

Thanks

Mythili

Re: Alteryx server on a VM - workflows location

joshuaburkhow — Fri, 03 Jan 2020 20:22:16 GMT

When you are starting out the size of the mongoDB is so small it's going to be better just to run the back up that Alteryx provides. You'll be safest this way. You can automate this process to run nightly if you like. You can read about it here: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-amp-Recovery-Part-1-Best-Practices/ta-p/22620

If this solves your issue please mark as solved so that others can find it 🙂

Thanks

Joshua

Re: Alteryx server on a VM - workflows location

Mythili — Fri, 03 Jan 2020 20:24:48 GMT

We do have the standard procedure stup already. But I would like to be able to get to just particular workflows instead of resetting the server status.

Re: Alteryx server on a VM - workflows location

joshuaburkhow — Fri, 03 Jan 2020 20:38:56 GMT

You could do this by building a workflow that uses the MongoDB connector to pull this data from your instance. Understand that though this information is stored in binary format. I might be wrong (can't remember 100%) but I don't believe the entire workflow is in just one document, ie any input files are in one document, output in another, etc....

A great way to see what is available is to get ahold of the Server Usage Report Workflow (downloaded from the same spot you get the exe's) and dive into the macro that drives that, that has everything you'll need.

Make sense?