topic Re: Query onto AlteryxGallery MongoDB in Alteryx Server Discussions

Query onto AlteryxGallery MongoDB

aswadv4 — Fri, 25 Jun 2021 06:47:17 GMT

Hi,

I want to query the Alteryx backend database.

Is it possible to do so and if so how can it be done. While exploring the Alteryx server found that .wt files are generated.

WiredTiger is a high-performance, key-value storage engine.

Re: Query onto AlteryxGallery MongoDB

raychase — Fri, 25 Jun 2021 09:08:08 GMT

Alteryx Designer contains a MongoDB connector that can be used to query the databases that contain all data leveraged by the Alteryx Gallery.

You'll need the host name of the machine running your Alteryx Server, and a user/pass with permissions to query the databases (retrievable from the configuration settings of the Server).

Re: Query onto AlteryxGallery MongoDB

esoden — Thu, 17 Feb 2022 23:12:42 GMT

Workflow Admin Manager has over a dozen reports that answer most questions that we've thought of from the Mongo backend. https://capitalizeconsulting.com/workflow-admin-manager/

Re: Query onto AlteryxGallery MongoDB

raychase — Thu, 17 Feb 2022 23:19:26 GMT

I can confirm that Workflow Admin Manager is a very neat and useful tool!

Hi @esoden - Hope all is well.