Manage the MongoDB Connector

This applies to: Visual Data Discovery

The Symphony MongoDB connector lets you access the data available in MongoDB storage using the Symphony client. The Symphony MongoDB connector supports MongoDB versions 3.4 - 4.4.

The MongoDB connector supports MongoDB views.

Before you can establish a connection from Symphony 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 Visual Data Discovery 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 Data Discovery Dashboards.

Feature Support

Connector support for specific features is shown in the following table.

Key: Y - Supported; N - Not Supported; N/A - not applicable

Feature Supported?
Admin-Defined Functions N
Box Plots N
Custom SQL Queries N
Derived Fields (Row-Level Expressions) Y
Distinct Counts Y
Fast Distinct Values N/A
Group By Multiple Fields Y
Group By Time Y
Group By UNIX Time N
Histogram Floating Point Values Y
Histograms N
Kerberos Authentication N
Last Value N
Live Mode and Playback Y
Multivalued Fields Y
Nested Fields Y
Partitions N/A
Pushdown Joins for Fusion Data Sources N
Schemas Y
Text Search N/A
TLS Y
User Delegation N
Wildcard Filters Y
Wildcard Filters, Case-Insensitive Mode Y
Wildcard Filters, Case-Sensitive Mode Y

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

    • TEXT_TO_NUM
    • TEXT_TO_TIME
    • LTRIM
    • RTRIM

  • 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:

  1. Add parameter ssl=true to your connection string. For example (replace <mongodb_host>, <port>, <database> with your values ): 

    mongodb://<mongodb_host>:<port>/<database>?ssl=true

  2. If your MongoDB data store is configured with a custom certificate, you should configure a truststore for the MongoDB connector:

    1. Copy a truststore to the machine on which the MongoDB connector is running.

    2. Add the following lines to file /etc/zoomdata/edc-mongo.jvm. Copy the file edc-mongo.jvm from the /opt/zoomdata/conf directory if a copy is not in /etc/zoomdata/.

      -Djavax.net.ssl.trustStore=<path_to_truststore>
      -Djavax.net.ssl.trustStorePassword=<truststore_password>

      Replace:

      • <path_to_truststore> with an absolute path to your truststore
      • <truststore_password> with a password for your truststore

  3. Restart the MongoDB connector microservice. See Restart Symphony Microservices.