Connecting to MongoDB Atlas Database from Cloud Data Integration

Back Next

Configure a MongoDB Connection

You must configure a MongoDB connection to connect to a MongoDB database. You can configure a connection on the

Connections

page in Administrator or in a wizard when you configure a mapping.

Perform either of the following steps:

Administrator

, select

Connections

Data Integration

, open a Source or Target transformation in a mapping.

Click

New Connection

The

Connection Details

dialogue appears: This image shows the MongoDb connection details

Configure the following connection details:

Property	Description
Connection Name	The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] \| \ : ; " ' < , > . ? /
Description	Optional. The description of the connection. The description cannot exceed 4,000 characters.
Type	The connection type. Select MongoDB .

Configure the following connection properties:

Property	Description
Runtime Environment	Name of the runtime environment where you want to run the tasks.
Host Name	Host name or IP address of the MongoDB server.
Port	MongoDB server port number. Default is 27017.
User Name	User name to access the MongoDB server.
Password	Password corresponding to the user name to access the MongoDB server.
Database Name	Name of the MongoDB database to connect to.
Additional Connection Properties	Enter one or more JDBC connection parameters in the following format: <param1>=<value>&<param2>=<value>&<param3>=<value> You must provide the JDBC parameters as ampersand-separated key-value pairs. MongoDB Connector supports the following JDBC connection parameters: AuthSource BatchSize connectTimeoutMS DefaultStringColumnLength DmlBatchSize EnableDoubleBuffer EnableTransaction LogLevel LogPath SamplingLimit SamplingStepSize SamplingStrategy For example, DefaultStringColumnLength=512&DmlBatchSize=1000& EnableDoubleBuffer=false&EnableTransaction=true& SamplingLimit=200&SamplingStepSize=2&SamplingStrategy=Backwards If you specify the host name, port number, user name, and password of the MongoDB server in the Additional Connection Properties , the values specified in the Additional Connection Properties takes precedence.
SSL Mode	Specifies whether the Secure Agent establishes a secure connection to the MongoDB server. You can set the SSL Mode to require or one-way to establish an encrypted connection to the MongoDB Atlas server. Default is disabled .
SSL TrustStore Path	Not applicable for MongoDB Connector.
SSL TrustStore Password	Not applicable for MongoDB Connector.