Connections for INFACore > Connections to source and target endpoints > MongoDB
  

MongoDB

Create a MongoDB connection to read from or write to MongoDB.

Feature snapshot

Operation
Support
Read
Yes
Write
Yes

Before you begin

Before you configure the connection properties, you'll need to get information from your MongoDB Atlas account.
The following video shows you how to get information from your MongoDB Atlas account:
https://infa.media/3R0Luqg

Connection properties

The following table describes the MongoDB connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
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
The JDBC connection parameters required in a MongoDB connection.
Enter one or more JDBC connection parameters in the following format:
<param1>=<value>&<param2>=<value>&<param3>=<value>
Provide the JDBC parameters as ampersand-separated key-value pairs.
Configure the following JDBC connection parameters in a MongoDB connection:
  • - 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
SSL Mode
SSL mode indicates the encryption type to use for the connection.
Note: Set it to Required for connecting to MongoDB Atlas.
SSL Truststore Path
Not applicable for MongoDB Connector.
SSL Truststore Password
Not applicable for MongoDB Connector.
*If you specify the host name, port, user name, and password of the MongoDB server in the connection properties and also in the additional connection properties field, the values in the additional connection properties take precedence.
For more information about configuring the MongoDB JDBC connection parameters, see the Informatica How-To Library article, "Configuring the Simba MongoDB JDBC Driver Options for MongoDB Connector":
https://docs.informatica.com/integration-cloud/cloud-data-integration-connectors/h2l/configuring-the-simba-mongodb-jdbc-driver-options-for-mongodb-co/abstract.html