Database connection information from workflows

Question

I have approx 150 workflows in Alteryx Gallery. I need to extract the database connection information for each workflow. i.e. what database each workflow is using as an input and output. Is there a way to extract that information?

Highly appreciate your help.

Best

PK

VojtechT · Answer

Reading as CSV = reading each XML row as a record. then I'd use Formula tool to find rows containing the input or output tool and parse the code - hoping that there is always the full connection string which contains the server hostname and the database, eventually also the query.

Or use Alteryx Connect, which is our Data Catalog solution which serves exactly this use case and also shows you the lineage between workflows and data sources.

Analytics_Pooja · Answer

I have tried to read workflow as an XML but that doesn't give any information regarding the data connection. it only gives information regarding the tools. Not sure how to read a workflow as csv.

NikyN · Answer

Hello there,

if you have them saved somewhere on drive as well -- it should be easy to load all flows as .csv file to your workflow, and read all details.

If you are looking for getting it directly from Alteryx Gallery -- I cannot help.

Good luck!

Niky