We have an internal system that the mongodb bank is hosted on Digital Ocean.
The connection method for this database is via URI string, we created this connection via Studio 3T, and the configured connection method is DNS Seedlist (mongo+srv connections).
Example URI: mongodb+srv://USER:PASSWORD@HOST?replicaSet=REPLICASET&tls=true&authSource=AUTHSOURCE
In this connection method, the port is not mandatory, but in Qlik Sense it is mandatory.
Has anyone ever experienced this?
They told me about creating an ODBC driver for mongo etc., however, the problem remains the same.
Mongodb version: 6.0.11