MongoDB Connector 6.2

Anypoint Connector for MongoDB (MongoDB Connector) is a closed-source connector that provides a connection between the Mule runtime engine (Mule) and third-party software on a MongoDB server.

Release Notes: MongoDB Connector Release Notes
Exchange: MongoDB Connector

Before You Begin

To use this connector, you must be familiar with MongoDB, Mule runtime engine (Mule), Anypoint Connectors, Anypoint Studio, elements in a Mule flow, and global elements.

Before creating an app, you must have access to the MongoDB target resource and Anypoint Platform. You must also understand how to create a Mule app using Anypoint Studio.

To use the this connector, you need:

A MongoDB instance
A set of valid credentials, including the required MongoDB endpoints that point to your instance

Audience

New user

To create your Mule app, see Studio Configuration.
Advanced user

Read XML and Maven Support and Examples.

Exchange Example

Anypoint Exchange has an example that shows how to import data in a CSV format from a local directory into MongoDB.

Important Date Handling Considerations

When using MongoDB Connector, consider the following date-handling behavior:

Automatic conversion to UTC

MongoDB Connector converts dates (whether sent to or retrieved from MongoDB) to UTC before storage for consistent date handling in distributed environments.
ISO 8601 format

Dates (whether they are sent to or retrieved from MongoDB) in JSON documents are transformed to the ISO 8601 format. Additionally, any String values in JSON documents that match the ISO 8601 format are automatically transformed and stored as Date types in MongoDB. This change ensures more consistent and standardized date handling in a distributed environment.
Millisecond truncation

Dates (whether sent to or retrieved from MongoDB) that include milliseconds with a value of .000 are not shown in connector output.

Here is an example of date handling in a Mule app:

Input:

{
  "timeStamp": "2024-06-17T16:44:17.000+01:00"
}

Mule 4:

{
  "timeStamp": "2024-06-17T15:44:17+00:00"
}

Because of these changes in date handling, it is important to:

Review flows involving dates

If your Mule apps rely on specific timezones of dates stored in MongoDB, you must review and possibly adjust flows to correctly handle the UTC conversion.
Test thoroughly

Conduct thorough testing in a controlled environment to ensure that the changes in date handling do not negatively impact the expected behavior of the Mule app.
Document the behavioral differences

Review these date-handling details to ensure correct behavior in your application.

Next Steps

After you complete the prerequisites and experiment with the example, you are ready to create an app with Studio.