Manage the MongoDB Connector

Describes the MongoDB connector.

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

The MongoDB connector supports MongoDB views.

Before you can establish a connection from Self-Service Analytics to MongoDB storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions.

After setting up the connector, create data sources that specify the necessary connection information and identify the data you want to use. See Create and Manage Data Sources for more information. After you set up your data sources, create dashboards, self service reports, and visuals from the data in these data sources.

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

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 Microservices.