You have two options when configuring a connection in the MongoDB Output step: configure using a connection string or configure using fields.
Connection String
To configure using a connection string, select the Connection String option and enter a connection string containing the information for connecting to MongoDB in the text box provided. Verify that your connection is working by clicking Test Connection. For information about the connection string formats and options, see the MongoDB documentation.
Some common connection string example formats are listed in the following table:
| Connection Type | Connection string format |
|---|---|
| SSL | mongodb://<hostname>:<port>/?tls=true |
| SSL and LDAP | mongodb://<username>:<password>@<hostname>:<port>/?tls=true&authSource=$external&authMechanism=PLAIN |
| LDAP | mongodb://<username>:<password>@<hostname>:<port>/?authSource=$external&authMechanism=PLAIN |
| SSL and LDAP cluster servers with replicaSet options | mongodb://<username>:<password>@<hostname>:<port>/?tls=true&authsource=$external&authMechanism=PLAIN&replicaSet=rs0 |
| SSL and LDAP with replicaSet and readPreference options | mongodb://<username>:<password>@<hostname>/?tls=true&authSource=$external&authMechanism=PLAIN&replicaSet=rs0&readPreference=secondary |
| Kerberos | mongodb://<service-principal>@<hostname>:<port>/?authSource=$external&authMechanism=GSSAPI |
| Kerberos and SSL | mongodb://<service-principal>@<hostname>:<port>/?authSource=$external&authMechanism=GSSAPI&tls=true |
| Atlas Cloud/SAAS | mongodb+srv://<username>:<password>@mycluster.qj8y0.mongodb.net/myFirstDatabase?retryWrites=true&w=majority |
Configure Fields
If you select Configure Fields, enter the your connecton information in the following fields.
| Field | Description |
|---|---|
| Host name(s) or IP address(s) | Specify the network name or address of the MongoDB instance(s). You can also specify a different port number for each host name by separating the host name and port number with a colon. You can input multiple host names or IP addresses, separated by a comma. |
| Port | Specify the port number of the MongoDB instance or instances. Use this to specify a default port if no ports are given as part of the host name(s) or IP address(es) field. The default value is 27017. |
| Enable SSL connection | Specify to connect to a MongoDB Server that is configured with SSL. |
| Use all replica set members/mongos |
Select to use all replica sets when multiple hosts are specified in the Host name(s) or IP address(s) field. If a replica set contains more than one host, the Java driver discovers all hosts automatically. The driver connects to the next replica set in the list if the set you try to connect to is down. |
| Authentication database | Specify the authentication database. |
| Username | Specify the username required to access the database. If you want to use Kerberos authentication, enter the Kerberos principal in this field. |
| Password | Specify the password associated with the username. If you are using Kerberos authentication, you do not need to enter the password. |
| Authenticate Mechanism | Select the method used to verify the identity of users. The values are SCRAM-SHA-1, MONGODB-CR, and PLAIN. |
| Authenticate using Kerberos | Select to specify authentication using Kerberos. |
| Connection timeout | Specify (in milliseconds) how long to wait for a connection to a database before terminating the connection attempt. Leave blank to never terminate the connection. |
| Socket timeout | Specify (in milliseconds) how long to wait for a write operation before terminating the operation. Leave blank to never terminate the operation. |