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).

Note: To connect with Internal, your data source must be publicly accessible, with SSL encryption enabled, and configured to accept connections from Internal’s IP addresses. 

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).
Note: Functions will not be generated if no primary keys are found in the connected database.

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 =, !=, <, <=",">, >=.</,>