MyAlteryx
Community
Academy
Help Docs

Welcome to the Alteryx Knowledge Base

Knowledge Base / Server / How to Connect to an Embedded Server UI MongoDB using Robo 3T
How to Connect to an Embedded Server UI MongoDB using Robo 3T
user

Created/Edited - 4/27/2026 by Conor Broderick | Alteryx

How To

How to Connect to an Embedded Server UI MongoDB using Robo 3T

Robo 3T can be used to connect to the MongoDB of your Alteryx Server instance in order to view and query the database data. This article outlines the required steps to set up the connection.  

Environment
  • Alteryx Server
    • Versions 2018.3+
Procedure

1.Download Robo 3T 

  • Robo 3T is a freely available GUI editor for MongoDB. The Robo 3T Windows .exe can be downloaded from GitHub.

2. Gather your connection details

  • Open Alteryx System Settings on the Server (Controller) machine.
  • Gather the following information from the Controller > Persistence > Database section:
    • Host
    • Username
    • Password (not the Admin Password)

3. Connect to AlteryxGallery database

  • Open Robo 3T.
  • Select File > Connect > Create
  • Configure Connection tab
    1. Type =       Direct Connection
    2. Name =     AlteryxGallery
    3. Address =  localhost  <or value from Connection Details above>
    4. Port =        27018  <or value from Connection Details above>
  • Configure Authentication tab
    1. Enable Perform authentication
    2. Database =             AlteryxGallery
    3. User Name =          user
    4. Password =            <non-Admin password from Connection Details above>
    5. Auth Mechanism = SCRAM-SHA-1
    6. Select Test to ensure the connection is successful
    7. Select Save
 
 

  4. Connect to AlteryxService database

  • Select File > Connect
  • Select Clone
  • Change Connection tab > Name to AlteryxService
  • Change Authentication tab > Database to AlteryxService
  • Select Test 
  • Select Save 

5. Connect to AlteryxGallery_Lucene database

  • Repeat step 5 to clone and set the Name and Database to AlteryxGallery_Lucene

6. To view and query the data

  • Select Connect to open the desired database in the left pane
  • PLEASE NOTE: Making direct edits to the database is only for advanced usage. You must have a database backup in place prior to making any changes.

 

Additional Information
Was this article helpful?