How to connect MongoDB for Sage X3 using MongoDB Compass

Less than one minute read time.

MongoDB Compass is a free GUI tool for querying, aggregating, and analyzing your MongoDB data in a visual environment. It has easy-to-navigate interface to managing MongoDB data including importing.

Step 1: Download MongoDB Compass installer

Download site:

https://www.mongodb.com/try/download/compass

Note: I have windows environment hence downloading (mongodb-compass-1.37.0-win32-x64.exe)

Step 2: Install MongoDB Compass.

  • Run mongodb-compass-1.37.0-win32-x64.exe with "Run as administrator" option.

  • Once installed the GUI will launch

Step 3: Connect to X3  Syracuse database.

Expand Advance in General Tab

Setup SSL in TSL/SSL TAB

  • Provide Client Pem file.
  • Select check box – “tlsAllowInvalidCertificates”.

       

  • Save the connection with appropriate name

      

Step 4: Verification

  • Expand "Syracuse" Database.
  • Expand "User" Collection. Verify user documents are displayed.