How to configure a MongoDB Atlas connector

Atanas
Atanas Sydney, Australia

domo

💎

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

Screen Shot 2019-06-04 at 12.06.21 PM.png

 

Database and Collection Setup:

Screen Shot 2019-06-04 at 12.04.55 PM.png

 

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.

 

Screen Shot 2019-06-04 at 12.26.23 PM.png

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.

Screen Shot 2019-06-04 at 12.28.31 PM.png

 

Resulting Domo Dataset

Screen Shot 2019-06-04 at 12.30.32 PM.png