Skip to main content

MongoDB Advanced Connection Strings

For Controller and Server UI persistence you can use advanced connection strings to connect to MongoDB. Use advanced connection strings if you require support for these:

  • TLS/SSL

  • Replica Sets

  • Sharding

  • MongoDB Atlas

Importante

If you were using replica sets before the availability of the connection string option (2020.1 release), you have to change to a connection string.

Connection String Tips and Examples

  • Supported connection string parameters are driver dependent. Parameters have to be supported by all below-listed supported drivers to be used in a connection string. Supported driver versions include...

    • c 1.17 (mongoc)

    • c++ 3.6 (mongocxx)

    • c# 2.12 (mongoc#)

  • Special characters in usernames, passwords, or parameter values have to be URL encoded.

Go to the MongoDB Connection String documentation for help formatting your connection string.

On-premise, single-node example with SSL/TLS:

mongodb://username:P%40ssw0rd@hostname.domain.tld:27017/AlteryxService?authSource=databasename&ssl=true

On-premise, replica set, example with SSL/TLS:

mongodb://username:P%40ssw0rd@host01.domain.tld:27017,host02.domain.tld:27017,host03.domain.tld:27017/AlteryxService?authSource=databasename&replicaSet=rs0&ssl=true

Atlas example:

mongodb+srv://username:P%40ssw0rd@host-0-1mngx.mongodb.net/AlteryxService?retryWrites=true&w=majority

On-premise, single-node example with SSL/TLS:

mongodb://username:P%40ssw0rd@hostname.domain.tld:27017/AlteryxGallery?authSource=databasename&ssl=true

On-premise, replica set, example with SSL/TLS:

mongodb://username:P%40ssw0rd@host01.domain.tld:27017,host02.domain.tld:27017,host03.domain.tld:27017/AlteryxGallery?authSource=databasename&replicaSet=rs0&ssl=true

Atlas example:

mongodb+srv://username:P%40ssw0rd@host-0-1mngx.mongodb.net/AlteryxGallery?retryWrites=true&w=majority

On-premise, single-node example with SSL/TLS:

mongodb://username:P%40ssw0rd@hostname.domain.tld:27017/AlteryxGallery_Lucene?authSource=databasename&ssl=true

On-premise, replica set, example with SSL/TLS:

mongodb://username:P%40ssw0rd@host01.domain.tld:27017,host02.domain.tld:27017,host03.domain.tld:27017/AlteryxGallery_Lucene?authSource=databasename&replicaSet=rs0&ssl=true

Atlas example:

mongodb+srv://username:P%40ssw0rd@host-0-1mngx.mongodb.net/AlteryxGallery_Lucene?retryWrites=true&w=majority