MongoDB Connection Manager is SSIS Connection Manager for establishing MongoDB connections.
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 host[:port] (e.g. localhost:27017). When connecting to a replica set, its members should be enumerated like this: host1[:port],host2[:port]...,hostN[:port].
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 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. replicaSet=my-replica-set)
In some MongoDB instances, even if the "Test Connection" indicates that "Test connection succeeded", some operations in the MongoDB Source or Destination might fail, due to the default value CSharplegacy for GuidRepresentation. To remedy this error, try specifying In the Advanced tab the option uuidRepresentation=Standard
- 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.