topic Re: Get names of all output tables from multiple Alteryx workflows - going into SQL Server in Alteryx Server Discussions

Get names of all output tables from multiple Alteryx workflows - going into SQL Server

anks_joi — Thu, 05 May 2022 21:55:32 GMT

Hello Alteryx Community,

I have many Alteryx workflows (.yxmd) on Alteryx Gallery and I would like to know names of all the output tables (within those Alteryx workflows) that are going in to the SQL Server. Also, I would like to know names of all the output tables that are going in to the Tableau Server as .tde

Thank you.

Re: Get names of all output tables from multiple Alteryx workflows - going into SQL Server

ArtApa — Sun, 08 May 2022 06:10:49 GMT

Hi @anks_joi - The best solution for this would be Alteryx Connect: https://www.alteryx.com/products/alteryx-connect

However, if the use case not big enough to justify the license price, you can create a workflow, which will download all workflows from your Alteryx Server via APIs and then parse xml (Alteryx workflows are XMLs) and get you information needed.

Re: Get names of all output tables from multiple Alteryx workflows - going into SQL Server

anks_joi — Mon, 09 May 2022 11:46:13 GMT

Hi @ArtApa,

Thanks for your response. I am able to do the second part of your suggestion, however would you have any references to a workflow that will help me download all workflows from Alteryx Server (Gallery) via APIs?

Re: Get names of all output tables from multiple Alteryx workflows - going into SQL Server

ArtApa — Wed, 11 May 2022 03:08:15 GMT

Hi @anks_joi - Here is a link to the article and sample workflows. These sample workflows check for the "Ready to Migrate" flag. However, they must give you a good understanding of how it works in general: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Migrating-Workflows/ta-p/335774