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 Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryxing Alteryx

JenniferO
8 - Asteroid

Hello!

 

Has anyone had any success in Alteryxing Alteryx?  We have Alteryx Server, which is a MongoDB.  What I would like to do is build a workflow that can show me an output of what data connections have been created on the gallery, their names, and what users and studios they have been shared with.  Has anyone done this?  I've spent a while perusing the MongoDB tables and there aren't really primary keys on the tables so its seemingly difficult to join them to get what I need.  

 

Thanks!

3 REPLIES 3
Garrett
11 - Bolide

The attached document "Alteryx Gallery MongoDB Schema" might be helpful. It's circa November 2017 so it's possible an newer version is out there somewhere.

StephenR
Alteryx
Alteryx

In the MongoDB input tool you can check the box that says Include _Id field. That will give you the primary keys for that table.

Regards,
Stephen Ruhl
Principal Customer Support Engineer

BenMoss
ACE Emeritus
ACE Emeritus
Jennifer,

Whenever I've tried to create reporting off the mongoDB, I have used the alteryx server usage report as a 'help'to get me started, this report is available via licenses.alteryx.com

It shows a good amount of detail regards how the tables can be joined together.

@Garrett I've been looking for a schema doc for ages!
Labels