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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 111 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 782 Beast Mode
- 76 App Studio
- 43 Variables
- 738 Automate
- 186 Apps
- 473 APIs & Domo Developer
- 65 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 138 Manage
- 135 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive