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>
• If you are leveraging the DNS seed list, use a connection string prefix of "mongodb+srv" rather than the standard mongodb. This will be required for Atlas.

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 list, insert, update, and delete function for each collection in the database (if the connecting user account has these privileges). List functions read data from your tables and allow you to display that data in components.

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