MongoDB Connector

Host

Enter the host name for the MongoDB database. For example: db.company.com

Database Name

Enter the name of the MongoDB authentication database. This needs to be the specific database the user was created in.

Collection

Enter the name of the collection you want to connect to.

Username

Enter your MongoDB username.

Password

Enter your MongoDB password.

Database Port

Enter the port number for the MongoDB database.

Certificate Format

Select the certificate format. If you do not want to include a certificate, select No Certificate . If you select Certificate String , you must paste the text for your certificate in the Certificate field. If you select URL Path , you must enter the URL where your certificate is located in the Certificate field.

Certificate

Paste the text for your CA certificate or enter the URL where your certificate is located. This is optional. If you do not want to include a certificate, select No Certificate in the Certificate Format menu.

JSON Query

Enter the JSON query to use in selecting the data you want. Two query methods are available, Find and Aggregate .

As an example, let’s suppose you have a collection with the following data:

{ "_id": 1, "subject": "History", "score": 88 },
{ "_id": 2, "subject": "History", "score": 92 },
{ "_id": 3, "subject": "History", "score": 97 },
{ "_id": 4, "subject": "History", "score": 71 },
{ "_id": 5, "subject": "History", "score": 79 },
{ "_id": 6, "subject": "History", "score": 83 }

Find: You could use the Find method to select from this collection all documents where the subject equals “History.” The query would be formatted as follows:

{ "subject": "History" }

Aggregate: To use the Aggregate method, your query will look something like the following:

[
  {
    $match: {
      score: {
        $gt: 80
      }
    }
  },
  {
    $count: "passing_scores"
  }
]

In this example, the $match stage excludes documents that have a score value of less than or equal to 80 to pass along the documents with a score greater than 80 to the next stage. The$count stage returns a count of the remaining documents in the aggregation pipeline and assigns the value to a field called “passing scores.”

Where Clause JSON

Enter a WHERE clause in JSON format.

Select Clause JSON

Enter a SELECT clause in JSON format.

Group Clause JSON

Enter a GROUP clause in JSON format.

Sort Clause JSON

Enter a SORT clause in JSON format.