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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive