Amazon DocumentDB Error: Unable to Connect to Database

Issue

Connection setup tests fail. The following errors appear:

Unable to connect to database. Unknown client failure.

Environment

Connector: Amazon DocumentDB

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Amazon DocumentDB connection page.
2. Select the Setup tab.
3. Click Edit connection.
4. Update the Host and port field with the hostname and port of your primary node.
5. Click Save and Test.

Cause

To connect your Amazon DocumentDB to Fivetran, we need to connect to your database's primary instance. For more information, see our Amazon DocumentDB prerequisites.

This issue occurs when you provide only a replica node hostname without listing the primary node hostname first in your connection configuration.