跳到主要内容
跳到主要内容

MongoDB Atlas source setup guide

Configure oplog retention​

Minimum oplog retention of 24 hours is required for replication. We recommend setting the oplog retention to 72 hours or longer to ensure that the oplog is not truncated before the initial snapshot is completed. To set the oplog retention via UI:

  1. Navigate to your cluster's Overview tab in the MongoDB Atlas console and click on the Configuration tab.
Navigate to cluster configuration
  1. Click Additional Settings and scroll down to More Configuration Options.
Expand additional settings
  1. Click More Configuration Options and set the minimum oplog window to 72 hours or longer.
Set oplog retention hours
  1. Click Review Changes to review, and then Apply Changes to deploy the changes.

Configure a database user​

Once you are logged in to your MongoDB Atlas console, click Database Access under the Security tab in the left navigation bar. Click on "Add New Database User".

ClickPipes requires password authentication:

Add database user

ClickPipes requires a user with the following roles:

  • readAnyDatabase
  • clusterMonitor

You can find them in the Specific Privileges section:

Configure user roles

You can further specify the cluster(s)/instance(s) you wish to grant access to ClickPipes user:

Restrict cluster/instance acces

What's next?​

You can now create your ClickPipe and start ingesting data from your MongoDB instance into ClickHouse Cloud. Make sure to note down the connection details you used while setting up your MongoDB instance as you will need them during the ClickPipe creation process.