Manage the MongoDB Connector
The Composer MongoDB connector lets you access the data available in MongoDB storage using the Composer client. The Composer MongoDB connector supports MongoDB versions 3.4 - 4.4.
The MongoDB connector supports MongoDB views.
Before you can establish a connection from Composer to MongoDB storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions.
After the connector has been set up, you can create data source configurations that specify the necessary connection information and identify the data you want to use. See Manage Data Source Configurations for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create Dashboards.
Composer Feature Support
MongoDB connector support for specific Composer features is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
MongoDB connectors support derived fields created using most row-level functions, with the following exceptions:
If you are running a version of MongoDB prior to version 4.0, the following text row-level functions are not supported (these functions work for MongoDB version 4.0 and later):
The following restrictions apply to MongoDB 3.4:
- You cannot use a number field with a year pattern as a date field in a row-level expression.
- TIME_ADD intervals cannot be specified for YEAR, QUARTER, or MONTH.
- TRUNCATE_TIME cannot truncate date-time field values to YEAR or QUARTER granularities.
Connect to MongoDB with Configured SSL
To connect to a MongoDB data store with configured SSL:
ssl=trueto your connection string. For example (replace
<database>with your values ):
If your MongoDB data store is configured with a custom certificate, you should configure a truststore for the MongoDB connector:
Copy a truststore to the machine on which the MongoDB connector is running.
Add the following lines to file
/etc/zoomdata/edc-mongo.jvm. Copy the file
/opt/zoomdata/confdirectory if a copy is not in
<path_to_truststore>with an absolute path to your truststore
<truststore_password>with a password for your truststore
Restart the MongoDB connector microservice. See Restart Composer Microservices.
Please sign in to leave a comment.