Additional connection properties

Sampling properties

samplesize

The number of documents to scan to infer the schema from the MongoDB source.

For example, samplesize=100.

Default is 100.

samplemethod

The method to sample documents to infer the schema from the MongoDB source.

You can specify one of the following methods:

• - firstpage. Scans first n documents from MongoDB where n indicates the sample size. MongoDB determines the ordering of rows for scanning.
• - random. Scans n number of random documents from MongoDB.
• - all. Scans the entire collection to infer the schema.
• - none. Scans the entire collection to write multi-level hierarchical data without flattening from a MongoDB source to a MongoDB target in a mapping. This feature does not apply to mappings in advanced mode.

Non-SSL MongoDB deployments

ssl

Determines if the connection uses SSL or non-SSL.

Set this parameter to false in the connection properties to connect to MongoDB deployments that do not use SSL.

Default is true.

authsource

Allows you to provide the database name against which you can authenticate user credentials.

For example, authsource=testadmin.

Default is admin.

Amazon DocumentDB

ssltruststorefilepath

The absolute path of the truststore file in the Secure Agent machine that contains the keys and certificates required to establish a secure communication.

For example, ssltruststorefilepath= <path_of_truststore_file>

For the serverless runtime environment, specify the following certificate path to the serverless agent directory:

/home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<truststore_filename>

For more information, see Configure SSL for the serverless runtime environment.

ssltruststorepassword

The password for the truststore file required for secure communication.

For example, ssltruststorepassword=<password>.

Bypass schema validation

bypassdocumentvalidation

Determines if the connection bypasses validation rules set for a MongoDB collection when you insert, update, or upsert data to MongoDB.

For example, to bypass validation rules, enter bypassdocumentvalidation=true.

If you do not set this parameter, the MongoDB V2 connection uses validation rules defined for the MongoDB collection when you write data to MongoDB.

For more information, see Bypass schema validation in the MongoDB documentation.