How to connect to a MongoDB replica set?
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)Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
When to connect to MongoDB replica set?
You should connect to MongoDB replica set only when you have multiple hosts.Error Message: Unable to connect to a member of the replica set matching Secondary Preferred
Action: When running my package manually by VS it executes succesfully, but when I run it by SQL Agent job I get the following error message: Unable to connect to a member of the replica set matching Secondary Preferred Error Message: An error ...I got an error "The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard."
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 CSharplegacy for GuidRepresentation. To remedy this ...Where can I find the documentation for the MongoDB Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the MongoDB Connection can be found at the following link. For many of the components you can find ...How to work with composite records handling in a MongoDB destination component.
A composite record models an array item in a MongoDB document. The nested document in such an array usually have the same set of fields, thus they are modeled by a separate input (named after the array element path). For each parent record (e.g. a ...