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 setting up the connector, create data sources that specify the necessary connection information and identify the data you want to use. See Manage Visual Data Discovery Data Sources for more information. After data sources are configured, they can be used to create dashboards and visuals from your data. See Create 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? |
---|---|
N |
|
N |
|
N |
|
Y |
|
Y |
|
N/A |
|
Y |
|
Y |
|
N |
|
Y |
|
N |
|
N |
|
N |
|
Y |
|
Y |
|
Y |
|
N/A |
|
N |
|
Y |
|
N/A |
|
Y |
|
N |
|
Y |
|
Y |
|
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
-
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
-
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 fileedc-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
-
Restart the MongoDB connector microservice. See Restart Symphony Microservices.
Comments
0 comments
Please sign in to leave a comment.