MongoDB Connection Manager is SSIS Connection Manager for establishing MongoDB connections.
In this section we will show you how to set up a MongoDB Connection Manager to access a MongoDB Atlas database.
Configure Basic connectivity settings
- Once the connection manager dialog opens in General tab enter Host. In this example, we will be connecting to a MongoDB replica set, thus we use the syntax
host1[:port], host2[:port]...., hostN[:port]:
The value would look like:
- Enter Database.
- Select Basic for Authentication Mode.
- Enter Username.
- Enter Password.
- Enter Authentication DB.
Configure Advanced connectivity settings
- In tab Advanced tab enter Additional Options. The syntax of Additional Options is
name=value1[&name2=value2]...[&nameN=valueN]. The value would look like:
replicaSet=SampleCluster-shard-0&uuidRepresentation=Standard.You can see available options in Available Options text field.
Congratulations! You have successfully configured a MongoDB Connection Manager.
Use the General page of the MongoDB Connection Manager dialog to specify properties for connecting to the MongoDB database
The host name(s) and an optional port (default is 27017) using the syntax
localhost:27017). When connecting to a replica set, its members should be enumerated like this:
The name of the MongoDB database to connect to. Can be skipped if it is the same as the Authentication Database (available only in Basic authentication) or if it is the only one accessible database by the user.
The authentication method:
Value Description Anonymous Don't send any authentication information. Basic Authenticate by username and password. X.509 Authenticate via X.509 certificate (the settings are available in the SSL tab). LDAP LDAP authentication (MongoDB Enterprise only). Kerberos Kerberos authentication (MongoDB Enterprise only).
The username to authenticate with (Basic, LDAP and Kerberos mode)
The password to authenticate with (Basic, LDAP and Kerberos mode)
The database against which the user would be authenticated (Basic mode)
The timeout to attempt a connection before timing out.
Use the SSL page of the MongoDB Connection Manager dialog to specify SSL/TLS settings
Specify whether SSL encryption is enabled/disabled
Specify whether to allow self-signed SSL certificates
Specify whether to check for certificate revocation
The path to the client certificate file (usually *.PFX)
The passphrase for the client certificate
Use the Advanced page of the MongoDB Connection Manager dialog to specify advanced options
Specify additional connection options, when necessary, via the syntax:
name=value1[&name2=value2]...[&nameN=valueN]. Refer to MongoDB documentation for detailed explanation of each option.
In the Host parameter you need to specify all members of the MongoDB replica set using the following syntax
host1[:port],host2[:port]. Then in the Advanced tab, you need to set to add a replicaSet parameter (e.g.
In some MongoDB instances, even if the "Test Connection" indicates that "Test connection succeeded", some operations in the MongoDB Source or MongoDB Destination might fail, due to the default value
CSharplegacyfor GuidRepresentation. To remedy this error, try specifying In the Advanced tab the option
- New: Support for TLS 1.1 protocol and above.
- New: Introduced connection.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.