Intro
MongoDB is an open-source document-oriented database that offers high performance and serious scalability. Domo’s platform offers a best-in-class analytics and reporting solution for MongoDB users—helping organizations monitor, visualize, and report complex datasets easily. You can use Domo’s MongoDB Advanced Connector to pull data from a MongoDB collection. This connector supports an advanced connection with your MongoDB, to bring fresh data. Building customer reports indicates the data you want by entering JSON queries. Easily combine your MongoDB data with the data from numerous other systems, which enables you to combine and transform your data and make it all available for user self-service. Domo’s advanced governance capabilities provide IT control over what users will have access to, and the ones for experts. Domo also brings report-building to your fingertips with an easy-to-use interface and robust reporting capabilities. Create completely customized dashboards that include the metrics, filters, and visualizations users want. You can connect to your MongoDB Advanced account in the Data Center. This topic discusses the fields and menus that are specific to the MongoDB Advanced connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.Prerequisites
To connect to your MongoDB Advanced account and create a DataSet, you need the following:- Hostname for MongoDB database
- MongoDB database
- MongoDB Username and Password
- Port number for the database
- Select a Certificate Format
Connecting to Your MongoDB Advanced Account
This section enumerates the options in the Credentials and Details panes on the MongoDB Advanced Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.Credentials Pane
This pane contains fields for entering credentials to connect to your MongoDB Advanced account. The following table describes what is needed for each field:Field | Description |
|---|---|
| Host | Enter the host name for the MongoDB database (for example, db.company.com ). If you don’t know the host name, then contact your MongoDB Database Administrator. |
| Database Name | Enter the name of the MongoDB database. If you don’t know the database name, then contact your MongoDB Database Administrator. |
| Username | Enter your MongoDB username. If you don’t know your username, then contact your MongoDB Database Administrator. |
| Password | Enter your MongoDB password. If you don’t know your password, then contact your MongoDB Database Administrator. |
| Database Port | Enter the port number for the database. If you don’t know the port number, then contact your MongoDB Database Administrator. |
| Certificate Format | Select a certificate format. This must match what you enter in the Certificate field. If you are unaware of a special certificate, then select No Certificate . |
| Certificate | Paste the text for your CA certificate or enter the URL where your certificate is located. By default, no certificate is required. |
Details Pane
| Menu | Description |
| Collection | Enter the name of the collection for which you want to connect. \nIf wanting to connect to a database other than the one where authentication occurs, then enter the other database name prior to the collection. For example, database.collection \n If collection contains a period, then enter the collection surrounded by quotes and square brackets, example, [” collection.name ”]”. |
| JSON Query | Enter your Mongo JSON query. |
| Where clause JSON | Enter your Where clause JSON. |
| Select clause JSON | Enter your Select clause JSON. |
| Group clause JSON | Enter your Group clause JSON. |
| Sort clause JSON | Enter your Sort clause JSON. |
| Flatten Sublists | Select this check box if you want the columns that contains the lists to be flattened. |