MongoDB

Overview

Grouparoo’s MongoDB Plugin can work as a source in your data syncing project. MongoDB is a document-oriented database program. It is built to support storage of both structured and unstructured data using a JSON-like format. MongoDB can help companies whose needs are high volume because it can scale to accommodate large amounts of data. You can use Grouparoo to sync data from MongoDB to any of the Destinations we provide plugins for.

Sources

Setup

To work with the MongoDB Plugin, you must first install it in an existing Grouparoo project. Grouparoo supports syncing with Mongo databases stored on a local machine or remotely, provided that there is no firewall or VPN prohibiting the connection. How you connect depends on how you configure the App.

App

To connect MongoDB to Grouparoo, you create an App to tell Grouparoo how to connect to Mongo. This specifies the connection details for the database you want to use while syncing data.

App Options

In Grouparoo, provide the options that best describe how you would like to connect to MongoDB.

MongoDB Import Table

This source reads from a single schema or collection in your MongoDB database using a primary or foreign key. Properties are generated from this table from row values or aggregations of row values.

Options

Mapping

Select a column that uniquely identifies each record in this Source. The Property mapped to this column will be assigned as the Model's Primary Key.

Defining Mappings is a critical part of the process. It tells Grouparoo which Record to associate with the imported data.

If you are using MongoDB Import Table as the primary source, choose the database field that uniquely identifies Records in your Model. This will often be the primary key of the table that represents your Model.

In secondary sources, choose the database field that ties this table to your primary source. This will often be a foreign key in your table.

Schedule

Create a schedule to actively pull new data from this MongoDB table. If the recurring option is not selected, you are creating a one-time sync. There are also options to confirm records exist when running a schedule and to enable refresh. When Recurring is selected, you will see a field for entering the frequency, in minutes, of recurrence.

Options

There is one option to set for a MongoDB Table Import Source. You need to choose the table from your database that will serve as the location for Grouparoo to scan for changes to Properties.

Filters

If there is a subset of data you want to specifically include or exclude from your MongoDB database collection, create a Filter.

Properties

Properties populate your Records with data from your MongoDB collection based on collection fields. Create a Property to be able to use document data from MongoDB in Grouparoo.

Options

Filters

If there is a subset of rows data you want to specifically include or exclude from your MongoDB database collection, create a Filter.

Notes

We strive to keep our documentation accurate, easy to use, and up to date. If you notice that something has changed or is not addressed in the process of setting up your Grouparoo connection with MongoDB, please let us know by reaching out to help@grouparoo.com.

As always, if you need support using Grouparoo, reach out to community members in our Slack channel. We are always happy to help!