MongoDB

Internal supports the latest versions of MongoDB 3.6, 4.0, 4.2, and 4.4.

How to connect

Display Name: Give your data source a name for use within Internal. 

Connection String: Depending on your MongoDB install, you’ll use one of the following connection strings. 

• Your own managed clusters: mongodb://<username>:<password>@<host>[:port]/<authsource></authsource></host></password></username>
• Cloud mongoDB instances: mongodb+srv://<username>:<password>@<host>/<authsource></authsource></host></password></username>

authSource is the name of your database that contains the authentication information. 

Database: The name of the database (must match).

What happens when you connect

When you connect MongoDB to Internal, we'll generate the following for you automatically:

1. A resource for each collection in the database. Think of these as prebuilt queries, so you don't have to write queries for everything.
2. An insert, update, and delete function for each collection in the database (if the connecting user account has these privileges).
   

MongoDB Pipelines

In some cases, you may want to create a view that combines data from various collections or elevates nested JSON fields to top-level attributes. To accomplish this, create a new MongoDB Resource (a.k.a. MongoDB Pipeline).  

Filtering and Sorting

While Internal enables filtering and sorting on all columns, we recommend indexing columns on large tables to improve performance. Supported operators vary by data type but include =, !=, <, <=",">, >=.</,>