Connection String In Mongo DB

MattBenj

I am trying to figure out a way to export all of the connection strings we have set up in our Gallery. I found the AlteryxGallery.dataConnections table in Mongo DB but the connection string seems encrypted. I could do a bunch of copy & paste but we have 150 connections so an automated way would be helpful. 

Does anyone know how to decode the ConnectionString in AlteryxGallery.dataConnections?

TheOC

hey @MattBenj 
Have you had chance to look at the Server v3 API?
https://community.alteryx.com/t5/Engine-Works/Introducing-the-Alteryx-Server-v3-API/ba-p/899228

You'll be able to use the tools involved within that post to help. One of the tools (Server API GET) allows you to retrieve all credentials and Server Connections:

I believe retrieving the server credentials via the api rather than the raw table might give you the data in a decoded fashion.

Kind Regards,

Owen