Connection String In Mongo DB

MattBenj — Fri, 24 Mar 2023 18:26:22 GMT

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?

Re: Connection String In Mongo DB

TheOC — Sun, 02 Apr 2023 19:50:50 GMT

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

topic Re: Connection String In Mongo DB in Alteryx Server Discussions

Connection String In Mongo DB

Re: Connection String In Mongo DB