alteryx server Knowledge Base

Definitive answers from Server experts.

How To: Connect to a user-managed MongoDB with Robo 3T

Alteryx
Alteryx
Created

How To: Connect to a User-Managed MongoDB with Robo 3T

This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T.
 

Prerequisites

  • Alteryx Server
    • All
  • Robo 3T
  • Alteryx Server Administrator privileges 

 

Procedure - AlteryxGallery Database

Open Robo 3T > File > Connect > Create
  • Connection tab
    • Set Type to 'Replica Set'
    • Set Name to 'AlteryxGallery'
    • Add the 'Members' found under:
      • Alteryx System Settings > Controller > Persistence > Database > Host
      • Alteryx System Settings > Controller > Persistence > Database > MongoDB Connection if you have 'Advanced User-Managed MongoDB' selected
    • Add the 'Set Name'
idea Skyscrapers
  • Authentication tab
    • Enable 'Perform authentication'
    • Set Database to 'AlteryxGallery'
    • Set User Name to 'user' 
    • Set Password:
      • If you are using the standard option, open a command prompt as an Administrator and execute:
'\Alteryx\bin\AlteryxService.exe' getmongopassword
  • Set Auth Mechanism to 'SCRAM-SHA-1'
  • Select Save
idea Skyscrapers

Once the Connection has saved, now select Connect.


Procedure - AlteryxGallery_Lucene Database

Perform the same steps as previously but replace any mention of the 'AlteryxGallery' database with 'AlteryxGallery_Lucene'.


Procedure - AlteryxService Database

Perform the same steps as previously but replace any mention of the 'AlteryxGallery' database with 'AlteryxService'.