How to configure a MongoDB Atlas connector

Background: MongoDB Atlas by default requires authentication against the "admin" database on a cluster, which is configured through a "authDb=admin" parameter in the URL. In the Domo connector, additional parameters cannot be used in the host text box, hence why the following process needs to be followed.
MongoDB Atlas Example Setup
The MongoDB Atlas has been setup as the screenshots below.
Cluster setup:
cluster0-shard-00-00-3auem.mongodb.net:27017,cluster0-shard-00-01-3auem.mongodb.net:27017,cluster0-shard-00-02-3auem.mongodb.net:27017/test?ssl=true&replicaSet=Cluster0-shard-0&authSource=admin&retryWrites=true&w=majority
Database and Collection Setup:
Domo Connector Setup
Credentials Section:
Pick one of the clusters in the connection string given by MongoDB Atlas and enter the cluster address part only as your hostname.
The database needs to be the authentication database, by default in MongoDB Atlas this is admin.
Enter your username and password.
The default port number is 27017, set to your own if it has been customised.
Details Section:
Ensure that the collection is in the format of DatabaseName.CollectionName, to ensure that Domo attempts to connect to the right Database and Collection and will not attempt to look for a collection under the authentication database.
The query method and remainder of settings depends on what you are fetching, use the below settings as a basic test.
Resulting Domo Dataset
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive