MongoDB Advanced Connection Strings
For Controller and Gallery 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
Important
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://usernOn-premise, single-node example with SSL/TLS:ame: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