Zoomdata Version

Connecting to MongoDB

MongoDB v2.6.x and 3.0.x are supported by the Zoomdata connector.

To configure the connector, perform the following steps:

  1. Log into Zoomdata.
    Administrators and users with appropriate access privileges can connect data sources in Zoomdata.
  2. Click the Sources menu item.

Figure 1

  1. Click the MongoDB connector icon.
  2. Specify the name of your source and add a description (if desired). Click Next .

Figure 2

  1. On the Connection page, you define your connection source. You can select an existing connection, if available, or create a new one. To create a new connection, select the Input new credentials option button and specify the credentials in the following fields:

  • Connection Name
  • Host(s) - If you want to connect to MongoDB replica set, specify the IP addresses/host names and port numbers separated by semi-colon (;) in the following format: host1:port1;host2:port2 .
    For example: localhost:27019;localhost:27020
  • DB Name
  • User name and password if your database requires authentication.
  • Password

Click Validate . The validated connection is saved. Click Next .

Figure 3

  1. On the Collections page, select the schema and data collection to use for your charts.
    Select the number of records to sample. That is, specify the number of records to define the data type.

Figure 4

  1. Toggle the Caching option as needed (enabled by default). Access the article How Zoomdata Caches the Data for more information). Click Next to continue.
  2. On the Fields page, create unique label names for the available fields in your data source. These labels will be displayed in the charts. Create unique label names, as needed, for each Label field.  If necessary, change the Type and Default options, select the checkboxes in the Distinct Count column. Configure Filter Display settings for the required fields. Click Next .

Figure 5

  1. On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
  2. On the Charts page, you can:
    • Edit Global Default Settings
    • Select the Standard and, if available, Custom chart styles to be used with the data source
    • Set default parameters  (group-bys, colors, sorting, etc.) for each chart style
    Learn more about how to customize a chart .

Figure 6

  1. Click Finish to save your changes.