This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject

Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Server Knowledge Base

Definitive answers from Server experts.

How to Login to Robo 3T

conorbroderick
Alteryx
Alteryx
Created

‎07-09-2020 07:52 AM - edited ‎08-16-2022 03:20 AM

How to Login to Robo 3T


Robo3T is a freely available GUI editor for MongoDB. This article covers connecting to the Embedded Alteryx Server MongoDB.  Speak with your DBA to connect to User-Managed or Atlas MongoDB. 
 

Prerequisites 

  • Admin access to the Alteryx Server 
  • Robo 3T (download "Robo 3T Windows .exe" from GitHub.
 

Procedure

Gather your connection details

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

The Server MongoDB has three databases:
  • AlteryxGallery
  • AlteryxGallery_Lucene
  • AlteryxService

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>
image.pngimage.png
  • 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
image.pngimage.png
  • Select Connect to open the database in the left pane,
 

Connect to AlteryxService database

  • Select File > Connect
  • Select Clone
image.pngimage.png
  • Change Connection tab > Name to AlteryxService
  • Change Authentication tab > Database to AlteryxService
  • Select Test 
  • Select Save 
  • Select Connect to open the database in the left pane,

Connect to AlteryxGallery_Lucene database

  • Repeat the steps above to clone and set the Name and Database to AlteryxGallery_Lucene
  • Select Connect to open the database in the left pane,

Additional Resources