Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

Configure additional properties

Configure additional properties

You can use a MongoDB V2 connection to read from or write to Azure CosmosDB MongoDB API, Amazon DocumentDB, and other non-SSL MongoDB deployments.
You can configure the following optional parameters in the
Additional Properties
field in the connection properties or in the advanced source or target properties to connect to Azure CosmosDB MongoDB API, Amazon DocumentDB, and other non-SSL MongoDB deployments.
Properties that apply to Azure CosmosDB MongoDB API
throughput or maxthroughput
Request units per second for a read or write operation. Expressed in RUs (Request Units). Throughput is a positive integer and a multiple of 100. You can modify the throughput for a read or write operation and depending on the operation, you can configure this property under the advanced source or target properties. If you do not specify a value, the mapping utilizes the configured throughput for the collection. For example, throughput=1000.
You can specify maxthroughput in place of throughput for a MongoDB collection. This property allows you to autoscale the throughput from 10% of maxthroughput to the RUs specified in maxthroughput. For example, if maxthroughput=2000 RUs, the throughput automatically scales from 200 to 2000 RUs based on usage.
You must either specify throughput or maxthroughput based on the throughput mode configured for the Azure Cosmos collection as Azure CosmosDB MongoDB API allows switching between these modes only from the Azure portal.
shardkey
A field or column that MongoDB uses to distribute documents among members of a shard cluster. Use the column as a shard key while creating a new collection. Configure this property under the advanced target properties. For example, shardkey=logid.
Properties that apply to 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. Configure this property under the connection properties. For example, ssltruststorefilepath=<path_of_truststore_file>.
ssltruststorepassword
The password for the truststore file required for secure communication. Configure this property under the connection properties. For example, ssltruststorepassword=<password>.
Properties that apply to sampling
samplesize
Defines the number of documents to scan to infer schema from the MongoDB source. For example, samplesize=100.
Default is 100.
samplemethod
Defines the method to sample documents to infer 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 random documents from MongoDB.
  • all. Scans the entire collection to infer schema.
Other properties
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.

0 COMMENTS

We’d like to hear from you!