Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

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

anks_joi
6 - Meteoroid

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.

3 REPLIES 3
ArtApa
Alteryx
Alteryx

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
6 - Meteoroid

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
Alteryx
Alteryx

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