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

[anks_joi]

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.

[ArtApa]

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. 

[anks_joi]

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?

[ArtApa]

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