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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive